How to filter out duplications in the returning rows using oracle?
No Answer is Posted For this Question
Be the First to Post Answer
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
Find all employees in Dept “Marketing”.
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
Give syntax for SQL and ORACLE joins.
What is use of oracle?
How are extents allocated to a segment?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
What is the dynamic sql in oracle?
What is an Oracle Instance?
How can I get column names from a table in oracle?
How do I recompile a procedure in oracle?