Explain can a view based on another view?
How do I limit the number of rows returned by an oracle query after ordering?
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
What are the different type of Segments ?
what is difference between sql plus and sql*plus? (not sql and sql plus).
what is the bitmap index?
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
What are the uses of a database trigger?
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
what is port in oracle? how is it related to database application.
Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?
What is the difference between alert log file and trace file ?
What is the minimum client footprint required to connect c# to an oracle database?