If records are inserted into table without committing.How
to refer to these values in a procedure?
- 2 Answers
- 6591 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / highness
good,
isn't it possible by using :new pseudo records within
a trigger???
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / swapna
First create a Trigger and with Procedure you insert
records.
The :new will take the new values.
So use Triggers in Procedures.
| Is This Answer Correct ? | 0 Yes | 0 No |
Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.
Is left join inner or outer by default?
how to shutdown mysql server? : Sql dba
How can we optimize a sql query?
What is restrict in sql?
what is a trigger in mysql? Define different types of trigger. : Sql dba
What are the different types of constraints?
What are few of the schema objects that are created using PL/SQL?
What is PL/SQL Records?
How can we avoid duplicating records in a query?
Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
