Oracle: Parameter box

[5ingh]

Does anyone know the syntax for a parameter box?

I'm trying to run a query that'll ask me for the values then search them in a table.

I've done a search and it looks like I have to use a colon( : ) but thats all I'm getting

In access you use [ enter value ]

 

[Haircut]

You running it from SQL*Plus?

You can use & for replacement (i.e. if you wanted to input a string you would need to do it enclosed in the quotes) or : for bind variables.

 

[5ingh]

Yep I'm using sqlPlus.

Do you mean something like this:

"&Please enter a name you want to search&"

Thanks

 

[Haircut]

As in

SELECT *
FROM tablename
WHERE columnname = &value

 

[5ingh]

cheers