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
what is a sub query?how will you calculate working days in a month using sub query? inteq   4  5728
How you will create Toad Function?    1  11357
How can you create Cursor with parametres ?    3  3328
How to return more than one value from a function? satyam   10  16659
What is Overloading of procedures ? amdoc   4  4463
What is Data Concarency and Consistency?    1  2761
How well can multiple sessions access the same data simultaneously ?    0  509
How consistent is the view of the data between and within multiple sessions, transactions or statements ?    0  439
Explain the usage of WHERE CURRENT OF clause in cursors ?    3  6162
How to display the contents of a current record fetched in a reference cursor?    2  3912
How to trace the errors in pl/sql block code? tcs   4  7014
State the advatage and disadvantage of Cursor's?    2  5636
State the difference between implict and explict cursor's?    7  11780
what is difference between stored procedures and application procedures,stored function and application function?    1  6838
what is meant by forward declaration in functions? tcs   4  7595
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 packages(if any) has oracle provided for use by developers? 2298
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 1176
What is window clause? 139
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details? 772
what is the bond code in materialized view? 994
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 1058
What are wait events. Describe the wait event tables. 1857
What is the use of time stamp in select statement? 143
hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification 387
i have some prob lem to tell me about my self in interview first round ... 326
What is Materialized View? In What Scenario we Use Materialized View? 3896
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output. 2137
source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query? 133
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem.. 521
What is the criteria while applying index to any column on any table. 433
E-Mail New Answers        Answer Selected Questions