How To Export Your Connection Information to a File?
Submitted by: AdministratorSQL 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
► 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
Top Oracle Database Questions
☺ | How To Recover a Dropped Table in Oracle? |
☺ | What Is the Relation of a User Account and a Schema? |
☺ | How To Use Values from Other Tables in UPDATE Statements using Oracle? |
☺ | How To Drop a Stored Function? |
☺ | What Is Input Buffer in SQL*Plus? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |