SQL> grant connect,resource to dungnc identified by oracle123;
Grant succeeded.
SQL> conn dungnc/oracle123;
Connected.
SQL> create table test (id number);
Table created.
SQL> conn / as sysdba
Connected.
SQL> select dbms_metadata.get_ddl('TABLE','TEST','DUNGNC') from dual;
DBMS_METADATA.GET_DDL('TABLE','TEST','DUNGNC')
--------------------------------------------------------------------------------
CREATE TABLE "DUNGNC"."TEST"
( "ID" NUMBER
) SEGMENT CREATION DEFERRED
Không có nhận xét nào:
Đăng nhận xét