xda kja dalam Lab database

C:\Users\student>sqlplus myclass/abc123



SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 25 20:58:13 2010



Copyright (c) 1982, 2005, Oracle. All rights reserved.





Connected to:

Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production



SQL> select table_name from user_tables;



TABLE_NAME

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

STATE

FRIENDS



SQL> desc state;

Name Null? Type

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

STATE_ID NOT NULL NUMBER(2)

STATE_NAME NOT NULL VARCHAR2(50)



SQL> desc friends;

Name Null? Type

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

NAME NOT NULL VARCHAR2(50)

PHONE_NO NOT NULL CHAR(10)

SIBLING NUMBER(2)

FRIEND_NO NOT NULL NUMBER(3)

STATE_ID NUMBER(2)

DON NUMBER(2)



SQL> desc user_constraint;

ERROR:

ORA-04043: object user_constraint does not exist





SQL> desc user_constraints;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

CONSTRAINT_NAME NOT NULL VARCHAR2(30)

CONSTRAINT_TYPE VARCHAR2(1)

TABLE_NAME NOT NULL VARCHAR2(30)

SEARCH_CONDITION LONG

R_OWNER VARCHAR2(30)

R_CONSTRAINT_NAME VARCHAR2(30)

DELETE_RULE VARCHAR2(9)

STATUS VARCHAR2(8)

DEFERRABLE VARCHAR2(14)

DEFERRED VARCHAR2(9)

VALIDATED VARCHAR2(13)

GENERATED VARCHAR2(14)

BAD VARCHAR2(3)

RELY VARCHAR2(4)

LAST_CHANGE DATE

INDEX_OWNER VARCHAR2(30)

INDEX_NAME VARCHAR2(30)

INVALID VARCHAR2(7)

VIEW_RELATED VARCHAR2(14)



SQL> select table_name, constraint_name, constraint_type from user_constraints;



TABLE_NAME CONSTRAINT_NAME C

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

STATE SYS_C006995 C // other constraints

FRIENDS SYS_C006994 C

FRIENDS SYS_C006993 C

FRIENDS PK_FRIEND_ID P // primary key

STATE PK_STATE_ID P



SQL>
 
 
 
 
 
 
//this is best and fulfill my desire actually
//anybody interested call me immediately .. haha