:: 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                      
 Categories >> Software >> Databases >> SQL PLSQL       
Suggest New Category 


View Page with Answers
  Question  Asked @ Answers Views     select
Give which cursor is better for better performance means type of cursors?  2  2017
When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then? Accenture   2  4630
how do u call in & out parameters for stored procedures? A1-Technology   10  6306
Can we use more than one null value for unique key? A1-Technology   31  18213
What are user defined stored procedures ? BirlaSoft  3  5066
Authentication mechanisms in Sql Server ? BirlaSoft  1  1951
What is a self join ? BirlaSoft  6  4505
What are different types of joins ? BirlaSoft  5  2667
What is a trigger ? BirlaSoft   10  4290
What is referential integrity ? BirlaSoft  3  2784
What are code pages ? BirlaSoft  0  335
What is a constraint. Types of constraints ? BirlaSoft   5  10974
What is an index and types of indexes. How many number of indexes can be used per table ? BirlaSoft   9  38794
What is normalization ? BirlaSoft   9  4781
What are nested triggers ? TCS   6  7492
E-Mail New Answers        Answer Selected Questions        Post New SQL PLSQL Question
Prev    1   ... 5   ... 9   ... 13   ... 17   ... 21   ... 25   ... 29   ... 33   ... 37    40   [41]    42  ... 45   ... 49    Next
    Oracle Interview Questions     SQL Server Interview Questions     MS Access Interview Questions
    MySQL Interview Questions     Postgre Interview Questions     Sybase Interview Questions
    DB Architecture Interview Questions     DB Administration Interview Questions     DB Development Interview Questions
    SQL PLSQL Interview Questions     Databases AllOther Interview Questions
Un-Answered Questions
 Question Views Asked at   Select
What packages(if any) has oracle provided for use by developers? 795  
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000???? 925  
what is the difference difference between procedure and packages 1081 3i-Infotech
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao... 326 Satyam
What are wait events. Describe the wait event tables. 530 CTS
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 142  
How consistent is the view of the data between and within multiple sessions, transactions or statements ? 261  
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 247  
Could you please provide oca (oracle 10g) dumps for my certification ? 687  
how will be date change into string 480  
What are code pages ? 335 BirlaSoft
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 450 TCS
E-Mail New Answers        Answer Selected Questions

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