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. prcedure and function
(Forum/Forms)

1)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) F

3. Re:problem related with updte of tabuler forms
(Forum/Novice)

...se table BLOCKS... :cheer: Please note it you have used wizard then there are various add on triggers and procedures which are incorporated by default.. :cheer:...

4. What is trigger
(FAQs/Sql Plus)

In a 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

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

... oracle do get confused with trigger in oracle forms and database triggers.Database triggers are like stored procedured but triggers in forms are statement which are executed.Eg When an operation clic...

6. My Training on oracle
(MyBlog/MyBlog)

...y- Object in oracle---- oracle has kind of object just like. Table, View, Index, Cluster, Function, Libary, Procedure, Schema.. Table- Servel records of equal length laced one below the other to enab...

7. What are Plsql Modules
(FAQs/PL/SQL)

basic PLSQL Modules are  Functions, Triggers,Procedures,package,package body,Type, type body

8. What is PL/SQL?
(Articles/PL/SQL)

... with procedural constructs such as IF-THEN and LOOP. Users can also declare constants and variables, define procedures and functions, use collections and object types, and trap run-time errors. Appl...

9. Database Terminology in Oracle
(Articles/Oracle)

...ssword. Schema: A schema is a separate namespace for database objects such as tables, indexes, and stored procedures. Every database object resides in exactly one schema. Each database user has exa...

10. IN AND OUT PARAMETER IN PLSQL PROGRAMMING
(Articles/PL/SQL)

...(read-only), OUT (write-only), and INOUT (read and write). IN, OUT and INOUT Modes Values are passed to a procedure in three modes; IN, OUT and INOUT. The mode which a variable is passed defines h...

11. What is trigger
(FAQs/Sql Plus)

In a 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

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

... oracle do get confused with trigger in oracle forms and database triggers.Database triggers are like stored procedured but triggers in forms are statement which are executed.Eg When an operation clic...

13. My Training on oracle
(MyBlog/MyBlog)

...y- Object in oracle---- oracle has kind of object just like. Table, View, Index, Cluster, Function, Libary, Procedure, Schema.. Table- Servel records of equal length laced one below the other to enab...

14. What are Plsql Modules
(FAQs/PL/SQL)

basic PLSQL Modules are  Functions, Triggers,Procedures,package,package body,Type, type body

15. What is PL/SQL?
(Articles/PL/SQL)

... with procedural constructs such as IF-THEN and LOOP. Users can also declare constants and variables, define procedures and functions, use collections and object types, and trap run-time errors. Appl...

16. Database Terminology in Oracle
(Articles/Oracle)

...ssword. Schema: A schema is a separate namespace for database objects such as tables, indexes, and stored procedures. Every database object resides in exactly one schema. Each database user has exa...

17. IN AND OUT PARAMETER IN PLSQL PROGRAMMING
(Articles/PL/SQL)

...(read-only), OUT (write-only), and INOUT (read and write). IN, OUT and INOUT Modes Values are passed to a procedure in three modes; IN, OUT and INOUT. The mode which a variable is passed defines h...