How to define a variable of a specific record type?
No Answer is Posted For this Question
Be the First to Post Answer
How to define a variable to match a table column data type?
What different of iner joint & outer joint with example
what are bitmap indexes? How does they work?
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
why pl sql doesn't support retrieving multiple records
how to get last monday of a month?
What are the differences between char and varchar2 in oracle?
What is bind variable in oracle 11g?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
What is the difference between translate and replace?