OraFAQ Forum: Client Tools » using a prompt as a column

Home » Other » Client Tools » using a prompt as a column (toad)

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

using a prompt as a column [message #648471]

Tue, 23 February 2016 14:23

yu_yu
Messages: 3
Registered: February 2016

Junior Member

a simple question, how do I add a prompt in a select statemen.

for example, I want to build a query like select a1, a2,:prompt as user_name from table1 where a1 =condition;

here I need the capability of this prompting in the select statement. when I ran like this, I got a toad error: invalid host/bind variable name.

Report message to a moderator

Re: using a prompt as a column [message #648472 is a reply to message #648471]

Tue, 23 February 2016 14:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this orum.

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Why not just static SELECT as needed?

Report message to a moderator

Re: using a prompt as a column [message #648473 is a reply to message #648471]

Tue, 23 February 2016 14:36

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is your goal in the end?

Report message to a moderator

Re: using a prompt as a column [message #648474 is a reply to message #648473]

Tue, 23 February 2016 14:40

yu_yu
Messages: 3
Registered: February 2016

Junior Member

This is purely an information field, not used for any other statement later on. Whoever run the query will enter their name. the results will be dumped to csv file. Instead of doing extra step, it's convenient to have this in the query.

Report message to a moderator