Toad World® Forums

heterogenous query for joining Excel and Oracle tables


#1

Dear all,

Has anyone create a heterogenous query in Toad query builder? I created a query
to join Excel source and an Oracle table.

When I run query on each table individually, it runs without error, but once i
start joining them, the query gives me an error. Any thoughts? Could any Toad
experts shed some light on how to join Excel to Oracle N tables via Toad in
details?

SELECT EVENT_REASON_DOMAIN.EVENT_REASON
, EVENT_REASON_DOMAIN.W_EVENT_SUBG_CODE
, EVENT_REASON_DOMAIN.Action Code
, EVENT_REASON_DOMAIN.Action Desc
, EVENT_REASON_DOMAIN.Action Reason Code
, PS_ACTN_REASON_TBL.DESCR
FROM

`C:\Documents and

Settings\pxc5170\Desktop\domainValues_Emp_EventType_SubG_Code_psft.xlsx`.EVENT_REASON_DOMAIN
EVENT_REASON_DOMAIN
INNER JOIN

{{Odbc("DRIVER={Microsoft ODBC for

Oracle};SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.40.8.89)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=HRDEV91)));UID=PXC5170;PWD={0};,603812773F20A08F")}}.“SYSADM.PS_ACTN_REASON_TBL”
PS_ACTN_REASON_TBL
ON (CVAR(EVENT_REASON_DOMAIN.Action Reason Code) =
CVAR(PS_ACTN_REASON_TBL.ACTION_REASON));

Thank you in advance,

L


#2

That’s a Toad for Data Analysts feature, not Toad for Oracle. You need to
go to their community for help.

I’d be more than happy to help you over here

http://tda.inside.quest.com/index.jspa


#3

SEE ATTACHMENT
att1.dat (43 Bytes)


#4

SEE ATTACHMENT
image004.gif


#5

SEE ATTACHMENT
att1.dat (43 Bytes)


#6

SEE ATTACHMENT
att1.dat (43 Bytes)


#7

SEE ATTACHMENT
att1.dat (43 Bytes)


#8

Support is support, regardless of what Quest product you are using.

We have communities you can go to for help if you want, your choice!

If you are a freeware user, using a copy of Toad that is no longer current on
support, then your only alternative is the community.


#9

SEE ATTACHMENT
image004.gif


#10

SEE ATTACHMENT
att1.dat (43 Bytes)