What is the use of partition by in sql?
No Answer is Posted For this Question
Be the First to Post Answer
Define join and name different types of joins?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
How to read/write files from pl/sql?
How to fetch alternate records from a table?
What is diff between bulk collect and forall
Are pl sql variables case sensitive?
A table has 150 records. How do you retrieve 100th row to 120th row from that table ?
Is join an inner join?
How to get second highest salary from a table
ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.
What trigger means?
Can we use the cursor's to create the collection in PL/SQL?