Top "Sqlplus" questions

SQL Plus command line: Arrow keys not giving previous commands back

I am using Oracle 10g Express Edition on Fedora core 5 32+ bit os. The problem is when I use the SQL …

linux sqlplus

dbms_output size buffer overflow

I tried to set the dbms_output size to unlimited inside a stored procedure. But it gave me compilation errors. …

oracle plsql oracle10g sqlplus dbms-output

sqlplus remove \r \n \t from spool

Is there any sql*plus command to remove \r \n and\t from the result set that's going out to …

oracle sqlplus trim oracle8i

Can't login as sysdba in oracle sqlplus

'hello I am trying to login locally installed oracle 11g database from my windows machine using system / as sysdba Its …

oracle plsql sqlplus sysdba

Hide SQL > statements in the spool file

I want to hide the "SQL> @test.sql" and "SQL> spool off" in the file test.txt(spool …

oracle sqlplus spool

execute immediate truncate table in sqlplus

Why does execute immediate 'truncate table trade_economics'; in a sqlplus script give the following error ? BEGIN immediate 'truncate table …

sqlplus truncate execute-immediate

Shell script to email results of SQLPlus query using Mailx in AIX

I have the commands that I need. If I execute these commands at the prompt, everything works as expected. SQLPlus …

shell sqlplus aix mailx

Remove leading spaces and the SQL> tags when spooling

I m doing an export using SQL*Plus using the following code: Set echo off Set verify off Set feedback …

sql oracle formatting sqlplus spool

Oracle imp and exp commands

Normally when i have to take a backup of of a database on unix, i do, exp DBUSER/DBPSW@INST …

oracle unix sqlplus exp imp

Default value for paramteters not passed SQLPlus script

Is there a way to set default value of paramter in sqlplus script without user input? For example, I have …

oracle sqlplus