I have a parent program and a child program. I want to write
a statement in Exception Block of the parent program so that
when the statement in the exception block is executed, the
control goes to the next statement in the parent block
bypassing the child block.How do i do that?
No Answer is Posted For this Question
Be the First to Post Answer
What is TNS File
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
what are archived logs?
what is difference between foreign key and reference key
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
What is the quickest way to export a table to a flat file?
What is autonomous transaction?
Can we create trigger on materialized view in oracle?
What is the data pump import utility?
Explain the use of control file?
Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?