how are rank and dense rank being alloted for column with same values over a particular column
Answer / shipra gupta
salary R DR
800 1 1
800 1 1
200 3 2
|Is This Answer Correct ?||0 Yes||0 No|
what are the advantages of cursors than procedures?
Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.
hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : firstname.lastname@example.org thnx advance
I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.
What is integrity constraints?
what is a cursor
can i create trigger on synonym is it possible or not please help me
How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?
How to call the function and Procedure in trigger?