Oracle schema

From: Francois Piette (francois.piette_at_overbyte.be)
Date: 05/24/04 

Date: Mon, 24 May 2004 10:45:17 +0200

Is there a way to specify a default schema when querying an Oracle database
with a ADO component ?

I have an application to convert to Oracle database. In the original
application, all SQL queries doesn't qualify table names. To convert to the
Oracle database, I have to edit all queries to qualify all table names with
schema.
Example:
   Original: SELECT * FROM MYTABLE
   Conversion: SELECT * FROM MYSCHEMA.MYTABLE

This is a lot of work given the large number of queries. I would spare a lot
of time only if I could specify "MYSCHEMA" as default value !

If it makes a difference, the application is using Delphi 7.01,
TAdoConnection, TAdoQuery, Oracle 9 client and Oracle 8 database.

Any advice appreciated. 

--
francois.piette@overbyte.be
Author of ICS (Internet Component Suite, freeware)
Author of MidWare (Multi-tier framework, freeware)
http://www.overbyte.be

Relevant Pages

  • Re: to upload a CSV file into oracle database
    ... :i have a CSV file and i want to upload it to oracle database. ... even has 2 consecutive "," to specify a blank field. ...
    (comp.databases.oracle.tools)
  • to upload a CSV file into oracle database
    ... i have a CSV file and i want to upload it to oracle database. ... even has 2 consecutive "," to specify a blank field. ...
    (comp.databases.oracle.tools)
  • OWB client and HR sample schema
    ... I'm new to Oracle Database Warehousing and OLAP, ... OWB 9.2 for experiment. ... When I tried to connect to the sample schema ... HR schema has been unlocked. ...
    (comp.databases)
  • DBA_PROCEDURES / DBA_TRIGGERS
    ... We are using Oracle Database 10g Enterprise Edition Release ... When I select * from DBA_PROCEDURES where OWNER = 'XYZ' I can see ONLY ... valid procedures in that schema. ...
    (comp.databases.oracle.server)