CREATING MANUAL DATABASECreate the following directories in a folder where u want to create database:-- c:\oracle\admin\dbname-- c:\oracle\oradata\dbname-- c:\oracle\admin\dbname\pfile-- ...
Tuesday, January 23, 2018
Differences Between Anonymous Blocks and Subprograms
1. Anonymous is unnamed plsql blockA 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 Anonymousblocks. We can recall named blockWhenever program require it.4 Anonymous Block cannot allow any mode of parameter.Named block accepts the mode ofParameter...
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. I have...
