Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/INDEX.html#
- username = ericxxp@gmail.com
- password = Abcabc123
- CONNECT SYSTEM
- CREATE USER ericxxp IDENTIFIED BY abc123;
- GRANT CONNECT, RESOURCE, DBA TO ericxxp;
- GRANT CREATE SESSION TO ericxxp;
- GRANT UNLIMITED TABLESPACE TO ericxxp;
- CONNECT ericxxp
- CREATE TABLE students (
- id NUMBER(10) NOT NULL,
- title VARCHAR2(100) NOT NULL
- );
- ALTER TABLE students
- ADD (
- CONSTRAINT students_pk PRIMARY KEY (id)
- );
- CREATE SEQUENCE students_id;
- SELECT tablespace_name, table_name FROM user_tables;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement