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, 2022 in Database by Neha
• 8,940 points
2,381 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, 2022 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
2,408 views
0 votes
1 answer

How to display databases in Oracle 11g using SQL*Plus

A MySQL "database" can be compared to ...READ MORE

answered Sep 12, 2022 in Database by narikkadan
• 52,400 points
648 views
0 votes
1 answer

How to find top three highest salary in emp table in oracle?

Use this: SELECT *FROM ...READ MORE

answered Sep 18, 2022 in Database by narikkadan
• 52,400 points
604 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,762 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, 2022 in Others by polo
• 1,480 points
298 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,100 points
2,641 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
12,231 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, 2022 in Database by Vaani
• 7,020 points
238 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, 2022 in Database by Vaani
• 7,020 points
651 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP