how many columns can a plsql table have
Answers were Sorted based on User's Feedback
Answer / abhishek tp
total 250 , 249 non clustered and 1 clustered
Is This Answer Correct ? | 1 Yes | 9 No |
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
What is catalog in Oracle?
What is a Temporary Segment ?
Difference between the “verify” and “feedback” command?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How to write a left outer join with the where clause in oracle?
What are the oracle differences between nvl and coalesce
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
can you write commit in triggers?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Explain mutating triggers.