Can we create more than one index on particular column?
Answer / guest
No
But we can create composite index including that particular
column with other columns.
Is This Answer Correct ? | 5 Yes | 3 No |
What happens if you use a wrong connect identifier?
What is a Data Dictionary ?
Can sub procedure/function be called recursively?
if i am using dml statement in function. then i am writing select statement what was the output
What to do if the startbd.bat failed to start the xe instance?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Write a simple Store procedure and pass parameter to it ?
How do we get field detail of a table?
What is the difference between sharding and replication?
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
What is a user role in oracle?
How to retrieve the count of updated rows?