Introduction To SQL

Database Objects

A database object is any defined object in a database that is used to store or reference data.Anything which we make from create command is known as Database Object. It can be used to hold and manipulate the data. Some of the examples of database objects are : view, sequence, indexes, etc.

Posted September 22, 2022 by Anusha and Rohith ‐ 8 min read

⌖ sql rdbms

SQL * Plus

SQL*Plus is a client terminal software allowing users to interact with Oracle server to manipulate data and data structures. Users type in SQL statements in SQL*Plus that send statements to Oracle server. Oracle server then validates and executes the statements on its databases. The query results are returned to SQL*Plus and displayed to the user.

Posted September 22, 2022 by Anusha and Rohith ‐ 2 min read

⌖ sql rdbms

Set Commands

Sets a system variable to alter the SQL*Plus environment settings for our current session, for example: Display width for data, Turn on HTML formatting, Enabling or disabling printing of column headings, Number of lines per page.

Posted September 22, 2022 by Anusha and Rohith ‐ 4 min read

⌖ sql rdbms set-commands

ORDER BY Clause

The SQL ORDER BY clause is used to sort the data in ascending or descending order, based on one or more columns. Some databases sort the query results in an ascending order by default.

Posted September 22, 2022 by Anusha and Rohith ‐ 2 min read

⌖ sql rdbms order-by

GROUP BY Clause

The SQL GROUP BY clause is used in collaboration with the SELECT statement to arrange identical data into groups. This GROUP BY clause follows the WHERE clause in a SELECT statement and precedes the ORDER BY clause.

Posted September 22, 2022 by Anusha and Rohith ‐ 2 min read

⌖ sql rdbms group-by

Subscribe For More Content