Answer Posted / roopesh kumar
Bulk binding is a way for performance tunning i.e. it will
complete the whole process in once remove the contaxt
switching of sql to pl-sql & pl-sql to sql.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the two types of exceptions.
Is drop table faster than truncate?
How delete a row in sql?
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
Which sql statement is used to return only different values?
What is cursor status?
Is time a data type in sql?
How would you convert date into julian date format?
What is pl sql script?
Are null values same as that of zero or a blank space?
What are the types of keys?
Which software is used for pl sql programming?
Is oracle and sql same?
Explain isolation levels. : Transact sql
what is sub-query? : Transact sql