Oracle 10G is a database management system and application server. It is used to distribute database programs and applications over an enterprise network to client workstations. These are used in automating many data management tasks. It can also be used to improve several key functions which impact data administration ranging from compiler performance to enhanced query expressions.
Following are the functions of the Oracle10G server:
Program Compilation:
In this version of Oracle 10G program, compilations are stored in database when compared to previous versions in which program compilations are stored in executable libraries. This allows the easy extraction of programs. 10G version makes troubleshooting and database development easier.
Tables:
Tables holds the information in a database which can be accessed by the programmers. With the help of improved primary and secondary key functions, tables with common items can be joined. Different kinds of reports from various tables can be created using this feature.
Compiler Functions:
Compilers are used when creating database structures for program usage and if the syntax is not used properly it causes compiler errors. The very important feature in Oracle 10G, is that the compiler warnings are produced when ambiguous code is used, which will further improve compiler module. Four types of warnings, including all, informational, severe and performance warnings are released by compiler based on the severity.
Query Expressions:
10G has new query expressions at the user level to extract data. Database records can be viewed by using many command level query commands. The integer statement, which has a new function can bring back the number of records and it can also be used as a database formula.
The above are the various functions of Oracle 10G server.