Interested to Buy Any Domain ? << Click Here >> for more details...
How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?
- 12 Answers
- 29249 Views
- IBM, TCS, UHD, I also Faced
- E-Mail Answers
Answer Posted / hrishi
To reduce the context switches between the SQL Engine and
PL/SQL engine. We can use Bulk Bind Concept to this...
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What does a pl/sql package consist of?
Can a trigger call a stored procedure?
What is the starting oracle error number? What is meant by forward declaration in functions?
What is microsoft t sql?
What is t sql used for?
How to select random rows from a table?
What is sql character function?
Explian rowid, rownum? What are the psoducolumns we have?
how to get a list of indexes of an existing table? : Sql dba
What is having clause in sql?
what are the 'mysql' command line options? : Sql dba
Is sql a dbms?
What is the use of stored procedures?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
How many types of literals are available in pl sql?
