How would you change old and new values in an insert, delete and update triggers?
No Answer is Posted For this Question
Be the First to Post Answer
What are the differences between char and varchar2 in oracle?
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
Explain coalesce function?
How to upsert (update or insert into a table)?
Query to retrieve record for a many to many relationship ?
Can we insert data in view oracle?
What is a partition in oracle?
Can a field be used in a report without it appearing in any data group ?
How would you go about verifying the network name that the local_listener is currently using?
What is SQL access advisor in Oracle?
How to execute a stored procedure in oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?