Your variable is only usable within BEGIN and END so if you want to use more than one you will have to do multiple BEGIN END wrappings DECLARE stupidvar varchar(20) SELECT stupid into stupidvar FROM stupiddata CC
#Setting a variable in indigo 7 full#
So the full statement would come out following: DECLARE stupidvar varchar(20) Or to select something into that variable you use INTO statement, however you need to wrap statement in BEGIN and END, also you need to make sure that only single value is returned, and don't forget semicolons. To assign a value you can set it when you declare DECLARE stupidvar varchar(20) := '12345678' Keyword declare is used to declare variable DECLARE stupidvar varchar(20)
As you see, we can still assign values to declared variables interactively: SQL> set serveroutput on size unlimitedġ1 dbms_output.put_line('top earners = '||to_char(n)) This snippet runs without prompting me to enter a value: SQL> def p_dno = 40įinally there's the anonymous PL/SQL block. When we're writing a script which calls other scripts it can be useful to DEFine the variables upfront. These are good for interactive mode: SQL> accept p_dno prompt "Please enter Department number: " default 10
The mechanism for assigning values to a VAR is with an EXEC call: SQL> var name varchar2(20)Ī VAR is particularly useful when we want to call a stored procedure which has OUT parameters or a function.Īlternatively we can use substitution variables. The first is to use VAR, to declare a bind variable. There are a several ways of declaring variables in SQL*Plus scripts.
0 kommentar(er)
