![]() ![]() | ||||||
| Home>>> | ||||||
OracleOracle offer light XE editions, you can install on your home PC if you need to test something out. Quick Table of Contents1. sqlplusStarting sqlplusUse the command line and type 'sqlplus user/passs' or click on "Run SQL Command Line" Commandsconnect
connect <user>/<password>;
where <password> is your password and <user> is your username. 2. User ManagementStart the HTML administration site. Go to Home -> Administration -> Manage Database Users -> Create Database User 3. useful SQLList all tables
select * from tabs where table_name = 'BAS_PAYMENTS';
List all sequencesUse the all_sequences view.
SQL> desc all_sequences;
Name Null? Type
----------------------------------------- -------- ----------------------------
SEQUENCE_OWNER NOT NULL VARCHAR2(30)
SEQUENCE_NAME NOT NULL VARCHAR2(30)
MIN_VALUE NUMBER
MAX_VALUE NUMBER
INCREMENT_BY NOT NULL NUMBER
CYCLE_FLAG VARCHAR2(1)
ORDER_FLAG VARCHAR2(1)
CACHE_SIZE NOT NULL NUMBER
LAST_NUMBER NOT NULL NUMBER
SQL>
Select SEQUENCE_OWNER, SEQUENCE_NAME from all_sequences where sequence_owner = 'INTRANET';
| ||||||