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 6154i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w
4 16050i 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 8567Write 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 8792how to see the oracle 9i/10g table in pc? or In my pc where the table is saved and how to see?
1 3503i 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
1 5404I 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 5114Is 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 4616Use 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 7754
what is dbms? : Sql dba
is it possible to pass an object or table to a procedure as an argument?
How to execute a stored procedure?
What is bulk compiling in pl/sql.?
How can we implement rollback or commit statement in a trigger?
What is trigger in sql? Explain
What is pl sql in dbms?
how to use like conditions? : Sql dba
How do I view an execution plan in sql?
what is table? : Sql dba
Can we delete column in sql?
How to get list of all tables from a database?
how tsql statements can be written and submitted to the database engine? : Transact sql
How do I install microsoft sql?
difference between anonymous blocks and sub-programs.