Customizing your SQL* Plus environment with your preferences is easy enough on startup.
Customizing your SQLPlus environment with your preferences is easy enough on startup. There are two files: First, sqlplus searches for […]
Customizing your SQLPlus environment with your preferences is easy enough on startup. There are two files: First, sqlplus searches for […]
add this to $ORACLE_HOME/sqlplus/admin/glogin.sql — setup a prompt with user name and connect set sqlprompt “_user’@’_connect_identifier > ” — set
set autotrace on statistics; set linesize 150 pagesize 1000; explain plan for select distinct object_name from dba_objects; select * from
Here is a easy example of a sql script that generates sql statements and then executes them. Hope it helps.