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 new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
 Categories >> Software >> Databases >> SQL PLSQL       
Suggest New Category 
 


 

  Question  Asked @ Answers Views     select
 
how to write utl file pkg in SQL Oracle  1  1015
I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?  2  817
wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod? Oracle   4  2775
i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w Scope-International   4  2239
i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted??? Scope-International  2  2057
Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)  3  1273
Write a query to get last 10 records from the table. iNautix  7  3182
how to see the oracle 9i/10g table in pc? or In my pc where the table is saved and how to see?  1  667
i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk Aspire  1  1255
IF i write before / after insert / update trigger and i do rollback what will happen? KPIT  4  1864
I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.  3  820
Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)  1  1073
Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines. Wipro  4  1331
sql query to get zero records from a table having n no of records CTS  7  3195
How do we tune the code?  2  979
E-Mail New Answers        Answer Selected Questions        Post New SQL PLSQL Question
Prev    1   ... 5   ... 9   ... 13   ... 17   ... 21   ... 25   ... 29   ... 33   ... 37    40   [41]    42  ... 45   ... 49    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views Asked at   Select
 
What action do you have to perform before retrieving data from the next result set of a stored procedure ? 493 Microsoft
hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification 211  
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... 304 Satyam
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 382  
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details? 334  
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. 303  
how will i became good database developer? 234  
What are wait events. Describe the wait event tables. 562 CTS
What are code pages ? 354 BirlaSoft
how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently 108 oracle
I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. 256 MTS
what is the difference difference between procedure and packages 1139 3i-Infotech
E-Mail New Answers        Answer Selected Questions
 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com