Advertisement
jomjoma

DbLab

Dec 28th, 2016
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/INDEX.html#
  2.  
  3. username = ericxxp@gmail.com
  4. password = Abcabc123
  5.  
  6.  
  7.  
  8.  
  9. CONNECT SYSTEM
  10.  
  11. CREATE USER ericxxp IDENTIFIED BY abc123;
  12.  
  13. GRANT CONNECT, RESOURCE, DBA TO ericxxp;
  14.  
  15. GRANT CREATE SESSION  TO ericxxp;
  16.  
  17. GRANT UNLIMITED TABLESPACE TO ericxxp;
  18.  
  19. CONNECT ericxxp
  20.  
  21. CREATE TABLE students (
  22.   id      NUMBER(10)    NOT NULL,
  23.   title   VARCHAR2(100) NOT NULL
  24. );
  25.  
  26.  
  27. ALTER TABLE students
  28.   ADD (
  29.     CONSTRAINT students_pk PRIMARY KEY (id)
  30.   );
  31.  
  32. CREATE SEQUENCE students_id;
  33.  
  34.  
  35.  
  36. SELECT tablespace_name, table_name FROM user_tables;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement