![]() Related Questions Latest Answer : very good answer shakthivel.. ... Latest Answer : StatementFixed parameter valueExecute every timePrepared StatementCan supply parameter value at execution timeExecute once for ‘n’ parameter valueCallable StatementTo execute stored procedure like pl/sql ... Read Answers (2) | Asked by : Surya Latest Answer : Inner join: It is is the most common type of join. Inner joins return all rows from multiple tables where the join condition is met.Outerjoin: This type of join returns all rows from one table and only those rows from a secondary table where ... Read Answers (2) | Asked by : Ymai Latest Answer : (1) Load-lookup:----------------------- 1) Load-lookup will be populated at compilation time 2) We can adjust the size of load-lookup 3)
It is only for text datatype 4) We can only select two fields, but by string
cancatnation we can select ... Read Answers (3) | Asked by : Vikrant Latest Answer : AE is very systematic as it is structured as Section, step and Action. While
SQR is not systematic.
AE flow is easy to read and understand, while SQR is not that easy.
AE is easy to debug as you can do line by line debugging. With SQR it’s not ... Read Answers (5) | Asked by : sheril Explain the difference between Translate & Prompt tables. What are the occasions when to use Translate values instead of Prompt table? What is the advantage of one over the other? Latest Answer : Translate Table: Translate table is a special kind of table that is limited to validating data of four characters or less.The tranlate table serves as a universal prompt table and ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||