State the difference between implict and explict cursor's?
Answer Posted / l..l.n.reddy
IMPLICT CURSOR:- Automatically porvide by oracle which
perform DML statements. queries returns only one row.
EXPLICT CURSOR:- Defined by user. queries returns more
than rows.
| Is This Answer Correct ? | 16 Yes | 4 No |
Post New Answer View All Answers
Does truncate free space?
What is the usage of sql functions?
Can we insert data into materialized view?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Why are indexes and views important to an organization?
What is sql not null constraint?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is normalisation in sql?
how does a local variable is defined using t-sql? : Transact sql
What are the benefits of triggers?
What is the difference between distinct and unique in sql?
Why is sql*loader direct path so fast?
Name three sql operations that perform a sort.
Write a sql query to get the third highest salary of an employee from employee_table?
what is text? : Sql dba