Before starting course SQL fundamentals for Oracle 10G for OCA certification, you need to understand difference between SQL and SQL PLUS.In our online free sql course for OCA , you going to see ‘n’ number of times refering above keywords. Here is the difference.
Source: http://www.geekinterview.com/question_details/2494
SQL
- SQL is a language that can communicate with Oracle server to access the data.
- It is based on ANSI standards.
- There is no continuation character.
- Keywords cannot be abbreivated.
- Use functions to manipulate the data.
SQL*PLUS
- It recognises SQL statement and sends them to the server.
- Is an Oracle properitory.
- There is a continuation character.
- Keywords can be abbreviated.
- Use commands to manipulate the data.
So SQL is language and SQL*PLUS is software interface developed by Oracle to feed SQL commands to Oracle database server.
Other Posts related to current topic
- Passed OCA PAPER -1 Oracle 9i sql 1Z0-007
- How to apply for OCA exam 1Z0-007
- 01. Lets learn SQL statement SELECT 1Z0-007
- Oracle DBA and SQL basics video tutorials - 00
- SQL vs SQLPLUS - Learn SQL online (This post)
- Project OCA DBA DAY-1 schedule details.FREE OCA tutorial
- Let's start PROJECT OCA
- Oracle OCA DBA certification details and guidance
- How to convert as oracle DBA from system administrator
- How Oracle Works in single shot
- Best books to learn Oracle DBA
- Got the software now time to gather Oracle 10g books
- Oracle 10g Express vs Standard vs Enterprise
- Become a Oracle DBA within 25 days
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License
