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. Difference between truncate and delete
(Forum/Professional)

.... 2>TRUNCATE is much faster than DELETE. Reason:When you type DELETE.all the data get copied into the Rollback Tablespace first.then delete operation get performed.Thatswhy when you type ROLLBAC...

3. Difference between truncate and delete
(Forum/Professional)

.... 2>TRUNCATE is much faster than DELETE. Reason:When you type DELETE.all the data get copied into the Rollback Tablespace first.then delete operation get performed.Thatswhy when you type ROLLBAC...

4. Optional Flexible Architecture (OFA) of Oracle
(FAQs/Oracle Group)

... TOOLS - Tools table. 7. TOOLS1 - Indexes for tools table. 8. RBS - Standard Operations Rollback Segments, 9. RBS1,RBS2 - Additional/Special Rollback segments. 1...

5. SQL-ST-01
(Workshop/SQL)

...ng grant and revoke statements   TCL : transaction Control Language, Transactions, Commit Statement, Rollback Statement, generating single Savepoint, Using Rollback with savepoint, generating m...

6. My Training on oracle
(MyBlog/MyBlog)

...the following: GRANT, REVOKE 4. TCL - Transaction Control Language commands include the following: COMMIT, ROLLBACK 5. QUEERY -   Second day- Object in oracle---- oracle has kind of object jus...

7. My Oracle Training Details
(MyBlog/MyBlog)

...anguage. command are UPDATE,DELETE, INSERT. 3. TCL : transection control language. command are COMMIT & ROLLBACK. 4. DCL : data control language. commands are GRANT & REVOKE. 5. QUERY: all the...

8. Database Terminology in Oracle
(Articles/Oracle)

...a database will hold the contents of a table or an index, but there are other types of segments as well. Rollback Segment: A rollback segment stores �undo� information for a t...

9. Changes In 9i To Be Aware Of.
(Articles/Oracle)

...he CREATE SPFILE and CREATE PFILE commands. * "System managed undo" or SMU can be used instead of rollback segments. o With SMU you designate a tablespace as an undo tablespace and Oracle do...

10. Files that control oracle instances
(Articles/Oracle DBA)

...iles = (/u02/oradata/pubdb/control01.ctl,/u03/oradata/pubdb/control02.ctl,/u04/oradata/pubdb/control03.ctl) rollback_segments = (r01,r02,r03,r04) background_dump_dest = /u01/app/oracle/admin/pubdb/bdu...

11. Optional Flexible Architecture (OFA) of Oracle
(FAQs/Oracle Group)

... TOOLS - Tools table. 7. TOOLS1 - Indexes for tools table. 8. RBS - Standard Operations Rollback Segments, 9. RBS1,RBS2 - Additional/Special Rollback segments. 1...

12. SQL-ST-01
(Workshop/SQL)

...ng grant and revoke statements   TCL : transaction Control Language, Transactions, Commit Statement, Rollback Statement, generating single Savepoint, Using Rollback with savepoint, generating m...

13. My Training on oracle
(MyBlog/MyBlog)

...the following: GRANT, REVOKE 4. TCL - Transaction Control Language commands include the following: COMMIT, ROLLBACK 5. QUEERY -   Second day- Object in oracle---- oracle has kind of object jus...

14. My Oracle Training Details
(MyBlog/MyBlog)

...anguage. command are UPDATE,DELETE, INSERT. 3. TCL : transection control language. command are COMMIT & ROLLBACK. 4. DCL : data control language. commands are GRANT & REVOKE. 5. QUERY: all the...

15. Database Terminology in Oracle
(Articles/Oracle)

...a database will hold the contents of a table or an index, but there are other types of segments as well. Rollback Segment: A rollback segment stores �undo� information for a t...

16. Changes In 9i To Be Aware Of.
(Articles/Oracle)

...he CREATE SPFILE and CREATE PFILE commands. * "System managed undo" or SMU can be used instead of rollback segments. o With SMU you designate a tablespace as an undo tablespace and Oracle do...

17. Files that control oracle instances
(Articles/Oracle DBA)

...iles = (/u02/oradata/pubdb/control01.ctl,/u03/oradata/pubdb/control02.ctl,/u04/oradata/pubdb/control03.ctl) rollback_segments = (r01,r02,r03,r04) background_dump_dest = /u01/app/oracle/admin/pubdb/bdu...