Oracle functions, procedures, packages

          

Oracle Functions, Procedures, packages

<<Previous  Next>>     

Explain IN, OUT and INOUT in procedures.   

IN, OUT and INOUT are the arguments that are passed to the procedures................
Read answer

Explain the rules for writing a package.

Packeges are PL/SQl constructs that allow related data to be stored together. A package has two parts: specification and a body..................
Read answer

Oracle index

What is an Index?, What are the objects in oracle?, What is INDEX_BY_BINARY_INTEGER?, What is index and explain its purpose, What are the guidelines to decide which table s to index?..................
Read answer

Oracle nested table and varrays

A nested table is an unordered set of data elements. These data elements are all of the same datatype. It has a single column whose type is either built in or an object type. It is a table stored within the structure of another table.............
Read answer

Oracle optimizer

Explain how oracle optimizer works, Describe optimization methods, i.e. cost-based approach and role-based optimization..........
Read answer

Oracle procedures

Using SQL statements, remote tables can be accessed in procedures. Database links are specifically used for this purpose. They connect one oracle database to another................
Read answer

Oracle transaction

The parser scans the statement and breaks it into logical units such as keywords, identifiers and operators, A query or a sequence tree is built using the units above. This is done to transform the source data into the format required by the result set.............
Read answer

 <<Previous  Next>>

Write your comment - Share Knowledge and Experience


 
Interview questions
 
Home | Want a Job? Submit Key Skills | Employer login | My key skills | About us | Sitemap | Contact us