Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / selvaraj v , anna university c
Cursors allow row-by-row processing of the result sets.
Retrieve more than one rows from table or database to use
Curosrs.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
Describe different types of general function used in sql?
Can sql developer connect to db2?
What is join view in sql?
What is mdb stand for?
Explain the steps needed to create the scheduled job?
What are data types in pl sql?
What are the sql commands?
What is sqlerrd?
What is trigger and stored procedure in sql?
what are the t string functions available in tsql? : Transact sql
How can you fetch first 5 characters of the string?
What is range partitioning?
What is graph sql?
Which query operators in sql is used for pattern matching?
