Let’s say we have the table – ms_oracleapps_users which
provides the listing of oracleappshelp registered users in the DATABASE –
OracleappshelpDB. Below given are the possible option of selecting the data
from the ms_oracleapps_users table.

Option 1: Using T-SQL script

The below command allows/ enables you to use the Database
OracleappshelpDB for performing the select query.

Syntax:

Exec use <DATABASE_NAME>

SQL: Exec use OracleappshelpDB

The below SELECT Query can be performed now on the ms_oracleapps_users table

Option 2: Using SQL Server Management Studio

Syntax: Select * from <DATABASE_NAME>

SQL: Select * from ms_oracleapps_users

SQL Server Drop Database Command

Now let’s consider that we might not
require the above created Database OracleappshelpDB. In that case, below given are the possible
option of selecting the data from the ms_oracleapps_users table

Option 1: Using T-SQL script

The below command allows/ enables you to use the Database
OracleappshelpDB for performing the select query.