How to run PL/SQL Code With Command Line?

-

How to run PL/SQL Code With Run SQL Command Line?


So What is PL/SQL?

  • PL/SQL is Oracle Corporation's procedural extension for SQL and the Oracle relational database.
  • PL/SQL is available in Oracle Database, Times Ten in-memory database, and IBM DB 2. 
  • In Simple Word
    • PL/SQL means instructing the compiler 'what to do' through SQL and 'how to do' through its procedural way. 

Follow these steps to run the code of PL/SQL with SQL command Line.

Step 1:

Type this in command prompt:

connect sys as sysdba

Enter password: wb

Connected.


Step 2:

We need to type and execute "set serveroutput on" if  to see the output of the program.


Step 3:

Type this Sample Code:

set serveroutput on

BEGIN

dbms_output.put_line ('Hello World..');

END;

/


Step 4:

You will get output:

Hello World




Thank-you.


Also Read :



Comments

Post a Comment

Popular posts from this blog

How to set image in carousel using flask?

-
Image
How to set image in carousel using flask? Step 1: Create one folder on the desktop called my Flask . Step 2: Create Two folder called static and templates  in the myFlask folder. Create one file called main.py   in the myFlask folder. Step 3: Add the code in the main.py file.      from flask import Flask,render_template      app = Flask(__name__)      @app.route('/')      def hello_world():          return render_template("index.html")      app.run(debug=True) Step 4: Create image folder in the static folder. Add one image  in the image folder. [arya.png]. Step 5: Create index.html in the templates folder and add the below code in that folder. <html> . . . <div id= "carouselExampleSlidesOnly" class= "carousel slide" data-ride= "carousel" > <div class= "carousel-inner" > <div class= "carousel-item active" > <img src= "{{url_for('st...
Read more

Invalid syntax , perhaps you forgot a comma? Error in Python

-
Image
Invalid syntax , perhaps you forgot a comma? Error n Python Problem : Invalid syntax , perhaps you forgot a comma? Error in Python Solution 1: May be you  have missed the assignment operator."="  Example: Solution 2: May be you have missed the comma between value or variable","  Example: Still Problem is not solved? For any queries, you can contact us: 📬 Contact Me 📞 Phone:  +918431334381 💬 WhatsApp:  +918431334381 📧 Email:   aryadrj@gmail.com 📝 Form:   Click here to fill out the form
Read more