CREATING MANUAL DATABASE
Create the following directories in a folder where u want to
create database:
-- c:\oracle\admin\dbname
-- c:\oracle\oradata\dbname
-- ...
Tuesday, January 23, 2018
Differences Between Anonymous Blocks and Subprograms
1. Anonymous is unnamed plsql block
A stored procedure or a named block is a pl/sql block.
2. Anonymous cannot save in database,
oracle stores pl/sql block in the database.
3. We cannot call Anonymous
blocks. We can recall named block
Whenever program require it.
4 Anonymous Block cannot allow any mode of parameter.
Named block accepts the...
Saturday, January 20, 2018
About Me
Thank you for your interest in my profile! Here is some detail about myself, in case you wondered.
I am an Oracle Trainer working for Aptech-in Mumbai. In addition to this web blog, I have published five
other blogs....
