Explain about the analyze command in oracle?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What is a table index in oracle?
What is a tns file?
How do we know whether an index is created on a table ???
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
how to find out largest value in a table
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
Why is oracle used?
Explain the family trees and connection by clause
how to delete all duplicate records from a table using subquery?
What is a lookup table in oracle?
How to view all columns in an existing table?