I will also show how to get the database name, the current schema/user and the name and IP address of the host machine from which the client has connected. 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. There are so many types of system views in Oracle. 1 To view database select from vdatabase. How to Change database name in oracle 10g an 11g we have 3 methods to change database in oraclerecreating the control file and renaming instance name. In Oracle, it is possible to get a database server host name using a simple SQL query. SQL STARTUP MOUNT ORACLE instance started.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |