Do You Make These Simple Mistakes In Execution Of Pl/sql?

Before executing one needs to ensure that the flag Set serveroutput is ON (Set serveroutput ON;) to get the output on the console.

Introduction

PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early ’90s to enhance the capabilities of SQL. PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java. This tutorial will give you a great understanding of PL/SQL to proceed with the Oracle database and other advanced RDBMS concepts.

Execution steps for pl/sql:

1. Create and open a file with vi editor

SQL>!vi filename.sql

The default editor that comes with the UNIX operating system is called vi (visual editor). Using vi editor, we can edit an existing file or create a new file from scratch.

2. Write the code there

3. Press ‘Esc’ then type ‘:wq’ to save the file

4. Run and execute the pl/sql program by typing the query SQL>@filename.sql

OR simple execution step for pl/sql:

Press / at the end of .sql file and Run SQL>@filename.sql

Click to read more

Also read:

The One from the Stars by Keshav Aneel

The Miracle Morning Guaranteed to Transform Your Life (Before 8AM)

The Little Prince Book Summary by Antoine de Saint-Exupery

The Courage to Be Disliked Book Summary

Who Will Cry When You Die By Robin Sharma Summary

Steal Like an Artist by Austin kleon Summary

Looking for Alaska Book by John Green | Summary

The Kite Runner By Khaled Hosseini Summary

When Breath becomes Air by Paul kalanithi Summary

IKIGAI THE JAPANESE SECRET TO A LONG AND HAPPY LIFE SUMMARY

The Rudest Book Ever by Shwetabh Gangwar | Summary

Good Will Hunting Story Explained

“The 5AM CLUB” book that can change one’s life by Robin Sharma

The Alchemist summary by Paulo Coelho

The Dairy of a Young Girl by Anne Frank full summary