Go4Oracle

1. Handy PHP
(Joomla! & PHP Resources)

Handy PHP offers scripts, discussions, tutorials, answers, and other resources for PHP. This includes a growing number of resources for the Joomla! - Content Management System. Your ideas and question

2. How To Create Database Manually
(Forum/Advanced)

...O 3 / Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE "USER"; Database altered. 8. Execute the following script @%ORACLE_HOME%\RDBMS\ADMIN\catalog.SQL @%ORACLE_HOME%\RDBM...

3. prcedure and function
(Forum/Forms)

...Function returns only one value whereas procedure can return 0, 1 or more values. 2) DDL statement can be executed using execute immediate in procedure whereas it cannot be used in functions. 3) Fun...

4. What are ORACLE PRECOMPILERS
(FAQs/Oracle Group)

...dard Oracle runtime library calls, and generates a modified source program that one can compile, link, and execute in the usual way. Examples are the Pro*C Precompiler for C, Pro*Cobol for Cobol, SQLJ...

5. What is trigger
(FAQs/Sql Plus)

...DBMS, a trigger is a SQL procedure that initiates an action (i.e., fires an action) when an eventcalled or executed; the DBMS automatically fires the trigger as a result of a data modification to th...

6. Mutating Error In Database Trigger
(Articles/SQL)

...is error occurs when a row-level trigger accesses the same table on which it is based the trigger is being executed. This gives Mutating Error. The mutating error mostly occusrs  during the DM...

7. Whats Is Database Trigger
(Articles/PL/SQL)

Whats is Database triggers  Database triggers is a consist os sql and plsq statement which is executed on an predefined event.Database triggers are stored as a database object in oracle. Databa

8. Basic Cursor Writing
(Articles/PL/SQL)

... This is another operation that one has to work with. All cursors that are declared has to be opened to execute the select statement which is stored in the Cursor Area. Same cursor cannot be opened...

9. My Oracle Training Details
(MyBlog/MyBlog)

...mp; then perform operation . an interesting question comes infront of us that which one of the dml command execute faster among them & which is the slower one &why. Day 6 ; today we learn tha...

10. Database Terminology in Oracle
(Articles/Oracle)

... Oracle instance. The SGA includes a cache of most recently accessed data blocks, a cache of most recently executed SQL statements, latches for implementing locking mechanisms, among many other things...

11. What Is SQLPLUS
(FAQs/Sql Plus)

... PLSQL Language to interact with the databse .SQLPLUS has got its own set of commands to work on which are executed by new line. An SQL File can have Set of SQLPLUS Command with SQL and PLSQL Commands...

12. What are ORACLE PRECOMPILERS
(FAQs/Oracle Group)

...dard Oracle runtime library calls, and generates a modified source program that one can compile, link, and execute in the usual way. Examples are the Pro*C Precompiler for C, Pro*Cobol for Cobol, SQLJ...

13. What is trigger
(FAQs/Sql Plus)

...DBMS, a trigger is a SQL procedure that initiates an action (i.e., fires an action) when an eventcalled or executed; the DBMS automatically fires the trigger as a result of a data modification to th...

14. Mutating Error In Database Trigger
(Articles/SQL)

...is error occurs when a row-level trigger accesses the same table on which it is based the trigger is being executed. This gives Mutating Error. The mutating error mostly occusrs  during the DM...

15. Whats Is Database Trigger
(Articles/PL/SQL)

Whats is Database triggers  Database triggers is a consist os sql and plsq statement which is executed on an predefined event.Database triggers are stored as a database object in oracle. Databa

16. Basic Cursor Writing
(Articles/PL/SQL)

... This is another operation that one has to work with. All cursors that are declared has to be opened to execute the select statement which is stored in the Cursor Area. Same cursor cannot be opened...

17. My Oracle Training Details
(MyBlog/MyBlog)

...mp; then perform operation . an interesting question comes infront of us that which one of the dml command execute faster among them & which is the slower one &why. Day 6 ; today we learn tha...

18. Database Terminology in Oracle
(Articles/Oracle)

... Oracle instance. The SGA includes a cache of most recently accessed data blocks, a cache of most recently executed SQL statements, latches for implementing locking mechanisms, among many other things...

19. What Is SQLPLUS
(FAQs/Sql Plus)

... PLSQL Language to interact with the databse .SQLPLUS has got its own set of commands to work on which are executed by new line. An SQL File can have Set of SQLPLUS Command with SQL and PLSQL Commands...