SELECT object_name, created
FROM user_objects
WHERE ROWNUM < 11;
 
 
clear screen
 
short form -
cl scr
 
 
Column Separators 
SET colsep ','
 
SELECT *
FROM user_tables
WHERE ROWNUM < 5
/
 
 
 
Display Headers 
SELECT * FROM user_tables;
 
SET head off
 
SELECT * FROM user_tables;
 
SET head ON 
 
 
 
 
Line Size SET LINESIZE <integer> 
SELECT text
FROM all_source
WHERE ROWNUM < 11;
 
SET linesize 121
 
SELECT text
FROM all_source
WHERE ROWNUM < 11; 
 
 
SELECT COUNT(*)
FROM all_objects
WHERE SUBSTR(object_name,1,1) BETWEEN 'A' AND 'W';
 
SET timing ON
 
 
 
envoke editor TO edit previous command
 
ed