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 the Query to print out the individual total number of duplicate row in sql. tcs   5  3088
select top 3 sal from each dept? ibm   14  5410
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?    2  1153
How many rows will return from dual table? fujitsu   4  3308
what is Difference between Having and Where clause? ibm   5  3169
What is Difference between StoredProcedure and function?    3  1657
What is Difference Between delete and Truncate?    9  1700
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages? kpit   4  1155
Can you have multiple SPs with the same name on a database? cgi   5  2881
Can you create a table with Primary Key not as the clustered index. cgi   2  2198
Can you have multiple SPs with the same name on a database? cgi   2  1301
What are the difference between Functions/Stored Procs and Triggers and where are they used. cgi   1  1381
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining. cgi   3  2512
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining. cgi   1  1906
What is the diff between Truncate table / delete purge
tcs   3  4058
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
 
what is the difference difference between procedure and packages 1232
when normalization is required 36
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 177
how will i became good database developer? 256
We have a CURSOR then we need BULK COLLECT? 327
what is the bond code in materialized view? 619
How do you use collections in procedure to return the resultset? 326
What is the criteria while applying index to any column on any table. 143
How consistent is the view of the data between and within multiple sessions, transactions or statements ? 289
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.. 255
Are there any features that are decommissioned in 11g that are not present in 11g? 176
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews 188
What is Materialized View? In What Scenario we Use Materialized View? 1842
i have some prob lem to tell me about my self in interview first round ... 164
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)? 579
E-Mail New Answers        Answer Selected Questions