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
   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
How to fetch the rows by dynamicaly passing table name through cursor?    3  3162
what is ref cursor in pl/sql?    3  14145
If records are inserted into table without committing.How to refer to these values in a procedure?    2  2153
How to get the procedure's, function's name from a package if it is wrapped(both spec & body).    2  1832
Can we relate two different tables from two different users in ORACLE,PL/SQL?    4  3511
How to come back in normal stage in Mutating Table if mutating table is locked or update data?    2  2033
How to return multiple records from procedure?    2  3101
what is the difference between granting and creating a view?    2  1613
Give which cursor is better for better performance means type of cursors?    2  2098
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  4836
how do u call in & out parameters for stored procedures? a1-technology   10  6425
Can we use more than one null value for unique key? a1-technology   31  18778
What are user defined stored procedures ? birlasoft   3  5216
Authentication mechanisms in Sql Server ? birlasoft   1  2072
What is a self join ? birlasoft   6  4591
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
 
What packages(if any) has oracle provided for use by developers? 877
What are code pages ? 360
what is indexing, searching and user interface? 298
Describe the Index, Types of index, At what situation we have used? Which one s better than others? 312
What is Materialized View? In What Scenario we Use Materialized View? 1790
how will be date change into string 526
We have a CURSOR then we need BULK COLLECT? 321
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me 244
how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently 153
Table1: Col1 col2 1 2 10 3 4 89 5 6 Table:2 Col1 col2 3 2 9 5 4 7 6 87 With the help of table1 and table2 write a query to simulate the fallowing results. Output1: Col1 col2 1 2 2 3 3 4 4 5 5 6 Output2: Col1 col2 2 3 10 4 5 89 6 7 1.Write query for single row to multiple row using sql statements. Eg:a,b,c,d,e,f Change to A B C D E F 2. Write query for multiple row to single row using sql statements. Eg2 A B C D E F Change to Eg:a,b,c,d,e,f Table1: Col1 col2 8 5 2 9 4 2 5 1.Write a query to select all the rows from a table1,if the value of A is null then corresponding B’s value should be printed in A’s value.if the value of A is null in that table then corresponding B’s value should be printed as 30. 2. write a query to find the sum of A and B .display the max among both. 3.write a query to find total number of rows from table 1. Note: if any column value is null in a row then that row should be considered as 2 rows. 4.write a query to display all the records of table1 except A containg 2 as well B containg 5. 5.rewrite the fallowing without using join and group by. Select b.title,max(bc.returneddate –bc.checkoutdate)” mostdaysout” From bookshelf_checkout bc, Book shelf B Where bc.title(+)=b.title Group by b.title. 6.rewrite fallowing query Select id_category from category_master X where exists (select 1 from sub_category Y where X.id_category=Y.id_category) Customer: Name phone1 phone2 phone3 bitwise A 23456 67890 12345 --- B 67459 89760 37689 --- Don’t_call Col1 67890 37689 1.q) update the customer table of bitwise with 1 or 0. Exists in don’t_call table menas show -1 Other wise -0. Output. Name bitwise A 010 B 010 178
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table... 308
write a query that returns first characters of each word in Oracel/Sql pl sql 2033
how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000 749
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 1015
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. 199
E-Mail New Answers        Answer Selected Questions