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
full outer join syntax    5  3356
difference between oracle 8i and oracle 9i    8  16612
difference between cursor and procedure in a package pcs   3  17251
a procedure one in two out parameters i am waiting it in a sql query can i get the output    1  2115
can i use dbms_output.put_line in a function u are telling as return statement    7  9914
after tell procedure whole code he asked can i write the same way in a function    3  1950
can i give user defined exception in a package    2  3758
can i write pl/sql code in a package    2  3319
will function return more than one value how accenture   9  10902
difference between pl/sql table and normal pl/sql table    2  7402
is it mandatory to select all the column in a view then what columns should be selected    2  2811
what is global variable in package polaris   3  6506
what is cursor procedure igate   1  3573
in a package one procedure is wrong package shows valid or not    4  3348
in procedure how to return a value wipro   3  4947
E-Mail New Answers        Answer Selected Questions        Post New sql-plsql Questions
Prev    1   ... 5   ... 9   ... 13   ... 17   ... 21   ... 25   ... 29   ... 33   ... 37    40   [41]    42  ... 45   ... 49   ... 53    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views   Select
 
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.. 605
Describe the Index, Types of index, At what situation we have used? Which one s better than others? 575
What are code pages ? 642
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 3745
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. 2697
I want to execute a piece of code before calling a procedure. How to achieve it? 301
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. 913
How do you use collections in procedure to return the resultset? 729
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000 317
Are there any features that are decommissioned in 11g that are not present in 11g? 405
How well can multiple sessions access the same data simultaneously ? 622
what is the difference difference between procedure and packages 3428
What is your daily office routine? 648
Difference between global and parameter variables? 261
What packages(if any) has oracle provided for use by developers? 2696
E-Mail New Answers        Answer Selected Questions