MOCKSTACKS
EN
Questions And Answers

More Tutorials









Oracle Hello World


The following simple procedure displays the text "Hello World" in a client that supports DBMS_OUTPUT.

CREATE OR REPLACE PROCEDURE helloworld
AS
BEGIN
 DBMS_OUTPUT.put_line('Hello World!');
END;
/

You need to execute this at the SQL prompt to create the procedure in the database, or you can run the query below to get the same result:

SELECT 'Hello World!' FROM dual;

In/Out Parameters


PL/SQL uses IN, OUT, IN OUT keywords to define what can happen to a passed parameter.

IN specifies that the parameter is read only and the value cannot be changed by the procedure.

OUT specifies the parameter is write only and a procedure can assign a value to it, but not reference the value.

IN OUT specifies the parameter is available for reference and modification.

PROCEDURE procedureName(x IN INT, strVar IN VARCHAR2, ans OUT VARCHAR2)
...
...
END procedureName;
procedureName(firstvar, secondvar, thirdvar);

The variables passed in the above example need to be typed as they are defined in the procedure parameter section.

Conclusion

In this page (written and validated by ) you learned about Oracle Hello World . What's Next? If you are interested in completing Oracle tutorial, your next topic will be learning about: Oracle Data Dictionary.



Incorrect info or code snippet? We take very seriously the accuracy of the information provided on our website. We also make sure to test all snippets and examples provided for each section. If you find any incorrect information, please send us an email about the issue: mockstacks@gmail.com.


Share On:


Mockstacks was launched to help beginners learn programming languages; the site is optimized with no Ads as, Ads might slow down the performance. We also don't track any personal information; we also don't collect any kind of data unless the user provided us a corrected information. Almost all examples have been tested. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. By using Mockstacks.com, you agree to have read and accepted our terms of use, cookies and privacy policy.