Hi Tom,
Could you please show us how do you set the font-size/colors in SQLPLUS.exe?

Cheers!
Abhijit

Hi Tom,

I would like to use iSQLPlus , if at all such an exe exists..because i read somewhere that there's a new WEB enabled SQLPlus with Oracle 9i..but i never really saw it in the Oracle's BIN directory...


How do i install the new WEB sqlplus?


Thanks

You can change the font in SQL*Plus for Windows NT/2000.

In regedt32, go to
HKEY_LOCAL_MACHINE
-> SOFTWARE
-> ORACLE
-> HOME0

Create a new registry value called SQLPLUS_FONT of type REG_EXPAND_SZ and set it to your favourite fixed-width font, Eg. Courier New

Create a new registry value called SQLPLUS_FONT_SIZE of type REG_EXPAND_SZ and set it to the size you want (16 is a good size).

Exit from the registry and try to log-on to SQL-Plus and see if the font size is any different.

This has worked for me on Oracle 8.1.7. I have not tried on other releases.

I found this tip on the web.

Tom:

Is there a way to make sql*plus output wrap columns on he same page. for exampl if I have 6 columns it will print:

COL1 COL2 COL3
xxx xxx xxxx

COL4 COL5 COL6
xxx xxx xxxx

Currently I use set linesize 2000 and I keep scrolling inside the window to see all data

Hi tom,

I just want to know in the
"
SQL*Plus User's Guide and Reference
Release 8.1.7
Part Number A82950-01
"

There are lots of commands, that we can use in sqlplus

does sql * plus submit the same string as typed
to the orace datadbase server or
parse it
process it and if required convert it in the query
get the result set or error code and msg.
format it ( based on all "SET" options
display it

so just to describe the table scott.emp,
how much work is done ?
1.) parse the stmt
2.) get the key word 'DESC' or 'DESCRIBE' upper or lower
case only >=4 chars are allowed in command
3.) search if the keyword is found in some keyword table
4.) if not found get oracle error or based on key word,
query 1 or 2 datadictionary views
5.) handle the resultset
6.) veryfy all the setting of curret setting
set,compute etc..
7.) check for pause
8.) display result ?

is it true or you have a smart way to do it ?

so any other editor like oracle worksheet(OEM),toad,pl/sql developer does that same thing ?

TIA

Another nice thing about the command line version is that one can use the "doskey" function there, which is nice for re-executing one-liners or alter session type commands.

Sir,

I wrote the follwoing SQL in SQLPLUS

SELECT 'ABC & DEF' FROM DUAL


what i want from above SELECT is the string "ABC & DEF"

but when i execute the sql, it starts asking me for
the input value. How can i print the above string in
sqlplus

Thanks

SQL> set define off 

Thanks, but i was just thinking what if i need
an input also

e.g

SELECT 'ABC & DEF' || name2 FROM t1 where name1= &m_name1.

I want the user to input name1 every time the query
executes, if I set define off then it doesnt ask for
input.

Thanks

TOm:

1. Is there anything in SQL*plus that you set to wrap full description around in the fixed colum size. For example, if i select :

select stock_no,description,qty from table;

stock_no description qty

I want to see full description(e.g. 5 lines) wrapping within a fixed I set for "description".

2. Would this work if i have the query in a VIEW?

Thank you

Hi tom, 

I have written the follwoing code in a file xyz.sql

create or replace procedure empvu_process
is
    v_sal number;
begin
     select sal
     into v_sal 
     from emp_vu
     where empno=7566;
     dbms_output.put_line('The salary is:'||v_sal);
end;
/
SQL> @xyz
Input truncated to 1 characters

Procedure created.

SQL> exec empvu_process
The salary is:2975

PL/SQL procedure successfully completed.

What is the meaning of "Input truncated to 1 characters". Sometimes it appears while displaying output in our Oracle Apps reports. How to supress this message?
Thanks in Advance...
 

Tom:

Is there a link between the SQL prompt and using print_table script.  I re-created the login.sql but now the print_table does not print as it used to. 
SQL> execute print_table('select * from req where req_no=2058');

PL/SQL procedure successfully completed.

Also the SQL header repeat itself several times for every line of data when i do a sql query for one record.

select * from table where req_no=1;
 

Tom:

that solved one problem.

What about the issue of the result header that keeps repeating. How do i show this only one at the top of the result set.

Tom:

If i did select * from table it will

name height length length gender

and then again (listing remaing data)

name height length age gender

this is what I meant. Howw can I set SQL plus to only list results header once.

Thank you,

SQL> set pagesize nnnn

(all of the sql plus stuff is documented

Mo,

"set pagesize 0" will do want you want...

- Mark

I am just about certain that setting pagesize to 0 used to work... however, I just tried it and it did not...

- Mark

set pagesize 50000 (which is the max value I think)

Tom,

How can any one print the query results from SQL PLus to Printer directly?

desc <Table Name> should be sent to Printer. How?

Thanks for your time and valuable Inputs.

Sincerely

Can you explain what is the difference between spool off and spool out?
SQL> host sqlplus -v

SQL*Plus: Release 9.2.0.1.0 - Production


SQL> help spool

 SPOOL
 -----

 Stores query results in an operating system file, or sends the
 file to a printer.
 In iSQL*Plus, output can be directed to a file.

 SPO[OL] [file_name[.ext] | OFF | OUT]

 Not available in iSQL*Plus
 

I am running one query in isqlplus ,the query is

select '123 456' from dual; --Note there are 5 spaces

the output is shown below.Here the 5 spaces between 123 and 456 are removed and only one space is shown. As we know this query works perfectly in sqlplus client.

---------------
123 456

Does anybody knows the way to prevent this in isqlplus?