Hi,
Whenever the variable names are same as column names of the table, oracle treats them as columns rather than variables.
This is coz, values are assigned to variables using the assignment...
Type: Posts; User: savitha239; Keyword(s):
Hi,
Whenever the variable names are same as column names of the table, oracle treats them as columns rather than variables.
This is coz, values are assigned to variables using the assignment...
Hi,
For Update clause is always used in a cursor(or a simple SELECT statement).
The advantage of locking a set of rows fetched by cursor(or a select statement) over an exclusive lock on an...