Monthly Archives: July 2012

Use the following statement:sqlplus <username>/<password>@<host>:<instance>If you want to directly without username/password, you must belong to usergroup ora_dba (windows):sqlplus / as sysdba

Use the following statements as an example:Create table test_items (item_id number, item_desc varchar2(20), item_attrib varchar2(100));Alter table test_items add constraint no_double_codes unique(item_desc, item_attrib);

Here is how to track a transaction's progress:select t.used_urec, --> if increasing, then the transaction is moving forward, otherwise is rolling back t.start_time, sysdate - to_date(t.start_time,'dd/mm/yy hh24:mi:ss') date_diff, s.sid,s.serial#, s.username,…