How to take user input in livesql oracle com in PLSQL

0 votes

How to take user input in Oracle 18c in online Oracle Database (livesql.oracle.com) in PLSQL in Runtime.

Feb 7 in Database by Neha
• 8,560 points
954 views

1 answer to this question.

0 votes

To create a procedure with a parameter and pass its value that way. 

For example,

create or replace procedure p_disp(par_param in varchar2) is
begin
  dbms_output.put_line(par_param);
end;
/

begin
  p_disp('lf');
end;
/

If you meant to use that parameter in SQL, such as

select * From v$session where sid = :sid;

OR

select * From v$session where sid = &sid;

none of these works; you'd get ORA-01008: not all variables bound error.

answered Feb 7 by Vaani
• 7,020 points

Related Questions In Database

0 votes
1 answer

How to display the queries executed by a particular user in MySQL?

From the version 5.1.7 onward, MySQL allows ...READ MORE

answered Mar 7, 2019 in Database by Mishti
• 480 points
1,576 views
0 votes
1 answer

How to do a batch insert in MySQL

You can try out the following query: INSERT ...READ MORE

answered Sep 10, 2018 in Database by Sahiti
• 6,380 points
1,664 views
0 votes
1 answer

How to cache data in a MVC application?

Reference the System.Web dll in your model ...READ MORE

answered Oct 25, 2018 in Database by Frankie
• 9,830 points
950 views
0 votes
1 answer

How to install MySQL in windows?

You can download the all in one ...READ MORE

answered Feb 28, 2019 in Database by Priyaj
• 58,080 points
383 views
0 votes
0 answers

how to take user input in livesql.oracle.com in PLSQL

How to take user input in Oracle ...READ MORE

Jun 8 in Others by polo
• 1,500 points
35 views
0 votes
1 answer

How can i copy tables from one database to other on AWS?

You can use AWS Data pipeline to ...READ MORE

answered Jul 5, 2018 in AWS by Priyaj
• 58,080 points
1,674 views
0 votes
1 answer

How to increase Swap Memory in CentOS 7?

Follow the below steps and procedures: Prerequisites Must have ...READ MORE

answered Oct 5, 2018 in Linux Administration by Frankie
• 9,830 points
9,500 views
0 votes
1 answer
0 votes
1 answer

How to delete duplicate rows in SQL Server?

CTEs and ROW_NUMBER can be combined together which will ...READ MORE

answered Feb 10 in Database by Vaani
• 7,020 points
37 views
0 votes
1 answer

How to calculate age (in years) based on Date of Birth and getDate()

Following can be a solution to your ...READ MORE

answered Feb 23 in Database by Vaani
• 7,020 points
64 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP