Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > Query Oracle Du...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 30575 of 31576
Post > Topic >>

Query Oracle Dual via Access Link Table?

by Luting <houluting@[EMAIL PROTECTED] > Jun 24, 2008 at 10:42 AM

Hi everyone,

I am working on a project using Access as the frontend of a Oracle
database. I'd like to use the Dual table in Oracle so I made a link
table in Access for the Dual. However, it doesn't work when I run the
following queries:

SELECT sysdate
FROM dual;
(dual is the link table in Access)

or

SELECT col_1
FROM dual

Why is that? Is there any way to accomplish what I want? Thx.
 




 2 Posts in Topic:
Query Oracle Dual via Access Link Table?
Luting <houluting@[EMA  2008-06-24 10:42:23 
Re: Query Oracle Dual via Access Link Table?
Luting <houluting@[EMA  2008-06-24 12:23:05 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 23:26:20 CST 2008.