Oracle SQL Commands

1
Oracle SQL Commands

• alter user username identified by new
  password
• note change the password of user username to
  newpassword
• select table_name, table_type from user_catalog
• drop table tablename

2
Oracle SQLPlus editing Commands
Command Activity
a text Add text at end if current line
Type the line number Change current line
c / old / new Change text in current line
cl buff Delete all lines from buffer
del Delete current line
i Insert a line following current line
l List the command currently in the buffer
r Run the command currently in the buffer