Breaking News: Grepper is joining You.com. Read the official announcement!

user input in oracle pl/sql

Dark Dunlin answered on December 7, 2023 Popularity 1/10 Helpfulness 3/10

answer user input in oracle pl/sql

user input in oracle pl/sql

Comment

accept x char prompt 'Please enter something: '

declare 
  a varchar2(10);
begin
  a := '&x';   -- for a substitution variable of char data type 
end;           -- to be treated as a character string it needs
/              -- to be enclosed with single quotation marks

Popularity 1/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: oracle sql user-input

Link to this answer
Share Copy Link