KEMBAR78
PDF PLSQL 2 7 Practice Compress | PDF
Scribd
Upload
152 views2 pages

PDF PLSQL 2 7 Practice Compress

The document provides an example of a PL/SQL block that demonstrates bad programming practices. It asks the user to modify the block to demonstrate good programming practices such as explicit data type conversions, meaningful variable names, use of the %TYPE attribute, consistent uppercase and lowercase conventions, comments, and clear indentation. The good practices block should select the country name where the ID equals 1246, explicitly convert the string "1234" to a number, multiply that number by 2 and display the country name.

Uploaded by

Fernanda Coronado
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
152 views2 pages

PDF PLSQL 2 7 Practice Compress

The document provides an example of a PL/SQL block that demonstrates bad programming practices. It asks the user to modify the block to demonstrate good programming practices such as explicit data type conversions, meaningful variable names, use of the %TYPE attribute, consistent uppercase and lowercase conventions, comments, and clear indentation. The good practices block should select the country name where the ID equals 1246, explicitly convert the string "1234" to a number, multiply that number by 2 and display the country name.

Uploaded by

Fernanda Coronado
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

 

www.oracle.com/academy  

Database Programming with PL/SQL


2-7: Good Programming Practices Practice
 Activities
Vocabulary
No new vocabulary for this lesson.

Try It / Solve It
1. Enter and run the following PL/SQL block. It will execute correctly if you have entered it
correctly, but it contains some examples of bad programming practices.

 A. Modify the block to use goo


good
d progra
programming
mming practices,
practices, and re-run the block.
block.

B. Your modified block should c contain


ontain examples of the following good programming
practices: explicit data type conversions, meaningful and consistent variable names,
use of %TYPE, upper and lowercase conventions, single and multi-line comments, and
clear indentation.

DECLARE
myvar1 VARCHAR2(20);
myvar2 number(4);
BEGIN
SELECT country_name INTO myvar1
FROM countries WHERE country_id = 421;
myvar2 := '1234';
MYVAR2 := myvar2 * 2;
DBMS_OUTPUT.PUT_LINE(myvar1);
End;

DECLARE
myvar1 VARCHAR2(20);
myvar2 number(4);
BEGIN
SELECT country_name INTO myvar1
FROM wf_countries WHERE country_id =
1246;
myvar2 := 1234;
 

  MYVAR2 := myvar2 * 2;
DBMS_OUTPUT.PUT_LINE(myvar1);
End;

You might also like