Search
Main Menu
Login
Username:

Password:

Remember me



Lost Password?

Register now!
Who's Online
23 user(s) are online (15 user(s) are browsing Jobs & News)

Members: 0
Guests: 23

more...

Blog: FYI Center for Database Administrator

FYI (For Your Information) Center for Database Administrators with large collection of FAQs, tutorials and tips for on Oracle, SQL Server, MySQL, and other database servers - dev.fyicenter.com. | URL | Feed
Update: 2018/11/28 19:00:00 (Update)

FYIcenter.com | Nov 28, 2018

What Are the Different Types of PL/SQL Code Blocks in Oracle? There are 3 types of PL/SQL code blocks: Anonymous Block - A block of codes with no name. It may contain a declaration part, an execution part, and exception handlers. Stored Program Unit - A block of codes with a name. It is similar to a... - Rank: 454; Updated: 2018-11-29 -> Source


FYIcenter.com | Nov 28, 2018

What Is an Anonymous Block in Oracle? An anonymous block is a PL/SQL code block with no name. It consists of three parts: Declaration Part - Defining local variables and local procedures. Declaration part is optional. Execution Part - Defining execution logic with executable statements. Execution pa... - Rank: 484; Updated: 2018-11-29 -> Source


FYIcenter.com | Nov 28, 2018

What Is a Named Program Unit in Oracle? A named program unit is a PL/SQL code block with an name. It consists of three parts: Declaration Part - Defining the program unit name, calling parameters, local variables and local procedures. Declaration part is required. Execution Part - Defining execution... - Rank: 464; Updated: 2018-11-29 -> Source


FYIcenter.com | Nov 28, 2018 | 1 reads

What Is a Procedure in Oracle? A procedure is a named program unit. It consists of three parts: Declaration Part - Defining the procedure name, calling parameters, local variables and local procedures. Declaration part is required. Execution Part - Defining execution logic with executable statements... - Rank: 418; Updated: 2018-11-29 -> Source


FYIcenter.com | Nov 28, 2018 | 1 reads

What Is a Function in Oracle? A function is a named program unit. It consists of three parts: Declaration Part - Defining the function name, calling parameters, return value type, local variables and local procedures. Declaration part is required. Execution Part - Defining execution logic with execu... - Rank: 481; Updated: 2018-11-29 -> Source


FYIcenter.com | Nov 16, 2018

How To Declare a Local Variable in Oracle? A local variable can be defined in the declaration part with a declaration statement, which is a variable name followed a data type identifier. Below are some examples of declaration statements: PROCEDURE proc_var_1 AS domain VARCHAR2(80); price REAL; is_fo... - Rank: 365; Updated: 2018-11-17 -> Source


FYIcenter.com | Nov 16, 2018

How Many Categories of Data Types in Oracle? PL/SQL data types are grouped into 4 categories: Scalar Data Types: A scalar data type holds a single value. Composite Data Types: A composite data type has internal components, such as the elements of an array. LOB Data Types: A LOB data type holds a lob... - Rank: 382; Updated: 2018-11-17 -> Source


FYIcenter.com | Nov 16, 2018

How Many Scalar Data Types Are Supported in PL/SQL in Oracle? PL/SQL supports many scalar data types divided into 4 groups: Numeric Types: BINARY_DOUBLE, BINARY_FLOAT, BINARY_INTEGER, DEC, DECIMAL, DOUBLE PRECISION, FLOAT, INT, INTEGER, NATURAL, NATURALN, NUMBER, NUMERIC, PLS_INTEGER, POSITIVE, POSI... - Rank: 455; Updated: 2018-11-17 -> Source


FYIcenter.com | Nov 16, 2018

How To Convert Character Types to Numeric Types in Oracle? You can convert character types to numeric types in two ways: Explicitly by using TO_NUMBER() function. Implicitly by putting character data in a numeric operation. The sample script below shows you how to convert character types to numeric ... - Rank: 415; Updated: 2018-11-17 -> Source


FYIcenter.com | Nov 16, 2018

What Are the Execution Control Statements in Oracle? PL/SQL supports three groups of execution control statements: IF Statements - Conditionally executes a block of statements. CASE Statements - Selectively executes a block of statements. LOOP Statements - Repeatedly executes a block of statements. ... - Rank: 336; Updated: 2018-11-17 -> Source




Copyright (c) FYIcenter.com