SQL> PASSWORD

Changing password for LIUJ

ERROR:

ORA-00988: missing or invalid password(s)

Password unchanged

SQL> CREATE TABLE test_liuj (

2 sID int,

3 sName char(10)

4 );

Table created.

SQL> select * from user_tables

2 ;

TABLE_NAME TABLESPACE_NAME

------------------------------ ------------------------------

CLUSTER_NAME IOT_NAME STATUS

------------------------------ ------------------------------ --------

PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT

---------- ---------- ---------- ---------- -------------- -----------

MIN_EXTENTS MAX_EXTENTS PCT_INCREASE FREELISTS FREELIST_GROUPS LOG B NUM_ROWS

----------- ----------- ------------ ---------- --------------- --- - ----------

BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT AVG_ROW_LEN

---------- ------------ ---------- ---------- -----------

AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS DEGREE INSTANCES CACHE

------------------------- ------------------- ---------- ---------- -----

TABLE_LO SAMPLE_SIZE LAST_ANAL PAR IOT_TYPE T S NES BUFFER_ ROW_MOVE GLO USE

-------- ----------- --------- --- ------------ - - --- ------- -------- --- ---

DURATION SKIP_COR MON CLUSTER_OWNER DEPENDEN COMPRESS

--------------- -------- --- ------------------------------ -------- --------

DRO

---

TEST_LIUJ USERS

SQL> describe test_liuj

Name Null? Type

----------------------------------------- -------- ----------------------------

SID NUMBER(38)

SNAME CHAR(10)

SQL> insert into test_liuj values (1200, 'jinze liu');

1 row created.

SQL> select * from test_liuj

2 ;

SID SNAME

---------- ----------

1200 jinze liu

SQL> insert into test_liuj values (1211, 'Sarah');

1 row created.

SQL> select * from test_liuj

2 ;

SID SNAME

---------- ----------

1200 jinze liu

1211 Sarah

SQL> select * from test_liuj where sid = 1211

2 ;

SID SNAME

---------- ----------

1211 Sarah

SQL> select * from test_liuj where sname = 'Sarah';

SID SNAME

---------- ----------

1211 Sarah

SQL> insert into test_liuj values(1233, 'John Doe');

1 row created.

SQL> select * from test_liuj

2 ;

SID SNAME

---------- ----------

1200 jinze liu

1211 Sarah

1233 John Doe

SQL> CREATE TABLE to_be_dropped (

2 tid int primary key,

3 tname char(20)

4 );

Table created.

SQL> DESCRIBE to_be_dropped

Name Null? Type

----------------------------------------- -------- ----------------------------

TID NOT NULL NUMBER(38)

TNAME CHAR(20)

SQL> DROP TABLE to_be_dropped;

Table dropped.

SQL> select * from user_tables;

TABLE_NAME TABLESPACE_NAME

------------------------------ ------------------------------

CLUSTER_NAME IOT_NAME STATUS

------------------------------ ------------------------------ --------

PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT

---------- ---------- ---------- ---------- -------------- -----------

MIN_EXTENTS MAX_EXTENTS PCT_INCREASE FREELISTS FREELIST_GROUPS LOG B NUM_ROWS

----------- ----------- ------------ ---------- --------------- --- - ----------

BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT AVG_ROW_LEN

---------- ------------ ---------- ---------- -----------

AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS DEGREE INSTANCES CACHE

------------------------- ------------------- ---------- ---------- -----

TABLE_LO SAMPLE_SIZE LAST_ANAL PAR IOT_TYPE T S NES BUFFER_ ROW_MOVE GLO USE

-------- ----------- --------- --- ------------ - - --- ------- -------- --- ---

DURATION SKIP_COR MON CLUSTER_OWNER DEPENDEN COMPRESS

--------------- -------- --- ------------------------------ -------- --------

DRO

---

TEST_LIUJ USERS

SQL> exit