Tag: databases

Once created, a sequence belongs to a specific schema

Once created, a sequence is linked to a specific table

Once created, a sequence is automatically available to all users

Only the DBA can control which squence is used by certain a table

Once created, a sequence is automatically in all INSERT and UPDATE statements

SELECT text FROM user_source WHERE name ='SALARY_CALC';

SELECT * FROM user_source WHERE source_name ='salary_calc';

SELECT * FROM user_objects WHERE object_name = 'SALARY_CALC';

SELECT text FROM user_source WHERE name='SALARY_CALC' AND owner ='JOHN';

unique

not null

check

primary key

SELECT SUBSTR ('HelloWorld',1) FROM dual;

SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual

SELECT LOWER (SUBSTR('HellowWorld', 2,1) FROM dual

SELECT INITCAP(TRIM('HellowWorld', 1,1) FROM dual

&

accept

prompt

&&

Create and drop a materialized view

Grant and revoke the role to and from other users

Enable the role and exercise any privileges in the role's privilege domain

Select from a table

Bitmap

B-Tree

Partitioned

Reverse key

Bitmap

Btree

Unique

partitioned

The shared pool CANNOT be dynamically resized.

The shared pool contains only fixed structures

The shared pool consists of the library cache and buffer cache.

The shared pool stores the most recently executed SQL statements and the most recently

A transaction completes.

The instance is started.

The instance is shut down

The current online redo log group is filled