Best way to interface with Oracle

From: "brogdonm" <Brogdons@xxxxxxxxx>
Date: 27 Dec 2005 10:37:35 -0800

Hi, I am needing a way to query information from an Oracle Database and
then save the information in SQL. What is the best option? Doing this
inside MS SQL (if so, how would I go about doing this--commands, etc)
or by an outside source (scripts--vbscript, javascript, perl)?

Thanks in advanced,
Mike

.

Prev by Date: Re: SQL Server 2000 Installation error
Next by Date: Re: SQL Server 2000 Installation error
Previous by thread: How many CALs for a web page?
Next by thread: Oracle/MS SQL Interface
Index(es):
- Date
- Thread

Relevant Pages

[Full-disclosure] Team SHATTER Security Advisory: SQL Injection in Oracle Database (DBMS_DEFER_S
... The PL/SQL package DBMS_DEFER_SYS owned by SYS has an instance of SQL ... and execute SQL statements with the elevated privileges of SYS user. ... Any Oracle database user with EXECUTE privilege on the package ... Vendor was contacted and a patch was released. ...
(Full-Disclosure)
Team SHATTER Security Advisory: SQL Injection in Oracle Database (DBMS_DEFER_SYS.DELETE_TRAN)
... The PL/SQL package DBMS_DEFER_SYS owned by SYS has an instance of SQL ... and execute SQL statements with the elevated privileges of SYS user. ... Any Oracle database user with EXECUTE privilege on the package ... Vendor was contacted and a patch was released. ...
(Bugtraq)
Re: performance issue after upgrade to oracle 11.2.0.1 linux 32 bit.
... Result: Choose incorrect execution plan. ... SQL> set autotrace trace ... Disconnected from Oracle Database 11g Enterprise Edition Release ...
(comp.databases.oracle.server)
Re: sqlplus: Help with Spooling (path and file questions)
... I'm trying to figure out how to create path and filename ... for the spool command in sqlplus. ... SQL> column date_column new_value today ... Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - ...
(comp.databases.oracle.server)
Re: if I call a plsql is there a commit?
... After p2 is there a commit or it is after end? ... Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production ... SQL> CREATE PROCEDURE p2 IS ... -- Session 2 in a different SQL*Plus session ...
(comp.databases.oracle.misc)