Solved

Remove blank lines from SQL Plus

Posted on 1998-06-19
3
2,208 Views
Last Modified: 2008-02-01
How to remove blank lines from SQL PLUS. When you are executing the SQL Statements.
It shows like this
SQL > Select * ....
                       --- This line has to be removed
aa    ssd    sdd
0
Comment
Question by:vphilip
  • 2
3 Comments
 
LVL 4

Expert Comment

by:sganta
ID: 1083193
You say
SET EMBEDDED ON
0
 

Author Comment

by:vphilip
ID: 1083194
sganta !

Can you explain me in detail.
0
 
LVL 4

Accepted Solution

by:
sganta earned 50 total points
ID: 1083195
embedded will replace the lines

You execute on SQLPLUS Prompt

These are options to set.
SQL> SET EMBEDDED ON
SQL>  you enter your query here .....
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question