|
My background is SQL Server and I’m now working with ORACLE.
The codebase I’m working with has queries that reference tables using schema.tablename.
The queries do not work without the schema prefix. In SQL world, I never
used a prefix for my table names in the SQL syntax. Is there a setting
someplace in ORACLE I can set to not use schemas in SQL statements? If I
have to use the schema name in my queries to reference a table, then I see an
issue if I need to use my code against a different database. It’s
been my assumption that the datasource removes the need for using a schema
table prefix. I know I could put the schema in a variable and use the
variable in all of SQL queries, but I do not like that solution. Any
ideas? Thanks Tom Schreck Applications Developer Dresser, Inc. 972-361-9943 |
<<attachment: image001.jpg>>
