What are the function/s that are not available in procedural statements?

v_emp_name:= v_first_name|' '|v_last_name;

Is this how you concatenate variables?

TRUNC is a valid date function in PL/SQL

v_new_date := ADD_MONTHS(SYSDATE,v_num_months);

This is how you add months to a current date.

It is where the PL/SQL attempts to convert data types

dynamically if they are mixed in a statement.

It converts values from one data type to

another by using built-in functions.

It is strongly recommended that you AVOID allowing SQL or

PL/SQL to perform explicit conversions on your behalf.

The operations within an expression are performed in a

particular order depending on their precedence(priority).

What is the highest priority in the default order of operations?

What is the lowest priority in the default order of operations?

The basic units (procedures, functions, and anonymous blocks) are logical blocks, which can contain any number of nested sub-blocks.

These are blocks of code placed within other

blocks of code.

It is where the block or blocks in which the

variable is accessible, that is, where it can be used.

If PL/SQL does not find the variable declared locally, it looks

downward into the child blocks.

You can declare variables with the same name in two different blocks when one block is nested within the other block.

It is a label given to a block.

What if the same name is used for two variables, one in each of the blocks?

Use implicit data type conversions because explicit data

type conversions can be slower and the rules can change

in later software releases.

What are the good programming practices demonstrated and/or discussed:

Identifiers, tables, and columns should be written in ____ based on the guidelines.

The naming of identifiers should be:

Programming guidelines include:

PL/SQL keyword are written in ______ based on the guidelines.

Data types are written in _______ based on the guidelines.