Scribd
Upload
11 views3 pages

Oracle Database Fundamentals Explained

Oracle offers various tools for database management, including SQL*Plus for command-line execution, SQL Developer for graphical interface, and Oracle Enterprise Manager for monitoring. Data types in Oracle define the nature of information stored in table columns, such as VARCHAR2 for variable-length strings and NUMBER for numeric values. SQL is a standard language for database communication, while SQL*Plus is a specific Oracle tool for executing SQL commands and formatting reports.

Uploaded by

suchismita singh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
11 views3 pages

Oracle Database Fundamentals Explained

Oracle offers various tools for database management, including SQL*Plus for command-line execution, SQL Developer for graphical interface, and Oracle Enterprise Manager for monitoring. Data types in Oracle define the nature of information stored in table columns, such as VARCHAR2 for variable-length strings and NUMBER for numeric values. SQL is a standard language for database communication, while SQL*Plus is a specific Oracle tool for executing SQL commands and formatting reports.

Uploaded by

suchismita singh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

1.

Tools of ORACLE
Oracle provides several tools to help users manage databases, write code, and generate
reports. Here are the most common ones:
●​ SQL*Plus: A command-line tool that comes with every Oracle installation. It allows you to
execute SQL and PL/SQL commands directly.
●​ SQL Developer: A free, graphical (GUI) tool that makes it easier to browse database
objects, run SQL queries, and debug code without memorizing command-line syntax.
●​ Oracle Enterprise Manager (OEM): A web-based tool used by Database Administrators
(DBAs) to monitor the health, performance, and security of the database.
●​ SQL*Loader: A high-speed utility used to "load" data from external files (like CSV or Excel)
into Oracle database tables.

2. Oracle Data Types


Data types define what kind of information can be stored in a table column.

Data Type Description Example

VARCHAR2(size) Variable-length character VARCHAR2(50) ->


string. Most common for 'Bhubaneswar'
names/addresses.

NUMBER(p, s) Stores fixed or floating-point NUMBER(7, 2) -> 15500.50


numbers. p is precision (total
digits), s is scale (decimals).

DATE Stores date and time 01-JAN-2026


information.

CHAR(size) Fixed-length character string. CHAR(3) -> 'IND'


If the data is shorter than the
size, it adds spaces.
CLOB Character Large Object. A 5-page report.
Used for very long text (like
an entire essay).

BLOB Binary Large Object. Used for student_photo.jpg


images, videos, or audio files.

Example: To store a student's info, you might use:


●​ student_id (NUMBER)
●​ student_name (VARCHAR2)
●​ date_of_birth (DATE)

3. Difference: SQL vs. SQL*Plus


It is common for students to confuse these two, but they serve very different purposes.

Feature SQL (Structured Query SQL*Plus


Language)

Definition A standard language used to A tool/utility (software) used


communicate with the to send SQL commands to the
database. database.

Function Used to Create, Insert, Used to format reports, set


Update, and Delete data. page sizes, and execute SQL
scripts.

Syntax Standardized (mostly the Specific to Oracle only.


same across MySQL, Oracle,
etc.).
Ending Commands usually end with Commands do not necessarily
a semicolon ;. need a ; (e.g., DESC
table_name).

Example SELECT * FROM students; SET LINESIZE 100 or SPOOL


[Link]

Comparison Example:
Imagine you are writing a letter.
●​ SQL is the language (like English) you use to write the message.
●​ SQL*Plus is the pen and paper (the tool) you use to actually write and send that message.

You might also like