---
description: In this Oracle PL/SQL exercise, we will create a sample Hello World program. We will use dbms_output.put_line() to print Hello World.
title: PL/SQL First Program: Hello World Example
image: https://www.guru99.com/images/PL-SQL/110215_0652_PLSQLFirstP1.png
---

[Skip to content](#main) 

In this tutorial, we will introduce SQL\* Plus and learn how to connect it to the database.

After connection, we are also going to see how to write our first program “Hello World” in PL/SQL.

## What is SQL\* Plus?

SQL\* Plus is an interactive and batch query tool that is installed with every Oracle installation. It can be found at Start > Programs > Oracle-OraHomeName > Application Development > SQL Plus. Alternatively, you can also download it from the Oracle Technology Network (OTN)

It has a command line user interface, Windows GUI, and web-based user interface.

It allows the user to connect to the database and execute PL/SQL commands.

## Connecting to Database

In this section, we are going to learn how to connect to SQL\* Plus in Windows GUI. When we open SQL\* Plus, it will prompt for the connection details as shown below.

### Connection Details

* Username: <user name of the database>
* Password: <password for that user>
* Host String: <host details along with the port number and SID of the database>

[](https://www.guru99.com/images/PL-SQL/110215%5F0652%5FPLSQLFirstP1.png)

* After the successful connection, the[ SQL ](https://www.guru99.com/sql.html)plus will appear as shown below

[](https://www.guru99.com/images/PL-SQL/110215%5F0652%5FPLSQLFirstP2.png)

* We need to execute “set serveroutput on” if we need to see the output of the code.
* Now we are ready to work with the SQL\* Plus tool.

### RELATED ARTICLES

* [ Oracle PL/SQL Insert, Update, Delete & Select Into \[Example\] ](https://www.guru99.com/sql-pl-sql.html "Oracle PL/SQL Insert, Update, Delete & Select Into [Example]")
* [ SQL vs PL-SQL vs T-SQL – Difference Between Them ](https://www.guru99.com/sql-vs-pl-sql.html "SQL vs PL-SQL vs T-SQL – Difference Between Them")
* [ Oracle PL/SQL Records Type with Examples ](https://www.guru99.com/pl-sql-record-type.html "Oracle PL/SQL Records Type with Examples")
* [ 65 PL/SQL Interview Questions and Answers (2026) ](https://www.guru99.com/pl-sql-interview-questions-answers.html "65 PL/SQL Interview Questions and Answers (2026)")

## How to write a simple program using PL/SQL

In this section, we are going to write a simple program for printing “Hello World” using “[Anonymous block](https://www.guru99.com/blocks-pl-sql.html)“.

[](https://www.guru99.com/images/PL-SQL/110215%5F0652%5FPLSQLFirstP3.png)

BEGIN
dbms_output.put_line (‘Hello World..');
END;
/

 **Output:** 

Hello World...

**Code Explanation:**

* **Code line 2**: Prints the message “Hello World. . .”
* The below screenshot explains how to enter the code in SQL\* Plus.

**Note:** A block should be always followed by ‘/’ which sends the information to the compiler about the end of the block. Till the compiler encounters ‘/’, it will not consider the block is completed, and it will not execute it.

[](https://www.guru99.com/images/PL-SQL/110215%5F0652%5FPLSQLFirstP4.png)

## Declaring and usage of variables in the program

Here we are going to print the “Hello World” using the variables.

[](https://www.guru99.com/images/PL-SQL/110215%5F0652%5FPLSQLFirstP5.png)

DECLARE
text VARCHAR2(25);
BEGIN
text:= ‘Hello World’;
dbms_output.put_line (text);
END;
/

**Output:**

Hello World

**Code Explanation:**

* **Code line 2**: Declaring a variable “text” of a VARCHAR2 type with size 25
* **Code line 4**: Assigning the value “Hello World” to the variable “text”.
* **Code line 5**: Printing the value of the variable “text”.

## Comments in PL/SQL

Commenting code simply instructs the compiler to ignore that particular code from executing.

Comment can be used in the program to increase the readability of the program. In PL/SQL codes can be commented in two ways.

* Using ‘–‘ in the beginning of the line to comment that particular line.
* Using ‘/\*…….\*/’ we can use multiple lines. The symbol ‘/\*’ marks the starting of the comment and the symbol ‘\*/’ marks the end of the comment. The code between these two symbols will be treated as comments by the compiler.

**Example**: In this example, we are going to print ‘Hello World’ and we are also going to see how the commented lines behave in the code

[](https://www.guru99.com/images/PL-SQL/110215%5F0652%5FPLSQLFirstP6.png)

BEGIN
--single line comment
dbms output.put line (' Hello World ’);
/*Multi line commenting begins
Multi line commenting ends */
END;
/

**Output:**

Hello World

**Code Explanation:** 

* **Code line 2**: Single line comment and compiler ignored this line from execution.
* **Code line 3**: Printing the value “Hello World.”
* **Code line 4**: Multiline commenting starts with ‘/\*’
* **Code line 5**: Multiline commenting ends with ‘\*/’

## Summary

In this tutorial, you have learned about SQL\* Plus and Connection establishment to SQL\* Plus. You have also learned about how to write the simple program and how to use a variable in them. In our upcoming chapters, we will learn more about different functionalities that can be implemented in the [PL SQL program](https://www.guru99.com/introduction-pl-sql.html).

#### Summarize this post with:

ChatGPT Perplexity Grok Google AI 

**Stay Updated on AI** **Get Weekly AI Skills, Trends, Actionable Advice.** 

##### Sign up for the newsletter

Subscribe for Free 

You have successfully subscribed.  
 Please check your inbox.

![AI-Newsletter]()Chosen by over **350,000+** professionals

[Scroll to top ](#wrapper)Scroll to top 

× 

Toggle Menu Close 

Search for: 

Search 

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://www.guru99.com/#organization","name":"Guru99","sameAs":["https://www.facebook.com/Guru99Official","https://twitter.com/guru99com"],"logo":{"@type":"ImageObject","@id":"https://www.guru99.com/#logo","url":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","contentUrl":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","caption":"Guru99","inLanguage":"en-US"}},{"@type":"WebSite","@id":"https://www.guru99.com/#website","url":"https://www.guru99.com","name":"Guru99","publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https://www.guru99.com/images/pl-sql-first-program-helloworld.png","url":"https://www.guru99.com/images/pl-sql-first-program-helloworld.png","width":"294","height":"137","inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https://www.guru99.com/pl-sql-first-program-helloworld.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":"1","item":{"@id":"https://www.guru99.com","name":"Home"}},{"@type":"ListItem","position":"2","item":{"@id":"https://www.guru99.com/pl-sql","name":"PL-SQL"}},{"@type":"ListItem","position":"3","item":{"@id":"https://www.guru99.com/pl-sql-first-program-helloworld.html","name":"PL/SQL First Program: Hello World Example"}}]},{"@type":"WebPage","@id":"https://www.guru99.com/pl-sql-first-program-helloworld.html#webpage","url":"https://www.guru99.com/pl-sql-first-program-helloworld.html","name":"PL/SQL First Program: Hello World Example","dateModified":"2024-11-21T19:58:18+05:30","isPartOf":{"@id":"https://www.guru99.com/#website"},"primaryImageOfPage":{"@id":"https://www.guru99.com/images/pl-sql-first-program-helloworld.png"},"inLanguage":"en-US","breadcrumb":{"@id":"https://www.guru99.com/pl-sql-first-program-helloworld.html#breadcrumb"}},{"@type":"Person","@id":"https://www.guru99.com/author/fiona","name":"Fiona Brown","description":"I'm Fiona brown, a Full Stack Developer with over a decade of experience, sharing practical guides on robust and scalable application development.","url":"https://www.guru99.com/author/fiona","image":{"@type":"ImageObject","@id":"https://www.guru99.com/images/fiona-brown-author.png","url":"https://www.guru99.com/images/fiona-brown-author.png","caption":"Fiona Brown","inLanguage":"en-US"},"worksFor":{"@id":"https://www.guru99.com/#organization"}},{"@type":"Article","headline":"PL/SQL First Program: Hello World Example","keywords":"pl-sql","dateModified":"2024-11-21T19:58:18+05:30","articleSection":"PL-SQL","author":{"@id":"https://www.guru99.com/author/fiona","name":"Fiona Brown"},"publisher":{"@id":"https://www.guru99.com/#organization"},"description":"In this Oracle PL/SQL exercise, we will create a sample Hello World program. We will use dbms_output.put_line() to print Hello World.","name":"PL/SQL First Program: Hello World Example","@id":"https://www.guru99.com/pl-sql-first-program-helloworld.html#richSnippet","isPartOf":{"@id":"https://www.guru99.com/pl-sql-first-program-helloworld.html#webpage"},"image":{"@id":"https://www.guru99.com/images/pl-sql-first-program-helloworld.png"},"inLanguage":"en-US","mainEntityOfPage":{"@id":"https://www.guru99.com/pl-sql-first-program-helloworld.html#webpage"}}]}
```