Oracle sqlplus command line tools does not support command line editing out-of-the-box. But on Linux there's a handy utility that enables command line editing with any command line tool: rlwrap - readline wrapper. Install rlwrap: $ sudo apt-get install rlwrap Create a keywords file .sql.dict (optional, but convenient): false null true access add as asc begin by chec... It would be nice to add the tables names also. Create an alias for sqlplus (put it in .bashrc ): alias sqlplus='rlwrap -f $HOME/.sql.dict sqlplus'

C:\>sqlplus sys@xe as sysdba SQL*Plus: Rele...

Operations Privileges Required CREATE/DROP/MONITOR own queues Must have EXECUTE rights on DBMS_AQADM ENQUEUE/DEQUEUE to own queues Must have EXECUTE rights on DBMS_AQ ENQUEUE/DEQUEUE to other's queues Must have EXECUTE rights on DBMS_AQ Queue owner must grant privileges using DBMS_AQADM.GRANT_QUEUE_PRIVILEGE CREATE/DROP/MONITOR any queues Must have EXECUTE rights on DBMS_AQADM Must be granted AQ_ADMINISTRATOR_ROLE ENQUEUE/DEQUEUE to any queues Must have EXECUTE rights on DBMS_AQ Must be granted " ENQUEUE_ANY " or " DEQUEUE_ANY " system privileges using DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE Examples: -- Create an admin CREATE ROLE MY_AQ_ADMIN_ROLE...

Create a synonym: -- create a private synonym CREATE SYNONYM emp ... Remove a synonym: -- Drop public synonym DROP PUBLIC SYNONYM emp;... View synonyms: select * from dba_synonyms where TABLE_OWNER = 'SC...

SQL> drop table update_queue_tab; drop table up... Following a tip on dbaforums.org , I entered alter session set events '10851 trace name context... And was able to drop the table with drop table update_queue_tab

-- Drop both package spec and body -- SCHEM...

-- To drop a procedure DROP PROCEDURE my_test_p...

Drop one column: alter table my_table drop column column1; Drop two columns: -- no column keyword here alter table my_table...

This is the syntax to drop a foreign key: ALTER TABLE my_table DROP CONSTRAINT fk_my_fore...

alter table my_table modify the_column null;