![]() ![]() Now, you connected to the PDBORCL database. Code language: SQL (Structured Query Language) ( sql ) If you want to switch to a pluggable database, use the ALTER SESSION statement to set the current database to the pluggable database e.g., PDBORDL as follows: SQL> ALTER SESSION SET CONTAINER = PDBORCL ![]() To display database name, you use the SHOW command: SQL> SHOW con_name Ĭode language: SQL (Structured Query Language) ( sql ) In Oracle 12c, when you connect to the Database Server, the default database is the ROOT container database with the name CDB$ROOT. It means that you have connected to the Oracle Database Server. Suppose you want to connect to the local Oracle Database Server using the sys account, you enter the following information: Enter user-name: sys as sysdbaĮnter password: Code language: SQL (Structured Query Language) ( sql )Īfter pressing enter, you should see a message followed by the SQL> command line as follows: SQL>_ Code language: SQL (Structured Query Language) ( sql ) If you don’t know which account to use, ask your Database Administrator. Enter your username and password that you chose during the installation of the Oracle Database Server. When you launch the SQLPlus icon, it will prompt for username and password. You can also find the SQL*Plus program in the Program folder of the Start Menu on Windows as shown below: ![]() To launch the SQL*Plus program, from the Linux or Window terminal, you enter the sqlplus command: sqlplus Code language: SQL (Structured Query Language) ( sql ) If you have worked with MySQL or PostgreSQL, SQL*plus is similar to mysql program in MySQL or psql in PostgreSQL. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |