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 difference between procedure and function, procedure and trigger? iflex   7  16253
there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how? oracle   12  7455
how to check the 3rd max salary from an employee table? ibm   19  13615
What is magic table?    6  12182
Delete duplicate records in the emp table.    6  7598
Delete the emps whose salaries are lowest sals of their own dept.    5  4252
define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.    4  3081
check whether all the emp numbers are indeed unique.    6  5208
What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day. hexaware   4  5561
Can a table have two primary keys? hcl   44  48446
what is the order of pre-defined exceptions. tcs   6  7939
what is mean by forward declaration and where we'll use it. tcs   4  15205
what is bulk bind tcs   4  7598
Whatis yhe use of cursor ? how cursor allocate context area for executing the sql statement? hcl   2  6581
what is global table iflex   5  7413
E-Mail New Answers        Answer Selected Questions        Post New sql-plsql Questions
Prev    1   ... 5   ... 9   ... 13   ... 17   ... 21   ... 25   ... 29   ... 33    36   [37]    38  ... 41   ... 45   ... 49   ... 53    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views   Select
 
Maximum how many triggers can we use in trigger and How to find out how many records it fetched. 172
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)? 1589
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 478
when MSQL8.0 is in market 492
what is the difference between trigger and constraint? 2173
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc 1265
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... 575
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details? 781
Could you please provide oca (oracle 10g) dumps for my certification ? 2285
what is the bond code in materialized view? 1003
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? 203
What is your daily office routine? 514
What is the use of time stamp in select statement? 188
Describe the Index, Types of index, At what situation we have used? Which one s better than others? 491
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 711
E-Mail New Answers        Answer Selected Questions