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 mean by forward declaration and where we'll use it. tcs   4  13935
what is bulk bind tcs   4  7047
Whatis yhe use of cursor ? how cursor allocate context area for executing the sql statement? hcl   2  6139
what is global table iflex   5  7063
what is purge command explain about oracle performance tuning accenture   2  14608
What is the difference between RDBMS and DBMS? stag-computers   20  52444
How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id cgci   7  6619
What are Lexical Parameters.How They are used in Reports 6i eicc   2  22547
Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...    1  3357
What is a bitmap index? choice-solutions   4  11886
Regarding joins what are the differences you observed in oracle 9i and sql server? choice-solutions   3  3624
what are the different types of joins? choice-solutions   4  5352
How to convert ms-excel file to oracle table?    2  5153
Write a simple program on cursors birlasoft   2  4177
Difference between views and materialized views? birlasoft   4  11140
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
 
What action do you have to perform before retrieving data from the next result set of a stored procedure ? 794
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output. 1894
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 1079
when MSQL8.0 is in market 459
Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974 2828
C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September. 812
Maximum how many triggers can we use in trigger and How to find out how many records it fetched. 3
Which data type doesn't allow null data type? 3
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 1148
What are wait events. Describe the wait event tables. 1799
which will default fire first  statement level trigger or row level trigger 3
i have some prob lem to tell me about my self in interview first round ... 303
what is single byte over head in oracle..? 617
what is indexing, searching and user interface? 680
how will i became good database developer? 495
E-Mail New Answers        Answer Selected Questions