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
Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ? prevator   7  5746
can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?    2  5805
what is difference between "Primary key" and "Unique key"? prevator   4  3228
How to fetch the rows by dynamicaly passing table name through cursor?    3  3175
what is ref cursor in pl/sql?    3  14158
If records are inserted into table without committing.How to refer to these values in a procedure?    2  2157
How to get the procedure's, function's name from a package if it is wrapped(both spec & body).    2  1839
Can we relate two different tables from two different users in ORACLE,PL/SQL?    4  3518
How to come back in normal stage in Mutating Table if mutating table is locked or update data?    2  2037
How to return multiple records from procedure?    2  3109
what is the difference between granting and creating a view?    2  1620
Give which cursor is better for better performance means type of cursors?    2  2103
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  4844
how do u call in & out parameters for stored procedures? a1-technology   10  6436
Can we use more than one null value for unique key? a1-technology   31  18807
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
 
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)? 553
What is Materialized View? In What Scenario we Use Materialized View? 1798
what is the bond code in materialized view? 613
I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer. 9
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com 333
what is the difference between trigger and constraint? 757
What is the criteria while applying index to any column on any table. 130
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 168
how will i became good database developer? 250
what is single byte over head in oracle..? 386
if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time 9
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 756
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 272
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 361
We have a CURSOR then we need BULK COLLECT? 322
E-Mail New Answers        Answer Selected Questions