Explain the function of optimizer in oracle?
What is Undo Management Advisor in Oracle?
What is oracle data type?
What is redo log?
what is Single Byte Overhead...?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
How many types of cluster table in Oracle?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
Point the difference between translate and replace?
what is the difference between data migration and production migration.
6. Display the client name and order date for all orders using the traditional method.
how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?