What is the difference between function, procedure and package in pl/sql?
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.
Which is faster count (*) or count 1?
Can we rename a column in the output of sql query?
what is the order of pre-defined exceptions.
How do I count duplicates in sql?
How would you pass hints to the sql processor?
what is a database transaction? : Sql dba
how can we destroy the cookie? : Sql dba
what is 'mysqladmin' in mysql? : Sql dba
How do I save the results of sql query in a file?
What is crud diagram?
What is a database link?
Oracle (3259)
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)