How To Export Your Connection Information to a File?

Submitted by: Administrator
SQL Developer allows you to export your connection information into an XML file. Here is how to do this:

► Right-click on Connections
► Select Export Connection...
► Enter File Name as: empconnections.xml
► Click OK

Open empconnections.xml, you should see an XML message like this:
<pre><?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></pre>
Submitted by: Administrator

Read Online Oracle Database Job Interview Questions And Answers