Tag: databases

DELETE

SELECT

CREATE TABLE

UPDATE

DROP TABLE

DICTIONARY

TABLE_PRIVILEGES

ALL_VIEWS

USER_OBJECTS

0

NULL

Depends on the scale and precision of the datatype.

Without initialization, a variable cannot be used in the executable section of the block.

When you disconnect from your session abnormally

After PL/SQL block is executed successfully

When you issue TRUNCATE command at SQL prompt

When COMMIT command is issued

When each UPDATE statement is executed

If-Then-Else

While loop

GOTO

DECODE

0

8

7

NULL

SQL statements can be on one or more lines.

Keywords cannot be split across lines.

SQL statements are not case-sensitive, unless indicated.

Keywords can be abbreviated.

Place a slash on the last line in the buffer.

You can use arithmetic operators in any clause of a SQL statement.

DROP INDEX

ALTER TABLE ....... DROP PRIMARY KEY CASCADE

ALTER TABLE ....... DROP CONSTRAINT

DROP TABLE

DECLARE V_Destination_India Number;

DECLARE V_123, V_213, V_132 Varchar2(10);

DECLARE V_sys Boolean := 1;

DECLARE V_destination_India Number(4);

DECLARE V_Hiredate NOT NULL DATE := '01-JAN-00';

EXISTS

SUBSTR

TRIM

FLOOR

COUNT

UPPER