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 ]

 

[5ingh]

Yep I'm using sqlPlus.

Do you mean something like this:

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

Thanks

 

[5ingh]

cheers