Briefly explain what is literal? Give an example where it can be used?
No Answer is Posted For this Question
Be the First to Post Answer
how to delete all duplicate records from a table using subquery?
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 hash cluster in oracle?
What WHERE CURRENT OF clause does in a cursor?
List the types of joins used in writing subqueries?
What is an Oracle view?
Does facebook use oracle?
Is postgres faster than oracle?
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
What is transaction control statement and how many types of transaction control statement in Oracle?
What is difference between a formal and an actual parameter?