Home » SQL & PL/SQL » SQL & PL/SQL » Re: XML issue (split from hijacked thread http://www.orafaq.com/forum/t/189540/)
Re: XML issue (split from hijacked thread http://www.orafaq.com/forum/t/189540/) [message #605586] Sat, 11 January 2014 04:49 Go to next message
KimberlyDeborah
Messages: 15
Registered: December 2013
Location: United States
Junior Member
If we want to retrieve more than one column, we list them, separated by a comma cant be do it normally???

[Updated on: Sat, 11 January 2014 11:52] by Moderator

Report message to a moderator

Re: XML issue [message #605593 is a reply to message #605586] Sat, 11 January 2014 11:45 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
Senior Member
KimberlyDeborah wrote on Sat, 11 January 2014 02:49
If we want to retrieve more than one column, we list them, separated by a comma cant be do it normally???


KimberlyDeborah,

I will split this from the thread http://www.orafaq.com/forum/t/189540/ about "XML issue" in the "JDeveloper, Java & XML" sub-forum that you responded to and move it to the SQL and PL/SQL sub-forum. Your question is unclear and does not seem to be related to the thread that you replied to. Please post new questions by creating a new topic, not replying to another thread. Also, please try to make your question as clear as possible, providing an example of what you want. If English is not your native language, then please post in whatever language is more comfortable for you. We have separate sub-forums for various languages at the bottom of the main forum page. If you are referring to select multiple columns from a table like so:

select column1, column2, column3 from table_name;

then, this is how it is done. What do you mean by "normally"? What other way are you expecting to be able to do this? You can use:

select * from table_name;

to select all columns.

Barbara

[Updated on: Sat, 11 January 2014 11:51]

Report message to a moderator

Re: XML issue [message #605666 is a reply to message #605593] Mon, 13 January 2014 04:45 Go to previous message
KimberlyDeborah
Messages: 15
Registered: December 2013
Location: United States
Junior Member
Ok thanks Barbara!!!
Previous Topic: correct week number
Next Topic: Can someone help me with this
Goto Forum:
  


Current Time: Tue Apr 23 16:10:17 CDT 2024