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
1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table. polaris   1  3236
what is difference between decode and case function?    2  4596
what is External tables? explain with examples tcs   2  5025
What is bulk collections?    1  3165
IF THERE ARE 1 TO 100 NUMBERS IN A TABLE AND IN THAT 100 NUMBERS SOME 10 NUMBERS ARE DELETED.I WANT TO FIND OUT THE MISSING NUMBERS BETWEEN 1 TO 100 by PL/SQL HOW?    7  4037
Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..    8  2278
What are Anti joins ibm   1  5193
What are Global Temporary tables ibm   3  4535
What are Nested Tables? How will u delete 5 rows from Nested Tables ibm   3  4176
If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??    3  3051
i need department wise top 2 employees salary.which logic i will use    16  12610
what is outer join? what is selef join? what is difference between them? what is cartecion join? synechron   1  5572
how to calcuate the second highest salary of he employee synechron   13  5574
is it necessary to write group by and order by clause together hcl   2  4360
what is pragma ? polaris   1  3424
E-Mail New Answers        Answer Selected Questions        Post New sql-plsql Questions
Prev    1   ... 5   ... 9   ... 13    16   [17]    18  ... 21   ... 25   ... 29   ... 33   ... 37   ... 41   ... 45   ... 49   ... 53    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views   Select
 
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
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 1127
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. 2004
How consistent is the view of the data between and within multiple sessions, transactions or statements ? 423
What are code pages ? 536
What is extent clause in table space? 59
How well can multiple sessions access the same data simultaneously ? 492
Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974 2935
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)? 1478
What is Materialized View? In What Scenario we Use Materialized View? 3760
Difference between global and parameter variables? 58
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error? 1138
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 440
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? 9
Could you please provide oca (oracle 10g) dumps for my certification ? 2191
E-Mail New Answers        Answer Selected Questions