You can save it in a local variable (like: v_deletedate) and then use that variable in your insert command.
create or replace trigger dis_sal_his
after delete or insert or update on employee
for each row
declare
username varchar2(10);
v_deletedate date;
begin
select user into username from dual;
v_deletedate := :old.deletedate;
insert into employeehistory
values(:old.id,:old.name,:old.age,:old.address,:old.salary,v_deletedate);
end;
Related Posts:
- ORA-00904: invalid identifier
- SQL error “ORA-01722: invalid number”
- how to fix oracle ORA-01722 invalid number error
- QL Error: ORA-00933: SQL command not properly ended
- ORA-00979 not a group by expression
- ORA-00907: missing right parenthesis
- How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
- ORA-01843 not a valid month- Comparing Dates
- SQL Error: ORA-00942 table or view does not exist
- ORA-00918: column ambiguously defined in SELECT *
- Oracle error : ORA-00905: Missing keyword
- What does SQL Select symbol || mean?
- How do I limit the number of rows returned by an Oracle query after ordering?
- SQL not a single-group group function
- Oracle SELECT TOP 10 records
- Can a foreign key be NULL and/or duplicate?
- How to Select Top 100 rows in Oracle?
- ORA-12560: TNS:protocol adaptor error
- SQL error “ORA-01722: invalid number”
- What does the following Oracle error mean: invalid column index
- ORA-00972 identifier is too long alias column name
- What does the following Oracle error mean: invalid column index
- Oracle Apex column link from LOV values
- PLS-00103: Encountered the symbol when expecting one of the following:
- What’s the difference between RANK() and DENSE_RANK() functions in oracle?
- ORA-00918: column ambiguously defined in SELECT *
- ORA-00918: column ambiguously defined in SELECT *
- Oracle – ORA-01489: result of string concatenation is too long [duplicate]
- SQL Error: ORA-00913: too many values
- ORA-01861: literal does not match format string
- Is there a combination of “LIKE” and “IN” in SQL?
- SQL Error: ORA-01861: literal does not match format string 01861
- What is it exactly a BLOB in a DBMS context
- “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
- How do you create a temporary table in an Oracle database?
- Oracle “Partition By” Keyword
- How to insert date values into table
- Oracle SQL: Update a table with data from another table
- Oracle SQL query for Date format
- SQL selecting rows by most recent date with two unique columns
- ORA-06502: PL/SQL: numeric or value error: character string buffer too small
- SQL Queries “00904. 00000 – “%s: invalid identifier”
- Comparing Dates in Oracle SQL
- Convert timestamp to date in Oracle SQL
- How do I reset a sequence in Oracle?
- Update statement with inner join on Oracle
- MySQL equivalent of DECODE function in Oracle
- what is the difference between triggers, assertions and checks (in database)
- ‘NOT LIKE’ in an SQL query
- Oracle: If Table Exists
- DATEDIFF function in Oracle
- How to create id with AUTO_INCREMENT on Oracle?
- LEFT function in Oracle
- What is the difference between Views and Materialized Views in Oracle?
- How do I view the Explain Plan in Oracle Sql developer?
- ORA-01779: cannot modify a column which maps to a non key-preserved table
- ORA-01735: invalid ALTER TABLE option – Toad
- ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
- What is a stored procedure?
- Why do we need “Relationships” between tables at all?
- The SQL OVER() clause – when and why is it useful?
- Using group by on multiple columns
- ORA-12899: value too large for column
- Insert text with single quotes in PostgreSQL
- Generating a random & unique 8 character string using MySQL
- strange text before my header wordpress
- Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
- ORDER BY items must appear in the select list if SELECT DISTINCT is specified
- ROW_NUMBER() in MySQ
- SUM OVER PARTITION BY
- Varchar invalid for Sum operator
- SQL: How to properly check if a record exists
- Hibernate show real SQL
- SQL query to extract only the “current” wp_posts?
- What’s the easiest way to duplicate an entire navigation menu?
- How to remove in the wordpress database all posts revisions except the last three?
- Sorting a list of posts displayed under a list of associated terms (which should be sorted without initial articles)
- Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
- Query to get the author who having maximum number of post (custom post type)
- Query WordPress database by registered date and role
- How do i export the HTML from text widgets?
- What is the easiest way to implement cascading database upgrade for my plugin?
- How to display posts of specific category using a custom Query in WordPress?
- Difficulty importing my live site to local
- batch adding posts to a category based on matching regex for title with SQL
- Order a custom post type admin screen by a second custom post type title
- How to left join meta in queries [closed]
- Randomly select one of last 3 posts
- Using color schemes with Color Picker
- Unknown column ‘wp_posts.ID’ in ‘field list
- SQL DELETE multiple post_meta on single and multi-sites
- WP_Query() not working as expected
- How to use Multi SQL Database in WordPress?
- SQL query to change the value of a Custom Field
- Correct and secure way to access a custom SQL database in a custom PHP template file
- direct query to post_meta table
- Database Query not working
- How to get EVENT based on startday, using BETWEEN
- wpdb LIKE request shows all database data
- Where can I find the SQL to get the most used information by wordpress database?