Home>>>

Oracle

Oracle offer light XE editions, you can install on your home PC if you need to test something out.

Quick Table of Contents

  1. sqlplus
  2. User Management
  3. useful SQL
[top]

1. sqlplus

Starting sqlplus

Use the command line and type 'sqlplus user/passs'

or click on "Run SQL Command Line"

Commands

connect

connect <user>/<password>;

where <password> is your password and <user> is your username.

[top]

2. User Management

Start the HTML administration site. Go to Home -> Administration -> Manage Database Users -> Create Database User

[top]

3. useful SQL

List all tables

      select * from tabs where table_name = 'BAS_PAYMENTS';

List all sequences

Use 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';
More Articles (showing 1 below)