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 5339
wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?4 16875
i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w4 14803
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???3 7703
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)5 7517
how to see the oracle 9i/10g table in pc? or In my pc where the table is saved and how to see?1 2961
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 wk1 4609
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 4144
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 4033
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.5 6404
How do we tune the code?2 4273
What are the commands used in sql?
Why do we use sql constraints?
How do I order by ascending in sql?
What are the parameter modes supported by pl/sql?
what are the differences between binary and varbinary? : Sql dba
Does normalization improve performance?
What is the purpose of design view?
what is collation? : Sql dba
What are user defined functions?
What are the different types of joins in sql?
Is oracel sql developer written in java?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
Is sql a backend?
What is the use of sqldataadapter?
What are sql data types?