what are the advantages of running a database in archive log
mode?
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?
What is meant by recursive hints in oracle?
What is procedure overloading in oracle?
Explain oracle’s system global area (sga).
What are internal user account in oracle?
Can a field be used in a report without it appearing in any data group ?
What is the use of aggregate functions in oracle?
DBMS vs. RDBMS
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.
what is analyze command ? what kind of statistics does it generate?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is a initialization parameter file in oracle?