•  ru
ShellHacks
Command-Line Tips and Tricks

oracle

  • Blog

Oracle: Get Database Server Host Name

Posted on Tuesday August 25th, 2020Tuesday August 25th, 2020by admin

In Oracle, it is possible to get a database server host name using a simple SQL query. In this note i will show how to SELECT the Oracle database server host name you’re currently connected to, using the SQL query that doesn’t require any special permissions. I will also show how to get the database […]

Read More
No comments yet
  • Blog

Oracle: Show Tables – SQL*Plus

Posted on Thursday August 20th, 2020by admin

Tables are the basic unit of data storage in Oracle databases. In this note i will show how to list all tables in an Oracle database (equivalent to SHOW TABLES command in MySQL) using the command-line interface of SQL*Plus. I will also show how to list only tables owned by the current user, show the […]

Read More
No comments yet
  • Blog

Oracle: Show Databases – SQL*Plus

Posted on Wednesday August 19th, 2020Thursday August 20th, 2020by admin

Oracle has no databases but schemas and users (that are essentially the same thing). The schema/user in Oracle can be considered as an equivalent to a “database” concept in MySQL, PostgreSQL or MS SQL. In this note i will show how to list all Oracle “databases” (equivalent to SHOW DATABASES command in MySQL), get the […]

Read More
No comments yet

Online Tools

  • Base64 Decode
  • Base64 Encode

Tags

access-control anonymity ansible apache archive artifactory aws bash boot cmd command-line curl dns docker encryption git java jenkins kubernetes linux mail mongodb mysql network nmap openssl oracle password pdf performance powershell prometheus proxy python rabbitmq raspberry pi redis ssh systemd telnet text-processing tor tsm windows yum
  • Twitter
  • RSS
Privacy
Copyright © 2011-2020 | www.ShellHacks.com