db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steve Toth <steveft...@gmail.com>
Subject Putting schema into the select clause
Date Thu, 26 Aug 2004 23:38:45 GMT
I'm trying to use Torque with Oracle and I'm not sure how to get
torque to put the schema before all table names during select
operations...

Right now the SQL is coming out like this..

SELECT TABLE.COL1, TABLE.COL2, TABLE.COL3 FROM TABLE

I want it to look like this
SELECT TABLE.COL1, TABLE.COL2, TABLE.COL3 FROM SCHEMA.TABLE

or 
SELECT TABLE.COL1, TABLE.COL2, TABLE.COL3 ,TABLE2.COL1 FROM
SCHEMA.TABLE, SCHEMA2.TABLE2

What do I need to do in my schema.xml file, or generation ?

Thanks!

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message