HI Bro,
Table :- It is a collection of row and column and it is a basic sotage unit
view :- IT logically represents subset of data from one or more tables
synonym :- It is Alternative name of...
Type: Posts; User: mihir_orcl; Keyword(s):
HI Bro,
Table :- It is a collection of row and column and it is a basic sotage unit
view :- IT logically represents subset of data from one or more tables
synonym :- It is Alternative name of...
hi bro,
Cursor is a private SQL Work Area.
There are two types of cursor
1) Implicit Cursor
2)Explicit Cursor which is user define
EXAMple
Retrive first 10 employees one by one
DECLARE
v_no...