Collections:
Export Connection Information to a File in Oracle
How To Export Your Connection Information to a File in Oracle?
✍: FYIcenter.com
SQL Developer allows you to export your connection information into an XML file. Here is how to do this:
Open \temp\connections.xml, you should see an XML message like this:
<?xml version = '1.0'?> <!DOCTYPE connections> <connections> <connection> <JDBC_PORT>1521</JDBC_PORT> <HOSTNAME>127.0.0.1</HOSTNAME> <ConnectionType>JDBC</ConnectionType> <DeployPassword>false</DeployPassword> <user>HR</user> <ConnectionName>Local_XE</ConnectionName> <SID>XE</SID> <JdbcDriver>oracle.jdbc.driver.OracleDriver </JdbcDriver> <PWD> <![CDATA[0519D91AA309BF15EA9E54BF55F863710496...]]> </PWD> <ORACLE_JDBC_TYPE>thin</ORACLE_JDBC_TYPE> </connection> </connections>
⇒ Run SQL*Plus Commands in SQL Developer in Oracle
⇐ Run SQL Statements with SQL Developer in Oracle
2018-10-08, 1534🔥, 0💬
Popular Posts:
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...