How many parts of a pl sql block are optional?
No Answer is Posted For this Question
Be the First to Post Answer
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 can we make an if statement within a select statement?
What is asqueryable?
What sql database should I use?
What is the location of pre_defined_functions.
How does cross join work?
What do you understand by case manipulation functions?
What is sqlerrm?
what is difference b/w pravite procedures and public procedures?
3 Answers Steria, Wipro, Zensar,
How do I enable sql encryption?
What is dml and ddl?
What type of join is sql join?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)