oracle - how to handle the text entered from the keyboard pl sql -


how manage text input keyboard using command prompt in pl / sql oracle. want verified if text inserted empty or insert more lines

-i use line address retrieve data keyboard

set serveroutput on

accept my_var varchar(256) prompt 'insert number:',

the thing know sql plus can prompt user parameter value.. let user using sqlplus type in text. i'm not sure if that's want meant...

you can adding &.

so

select person.name person age = &age


Popular posts from this blog