How to create a stored program unit?
No Answer is Posted For this Question
Be the First to Post Answer
What is a proxy class?
How can I create database in oracle?
What are the differences between interval year to month and interval day to second?
Why packages are used in oracle?
How are extents allocated to a segment?
Please explain compound trigger in oracle?
3. Display all the client numbers in the ORDER table. Remove duplicates.
What does `(+)` do in a where clause?
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
How to assign a table row to a record variable?
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.