Oracle Commands

  • To see list of all existing users:

select * from DBA_USERS

  • To see list tables for a given user:

select table_name from ALL_TABLES WHERE OWNER='ARTEM49'

  • To create a new table:


CREATE TABLE signup

(

userid NUMBER(6),

day VARCHAR2(20),

in1 VARCHAR2(25),

out1 VARCHAR2(25)

  • Sample insert statement:
insert into signup values(1, 'd', 'Tuesday', 'Saturday')
  • To retrieve the version of Oracle:

select * from v$version where banner like 'Oracle%';

  • Update statement example:
update signup set out1='Thursday' where in1='Wednesday'