Quick Table of Contents

  1. sqlplus
  2. User Management
  3. useful SQL
  4. Administration
More Articles (showing 1 below)
 

Oracle

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

[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';
[top]

4. Administration

Max processes

You can alter this using by changing a system variable then restarting.

select name, value from v$parameter where name like '%processes%';

alter system set PROCESSES=100 scope=SPFILE;