How to create a single index for multiple columns?
No Answer is Posted For this Question
Be the First to Post Answer
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
how to insert the image in table
What are the different pseudo commands? Explain in general?
How to select some columns from a table in oracle?
What is concurrency in oracle?
How does oracle handle read consistency?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What are inner join and outer join?
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
why pl sql doesn't support retrieving multiple records