SQL*Plus (MOSC)

MOSC Banner

input variable empty

edited Feb 25, 2016 4:02AM in SQL*Plus (MOSC) 3 commentsAnswered

There's this one little issue I've never been able to find an answer to, so I guess it's time to ask you guys.

Given there is an SQL script, which should accept one parameter. No problem, I'm catching the value with

&1

and all works!

But ... I want the script also to work without any parameter specified. Why exactly that is, I'm not detailing since there may be totally other solutions for that problem.

So, when I launch the script without parameters, it says :

Enter value for 1:

The problem I have is that I would prefer to state something else than "1", by means of using stuff like:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center