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 well can multiple sessions access the same data simultaneously ?    0  492
How consistent is the view of the data between and within multiple sessions, transactions or statements ?    0  423
Explain the usage of WHERE CURRENT OF clause in cursors ?    3  6045
How to display the contents of a current record fetched in a reference cursor?    2  3816
How to trace the errors in pl/sql block code? tcs   4  6768
State the advatage and disadvantage of Cursor's?    2  5537
State the difference between implict and explict cursor's?    7  11530
what is difference between stored procedures and application procedures,stored function and application function?    1  6672
what is meant by forward declaration in functions? tcs   4  6740
In a Distributed Database System Can we execute two queries simultaneously ? Justify ?    2  4631
What are the Restrictions on Cursor Variables?    2  8183
How toimport .dmp file in lower version of oracle from higher version ? tcs   4  5468
How can we schedule the procedure to run automatically ?    3  5712
what is definer rights invoke rights?    1  3086
How would you hide a table in sql. ie the table can be only visible to its maker?    3  5675
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 indexing, searching and user interface? 694
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? 10
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution 692
How do you use collections in procedure to return the resultset? 580
how will i became good database developer? 518
i have some prob lem to tell me about my self in interview first round ... 312
how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000 1591
Are there any features that are decommissioned in 11g that are not present in 11g? 315
What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ? 573
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.. 491
What are wait events. Describe the wait event tables. 1829
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 366
How global cursor can be declare with dynamic trigger ? 59
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details? 748
Could you please provide oca (oracle 10g) dumps for my certification ? 2192
E-Mail New Answers        Answer Selected Questions