Is there any restriction on the use of union in embedded sql?
No Answer is Posted For this Question
Be the First to Post Answer
Wat is SGA ?
How do I remove sql developer from windows 10?
Explain 3 basic parts of a trigger.
What is the use of function "module procedure" in pl/sql?
What is rule base and cost base optimizer?
What cursor type do you use to retrieve multiple recordsets?
17 Answers Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,
What is the difference between clustered and non-clustered index in sql?
what is try_catch block in procedure
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.
How to avoid using cursors?
How to perform a loop through all tables in pl/sql?