Explain parameter file in oracle.
No Answer is Posted For this Question
Be the First to Post Answer
What is difference between truncate and delete?
What is a Database instance ? Explain?
Is postgres faster than oracle?
What is flashback Query ? And Use ?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Do View contain Data ?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
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?
what is view?
how do u know the total no of rows in a table?
How to convert character types to numeric types?
What is Row Chaining ?