How to get a list of all background sessions in the database?
No Answer is Posted For this Question
Be the First to Post Answer
What are the execution control statements?
How to assign query results to variables?
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?
How a tablespace is related to data files?
what are the advantages of running a database in archive log mode?
What are steps required to ENTER DATA INTO DWH?
Point out the difference between user tables and data dictionary?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
What is a package ? What are the advantages of package ?
What do you mean by merge in oracle and how can you merge two tables?
What is the use of file param in imp command?
What privilege is needed for a user to query tables in another schema?