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 new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
 Categories >> Software >> Databases >> SQL PLSQL       
Suggest New Category 
 


 

  Question  Asked @ Answers Views     select
 
what is sql profiler Fidelity  2  2428
What is the diff between Truncate table / delete <table name> purge TCS  3  3861
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  1810
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  2414
What are the difference between Functions/Stored Procs and Triggers and where are they used. CGI   1  1313
Can you have multiple SPs with the same name on a database? CGI   2  1245
Can you create a table with Primary Key not as the clustered index. CGI  2  2135
Can you have multiple SPs with the same name on a database? CGI  5  2779
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  1086
What is Difference Between delete and Truncate?  9  1587
What is Difference between StoredProcedure and function?  3  1600
what is Difference between Having and Where clause? IBM  5  3078
How many rows will return from dual table? Fujitsu  4  3180
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  1110
select top 3 sal from each dept? IBM   14  5151
E-Mail New Answers        Answer Selected Questions        Post New SQL PLSQL Question
Prev    1   ... 5   ... 9   ... 13   ... 17   ... 21   ... 25   ... 29   ... 33    36   [37]    38  ... 41   ... 45   ... 49    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views Asked at   Select
 
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 211  
What are wait events. Describe the wait event tables. 562 CTS
what is the bond code in materialized view? 605  
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. 190  
write a query that returns first characters of each word in Oracel/Sql pl sql 1988  
Could you please provide oca (oracle 10g) dumps for my certification ? 752  
We have a CURSOR then we need BULK COLLECT? 314  
what is indexing, searching and user interface? 290 HCL
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 557  
what is the difference between trigger and constraint? 720  
What action do you have to perform before retrieving data from the next result set of a stored procedure ? 493 Microsoft
Describe the Index, Types of index, At what situation we have used? Which one s better than others? 309 IBM
E-Mail New Answers        Answer Selected Questions
 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com