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
How would you hide a table in sql. ie the table can be only visible to its maker?    3  5561
what is meant by tuning and tk proof?    2  5882
In packages the source code is compiled into p code ? how do we describe the p code    3  2485
what is the forward decleration in packages?    1  2492
What is the difference between sql/pl-sql/embeded sql?    3  6435
How the execution will be done in exceptions?    2  2212
Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ? prevator   7  9644
can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?    2  7757
what is difference between "Primary key" and "Unique key"? prevator   4  3976
How to fetch the rows by dynamicaly passing table name through cursor?    3  5086
what is ref cursor in pl/sql?    3  16596
If records are inserted into table without committing.How to refer to these values in a procedure?    2  3219
How to get the procedure's, function's name from a package if it is wrapped(both spec & body).    2  2843
Can we relate two different tables from two different users in ORACLE,PL/SQL?    4  4695
How to come back in normal stage in Mutating Table if mutating table is locked or update data?    2  2846
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
 
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 524
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... 482
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)? 1400
What is Materialized View? In What Scenario we Use Materialized View? 3618
what is single byte over head in oracle..? 614
What are wait events. Describe the wait event tables. 1791
what is the difference between trigger and constraint? 1868
What is the criteria while applying index to any column on any table. 315
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 926
How well can multiple sessions access the same data simultaneously ? 481
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.. 466
when normalization is required 1312
What action do you have to perform before retrieving data from the next result set of a stored procedure ? 792
when MSQL8.0 is in market 457
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 477
E-Mail New Answers        Answer Selected Questions