SQL SELECT Database
SQL SELECT Database
Suppose database users and administrators want to perform some operations on tables, views, and indexes on the specific existing database in SQL. Firstly, they have to select the database on which they want to run the database queries.
Any database user and administrator can easily select the particular database from the current database server using the USE statement in SQL.
Syntax of USE statement in SQL
- USE database_name;
In this syntax, we have to define the name of the database after the USE keyword and the name of the database must be unique.
Syntax of USE statement in MySQL
- USE database_name;
Syntax of USE statement in Oracle
There is no need to select the database in Oracle.
