ALLInterview.com :: Home Page
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   Errors
   Testimonials Refer this Site  Refer This Site to Your Friends  Site Map  Contact Us      
   
 
 Categories >> Software >> Databases >> SQL PLSQL
 
Suggest New Category 
 


 

Question Asked @ Answers Views     Select
How consistent is the view of the data between and within multiple sessions, transactions or statements ?    0  418
Explain the usage of WHERE CURRENT OF clause in cursors ?    3  5993
How to display the contents of a current record fetched in a reference cursor?    2  3790
How to trace the errors in pl/sql block code? tcs   4  6670
State the advatage and disadvantage of Cursor's?    2  5490
State the difference between implict and explict cursor's?    7  11419
what is difference between stored procedures and application procedures,stored function and application function?    1  6576
what is meant by forward declaration in functions? tcs   4  6656
In a Distributed Database System Can we execute two queries simultaneously ? Justify ?    2  4561
What are the Restrictions on Cursor Variables?    2  8070
How toimport .dmp file in lower version of oracle from higher version ? tcs   4  5375
How can we schedule the procedure to run automatically ?    3  5660
what is definer rights invoke rights?    1  3048
How would you hide a table in sql. ie the table can be only visible to its maker?    3  5620
what is meant by tuning and tk proof?    2  5996
E-Mail New Answers        Answer Selected Questions        Post New sql-plsql Questions
Prev    1   ... 5   ... 9   ... 13   ... 17   ... 21   ... 25   ... 29   ... 33   ... 37    40   [41]    42  ... 45   ... 49   ... 53    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views   Select
 
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table... 489
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error? 1129
How consistent is the view of the data between and within multiple sessions, transactions or statements ? 418
Maximum how many triggers can we use in trigger and How to find out how many records it fetched. 34
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5 1097
How well can multiple sessions access the same data simultaneously ? 485
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao... 530
in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query 431
Can you alter start with clause? 54
How do you use collections in procedure to return the resultset? 565
what is the difference difference between procedure and packages 2762
What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ? 566
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. 29
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 528
What are wait events. Describe the wait event tables. 1815
E-Mail New Answers        Answer Selected Questions