Wednesday 24 April 2013

TO DROP THE USERS/ To check the user design


TO DROP THE USERS;



drop user LA cascade;
 


 To check the user design

SQL> set lines 160
set pages 10000
set long 20000
SELECT dbms_metadata.get_ddl('USER', 'LA') FROM dual;

TO CREATE TABLE
create table test_1 (name varchar2(10));

No comments:

Post a Comment