How to create a new table by selecting rows from another table?
No Answer is Posted For this Question
Be the First to Post Answer
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How to manage transaction isolation level?
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)
How to create a stored function in oracle?
What is the implicit cursor in oracle?
What is proxy method?
How to create a table in a specific tablespace?
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
What do you know about normalization? Explain in detail?
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
What is an oracle table?