OraFAQ Forum: SQL & PL/SQL » how to extract data from oracle table having space in column name using vba code?

Home » SQL & PL/SQL » SQL & PL/SQL » how to extract data from oracle table having space in column name using vba code?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to extract data from oracle table having space in column name using vba code? [message #665409]

Tue, 05 September 2017 02:46

oracbeg
Messages: 16
Registered: July 2017

Junior Member

I really need some advice on this. Please. I have a oracle table having column names with spaces. I made a code having sql select query inside, which extracts data accordingly. It works for column name without spaces like "select column from table". i need to make work this in vba "select column name from table". What delimiters should i use. Have tried {},[],``. Please help

Report message to a moderator

Re: how to extract data from oracle table having space in column name using vba code? [message #665410 is a reply to message #665409]

Tue, 05 September 2017 03:15

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

If someone has done something so heretical, you need to reference the column in double quotes:

select "I hate them" from badtabledesign

Report message to a moderator

Re: how to extract data from oracle table having space in column name using vba code? [message #665426 is a reply to message #665410]

Tue, 05 September 2017 08:26

JPBoileau
Messages: 88
Registered: September 2017

Member

Try the double quotes:

SELECT "MYTABLE"."MYCOLUMN" FROM "MYTABLE";

Report message to a moderator

Re: how to extract data from oracle table having space in column name using vba code? [message #665428 is a reply to message #665426]

Tue, 05 September 2017 08:34

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

You know Roachcoach said the exact same thing 5 hours ago?

Report message to a moderator

Re: how to extract data from oracle table having space in column name using vba code? [message #665433 is a reply to message #665428]

Tue, 05 September 2017 09:01

Bill B
Messages: 1971
Registered: December 2004

Senior Member

And roachcoach's column name and table name is much more descriptive of the OP's horrible design.

Report message to a moderator

Previous Topic:	PLSQL Procedure to Grant Privs on Schema Objects
Next Topic:	where clause between to sysdates

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 02:02:35 CDT 2024