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
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  1144
How many rows will return from dual table? fujitsu   4  3276
what is Difference between Having and Where clause? ibm   5  3146
What is Difference between StoredProcedure and function?    3  1640
What is Difference Between delete and Truncate?    9  1662
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  1135
Can you have multiple SPs with the same name on a database? cgi   5  2859
Can you create a table with Primary Key not as the clustered index. cgi   2  2184
Can you have multiple SPs with the same name on a database? cgi   2  1290
What are the difference between Functions/Stored Procs and Triggers and where are they used. cgi   1  1369
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  2488
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  1887
What is the diff between Truncate table / delete purge
tcs   3  4016
what is sql profiler fidelity   2  2485
what is sql optimization fidelity   1  1998
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
 
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters. 201
How well can multiple sessions access the same data simultaneously ? 329
Could you please provide oca (oracle 10g) dumps for my certification ? 809
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error? 848
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 476
How do you use collections in procedure to return the resultset? 322
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com 338
how will i became good database developer? 254
what is the bond code in materialized view? 615
write a query that returns first characters of each word in Oracel/Sql pl sql 2070
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.. 252
what is indexing, searching and user interface? 305
What action do you have to perform before retrieving data from the next result set of a stored procedure ? 508
What packages(if any) has oracle provided for use by developers? 904
We have a CURSOR then we need BULK COLLECT? 325
E-Mail New Answers        Answer Selected Questions