Oracle is one the most popular Relational Database Management System (RDBMS). Some other famous RDBMS includes Microsoft SQL Server, Sybase, MySQL, PostgreSQL, etc. Essentially, all the aforementioned RDBMS employs Structural Query Language (SQL) as their query interface. Users usually issue their queries by SQL through a "client". Different RDBMS offer different forms of clients. For example, MS SQL Server offers a GUI interface for user to type in their SQL language, and their queries would be executed after pressing the "Execute" button on the client. Oracle provides both GUI client and command-line client. In this lesson, we will study the command-line client, SQL*Plus. In addition, Oracle extends the standard SQL (e.g. select * from table) with its application-specific commands (e.g. checking how many table you have been created in your Oracle account) into a Oracle specific language called PL/SQL.
Monday, July 18, 2011
Getting Started With Oracle
Oracle is one the most popular Relational Database Management System (RDBMS). Some other famous RDBMS includes Microsoft SQL Server, Sybase, MySQL, PostgreSQL, etc. Essentially, all the aforementioned RDBMS employs Structural Query Language (SQL) as their query interface. Users usually issue their queries by SQL through a "client". Different RDBMS offer different forms of clients. For example, MS SQL Server offers a GUI interface for user to type in their SQL language, and their queries would be executed after pressing the "Execute" button on the client. Oracle provides both GUI client and command-line client. In this lesson, we will study the command-line client, SQL*Plus. In addition, Oracle extends the standard SQL (e.g. select * from table) with its application-specific commands (e.g. checking how many table you have been created in your Oracle account) into a Oracle specific language called PL/SQL.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment