Tag: databases

set timing on select * from EMP

set time on select * from EMP

time on select * from EMP

set timings on select * from EMP

Long

Int(0)

Char(0)

Binary

<=30 characters

<=40 characters

<=32 characters

<=20 characters

True

False

True

False

All matched columns returns NULLS.

All unmatched columns returns NULLS.

All matched and unmatched columns returns NULLS.

Cant say

Functions

Package body

Triggers

Cursor

Foreign Key

Primary Key

Check

Unique

Not Null

drop foreign keys

cascade constraints

this is not possible in oracle

clear references

maximum length for varchar is 2000 bytes and for varchar2 is 4000 bytes

varchar is used to store fixed length character data, varchar2 is for variable length character data

varchar data type is not supported in oracle

varchar is applicable only to PL/SQL