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. Re:hoe to convert oracle database into a flat file li
(Forum/Novice)

...ol Off The about commands will create a Flat file data.txt You can use various sqlplus commands for formatting the columns. The formatted text file can be imported into xcell sheel as xls file ...

3. What Is a Static Data Dictionary
(Forum/Professional)

Data dictionary tables are not directly accessible, but you can access information in them through data dictionary views. To list the data dictionary views available to you, query the view DICTIONARY.

4. What Is a Static Data Dictionary
(Forum/Professional)

Data dictionary tables are not directly accessible, but you can access information in them through data dictionary views. To list the data dictionary views available to you, query the view DICTIONARY.

5. Very beautiful description....wow
(Comments)

Awesome comments to a very good post. this information is very usefull for me, and very intreesting. A+++++++++++++++ thanx

6. single query to convert numeric to words
(Articles/SQL)

...dual; CONVERTED_FORM --------------------------- EIGHT HUNDRED SEVENTY-THREE J represents the Julian format. When the to_char function is applied to the result of to_date, it spells (SP) the word...

7. Oracle Database Table
(Articles/Oracle)

...re of the NUMBER datatype, define precision and scale instead of width. A row is a collection of column information corresponding to a single record. How Many Types of Tables Supported by Oracle? Or...

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

SQL WORK SHOP- SQL-ST-01 BASIC JUMP START ORACLE TRAINING O Level  6 Days (18 hrs)   Go4oracle.com : an online oracle community service implemented to provide solution to beginner

9. Install Oacle 10G XE on linux ubuntu
(Articles/Oracle)

...p;  Reading package lists... Done    Building dependency tree    Reading state information... Done    .    .    .    Need to get 221MB/...

10. Resolving Slow Client Server Architecture
(Articles/Oracle DBA)

...uld disable timed statistics for the session after all initialization is complete. This caused the time information in v$session_event to reflect wait times during the form startup phase only; the tim...

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

...Declaration of a cursor is always in the declare section of the PLSQL block. Basically it is of following format. Declare Cursor cursor_name is Select .. , .... , ... from Table_Name; The above d...

12. Database Space Management
(Articles/Oracle)

...s of database objects. They are the reason you have the database in the first place. You have tables of information that you want to store and retrieve, and you create indexes on those tables to facil...

13. Whats Is SGA system global area
(Articles/Oracle)

A system global area (SGA)  is a group of shared memory structures that contain data and control information for one Oracle database instance. If multiple users are concurrently connected to the

14. ROWID OF A RECORD (PSUEDO COLUMN)
(Articles/Oracle)

...or each row in the database the row id psuedocolomn returns a row address .oracle 8 rowid value contain information nessasary to locate a row. 1. which data object number of the object. 2. which dat...

15. What is SQL Loader
(FAQs/Loader)

...in database (Tables)  from a flat file Eg a data in a text file can be inserted into the table. The format of the file in terms of records layour will determine the type of program which is to b...

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

...d modern software engineering features such as data encapsulation, overloading, exception handling, and information hiding.By using PL/SQL, users can manipulate data with SQL statements and control pr...

17. Database Terminology in Oracle
(Articles/Oracle)

... the term username synonymous with schema. Data Dictionary: Each Oracle database has a repository of information indicating all of the users defined in the database and all of the objects they own ...

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

...set undo_retention to the number of seconds Oracle should try to wait before overwriting committed undo information. (The default retention is 900 seconds.) o Set undo_suppress_errors = TRUE to cause ...

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

...when you define the variable. OUT Mode(write-Only) A variable passed in OUT mode is used to pass information back from the procedure to the calling program. It is a write-only variable and has...

20. Wait Events In Oracle
(Articles/Oracle DBA)

...s all about tracking the wait events by the DBA's. This can be known by querying v$ views, in depth information is provided for what events processes are waiting. we might encounter a case to lear...

21. Oracle database control file
(Articles/Oracle DBA)

...database.CONTROL FILES : A control file in oracle database is a physical file (binary) which stores the information like (list of all is provided in the end) name of the database, character set used, ...

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

...ised of a set of operating system files containing data entered by users or applications and structural information about the database itself called database metadata. Information is stored persistent...

23. single query to convert numeric to words
(Articles/SQL)

...dual; CONVERTED_FORM --------------------------- EIGHT HUNDRED SEVENTY-THREE J represents the Julian format. When the to_char function is applied to the result of to_date, it spells (SP) the word...

24. Oracle Database Table
(Articles/Oracle)

...re of the NUMBER datatype, define precision and scale instead of width. A row is a collection of column information corresponding to a single record. How Many Types of Tables Supported by Oracle? Or...

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

SQL WORK SHOP- SQL-ST-01 BASIC JUMP START ORACLE TRAINING O Level  6 Days (18 hrs)   Go4oracle.com : an online oracle community service implemented to provide solution to beginner

26. Install Oacle 10G XE on linux ubuntu
(Articles/Oracle)

...p;  Reading package lists... Done    Building dependency tree    Reading state information... Done    .    .    .    Need to get 221MB/...

27. Resolving Slow Client Server Architecture
(Articles/Oracle DBA)

...uld disable timed statistics for the session after all initialization is complete. This caused the time information in v$session_event to reflect wait times during the form startup phase only; the tim...

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

...Declaration of a cursor is always in the declare section of the PLSQL block. Basically it is of following format. Declare Cursor cursor_name is Select .. , .... , ... from Table_Name; The above d...

29. Database Space Management
(Articles/Oracle)

...s of database objects. They are the reason you have the database in the first place. You have tables of information that you want to store and retrieve, and you create indexes on those tables to facil...

30. Whats Is SGA system global area
(Articles/Oracle)

A system global area (SGA)  is a group of shared memory structures that contain data and control information for one Oracle database instance. If multiple users are concurrently connected to the