How many times can we commit in a loop?
No Answer is Posted For this Question
Be the First to Post Answer
How to select all records from the table?
How to disable a trigger name update_salary?
Which data type doesn't allow null data type?
what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?
Explain what is a view?
What is the clause we need to add in function body to return variable?
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.
What are expressions?
How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?
What is the sql query to display the current date?
what are the different index configurations a table can have? : Sql dba
i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....