How to check db name in mysql
- sqlplus show database name
- sqlplus show databases
- sqlplus command to show databases
- sqlplus show users
Sqlplus show tables
How to check oracle database name in linux!
SQL*Plus Command Reference
SQL*Plus is a command-line tool for Oracle Database that allows users to interact with the database using SQL and PL/SQLcommands.
Here, we will discuss the SQL*Plus commands, and understand how to use the SQL*Plus command-line argument.
SQL*Plus Commands
Here is a list of some essential SQLPlus Commands:
| Command | Syntax | Description |
|---|---|---|
| CONNECT | CONNECT username/password@hostname:port/service_name; | Connects to a database using the specified credentials and connection details. |
| SELECT | SELECT * FROM tablename; | Executes an SQL query to retrieve data from a table. |
| DESCRIBE | DESCRIBE tablename; | Displays the structure of a table (columns, data types, etc.). |
| SET LINESIZE | SET LINESIZE n; | Sets the maximum line width for query output. |
| SET PAGESIZE | SET PAGESIZE n; | Sets the number of lines per page for query output. |
| SPOOL | SPOOL filename; | Redirects query output to a file. |
| START | START script.sql; | Executes a script file. |
| EDIT | EDIT; | Opens the default text editor to edit the current command buffe
|