dbTalk Databases Forums  

nested select problem

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss nested select problem in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Brandon
 
Posts: n/a

Default nested select problem - 07-11-2008 , 08:20 AM






I have a statement that executes in SQL*Plus but not within Pro*C.
I'm guessing it has to do with where the nested select is (I know it
works from the where clause)

SELECT foo, (SELECT bar from baz where id = 1) FROM table1 WHERE ....

Pro*C does not like the "SELECT bar". Can I not place nested selects
in this part of my statement when compiling with Pro*C?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.