What is trigger and stored procedure in 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.
What is set serveroutput on?
What are some predefined exceptions in pl/sql?
Is a view faster than a stored procedure?
Why triggers are used?
What is an invalid partition table?
Can procedure in package be overloaded?
What is auto increment feature in sql?
What is the difference between delete and truncate statement in sql?
What is cursor in pl sql?
What does where 1/2 mean in sql?
What are the data types allowed in a table?
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)