Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews DB Oracle Interviews:Concepts and ArchitectureData AccessDatabase ArchitectureDatabase ManagementDatabase Security OracleDistributed ProcessingFlexfieldForms ReportsGeneral OracleMemory ManagementMTO-SAP Financial AccountingOCIOracle AOLOracle AROracle Backup RecoveryOracle D2KOracle DatabaseOracle Database DeveloperOracle DB OptimizationOracle DBAOracle DeveloperOracle ETLOracle Forms 3.0Oracle Forms 4.0Oracle GLOracle PL-SQLOracle RMANOracle ScenariosOracle SecurityOracle SQLOracle System ArchitectureOracle Technology Network (OTN)Programmatic ConstructsRAC (Real Application Clusters)SQL Plus
Copyright © 2018. All Rights Reserved
Oracle Database Interview Question:
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
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.