Explain the function of optimizer in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
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.
what is main def between plsql/table and array?
How does oracle handle read consistency?
Difference between inner join vs where ?
What is a select query statement in oracle?
How can you Enforce Referential Integrity in snapshots ?
Give the various rollback segment states.
Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How to load excel data sheet to oracle database
What is a system tablespace and when it is created?