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
No comments:
Post a Comment