SQL*Plus Input: How do you get input from user into varchar2 variable?

Question

I got a table with strings from varchar2(50) and I want to find all tuples with a name which equals to a given name.

My input part of code is

name:=&k;

(k is not declared)

but when I give a string like "Jhon" it actually uses it as value and not a string (Jhon and not 'Jhon')

so my question is how to perform a string(varchar2) input?

That is not a PL/SQL "input", it's a feature of SQL*Plus (PL/SQL can not interact with the user) — user330315
– user330315, Commented Jan 9, 2014 at 15:50

Alex Poole · Accepted Answer · 2014-01-09 16:05:00Z

5

Assuming you're running an anonymous PL/SQL block from SQL*Plus (or SQL Developer), you just need to enclose the substitution variable in quotes:

name := '&k';

For example:

set verify off
set serveroutput on

declare
  name varchar2(10);
begin
  name := '&k';
  dbms_output.put_line('Name is: ' || name);
end;
/

anonymous block completed
Name is: jhon

answered Jan 9, 2014 at 16:05

Alex Poole

192k11 gold badges198 silver badges349 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL*Plus Input: How do you get input from user into varchar2 variable?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related