How to call a sub procedure?
Answer / Arti Singh Bist
To call a sub-procedure, use the following syntax:
```plsql
BEGIN
sub_proc(parameter1, parameter2); -- Replace with actual parameters as needed
END;
/
```
| Is This Answer Correct ? | 0 Yes | 0 No |
What is cluster Key ?
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
Explain integrity constraints?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is the relation of a user account and a schema?
what are the diffeenes between oracle 9i,oracle 10g
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How to create a new tablespace in oracle?
What is a cognitive schema?
What is the function of Redo Log ?
Explain rename?
What is set verify off in oracle?