How to get input from user at runtime

Question

I want to take runtime input from user in Oracle 10g PL SQL blocks  i e  interactive communication with user   Is it possible  declare x number  begin x  amp x  end  this code gives error as   amp  can t be used in oracle 10g

User · Answer

DECLARE c id customers id type     amp c id  c name customers name type  c add customers address type  c sal customers salary type  a integer     amp a       Here c id customers id type     amp c id  statement inputs the c id with type already defined in the table and statement a integer     amp a just input integer in variable a

User · Answer

SQL gt  DECLARE   2     a integer    3     b integer    4  BEGIN   5     a   amp a    6     b   amp b    7     dbms output put line  The a value is        a     8     dbms output put line  The b value is        b     9  END   10

User · Answer

you can try this too And it will work   DECLARE   a NUMBER    b NUMBER  BEGIN   a     a  --this will take input from user   b     b    DBMS OUTPUT PUT LINE  a       a     DBMS OUTPUT PUT LINE  b       b   END

User · Answer

To read the user input and store it in a variable  for later use  you can use SQL Plus command ACCEPT    Accept  lt your variable gt   lt variable type if needed  number char date  gt  prompt  message    example  accept x number prompt  Please enter something      And then you can use the x variable in a PL SQL block as follows    declare    a number  begin   a     amp x  end      Working with a string example   accept x char prompt  Please enter something     declare    a varchar2 10   begin   a      amp 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

User · Answer

TRY THIS     declare    a number  begin   a     a  dbms output put line  Inputed Number is  gt  gt      a   end       OR  declare    a number  begin   a     x  dbms output put line  Inputed Number is  gt  gt      a   end

User · Answer

declare a number  b number  begin a    a  b    b  if a gt b then dbms output put line  Large number is    a   else dbms output put line  Large number is    b   end if  end

User · Answer

its very simple  just write     first create table named test      create table test  name varchar2 10  age number 5        when you run the above code a table will be created        now we have to insert a name  amp  an age    Make sure age will be inserted via opening a form that seeks our help to enter the value in it  insert into test values  Deepak    age       now run the above code and you ll get   1 row inserted  output      now run the select query to see the output  select   from test      that s all   Now i think no one has any queries left over accepting a user data

User · Answer

That is because you have used following line to assign the value which is wrong    x  amp x    In PL SQL assignment is done using following       So your code should be like this       declare     x number      begin     x   amp x  -- Below line will output the number you received as an input     dbms output put line x       end

[oracle] How to get input from user at runtime

Examples related to oracle

Examples related to oracle10g

Examples related to user-input