This article contains tutorial about Oracle PL/SQL Loops and Conditional Statements. Following topics are discused here IF-THEN-ELSE Statement, Case Statement, GOTO Statement, Loop Statement, FOR Loop, CURSOR FOR Loop, While Loop, Repeat Until Loop and Exit Statement
Tags: oracle plsql, oracle tutorial, plsql, plsql tutorial
In other languages, a null value is found using the = null syntax. However in PLSQL to check if a value is null, you must use the "IS NULL" syntax.
To check for equality on a null value, you must use "IS NULL".
For example,
IF Lvalue IS NULL then
.
END IF;
If Lvalue contains a null value, [...]
Tags: oracle plsql, oracle tutorial, plsql, plsql tutorial
The syntax for declaring variables is:
variable_name datatype [CONSTANT] [NOT NULL] [:= | DEFAULT initial_value]
For example:
Declaring a variable:
LDescription varchar2(40);
Declaring a constant:
LTotal constant numeric(8,1) := 8363934.1;
Declaring a variable with an initial value (not a constant):
LType varchar2(10) := ‘Example’;
Tags: oracle plsql, oracle tutorial, plsql, plsql tutorial
A literal is the same as a constant. We’ll cover three types of literals – text literals, integer literals, and number literals
Tags: oracle plsql, oracle tutorial, plsql, plsql tutorial
VI is a text editor in UNIX Environment with rich set of option and commands. This editor is used to do script programming and to view the flat files in UNIX. There are three modes available in VI editor as Input Mode, Execution Mode and Command Mode
Tags: modes of vi editor, UNIX, UNIX Commands, unix tutorial, vi editor, vi editor commands
The find command lists all of the files within a directory and its subdirectories that match a set of conditions. This command is most commonly used to find all of the files that have a certain name
Tags: find command, unix command find, UNIX Commands, UNIX Scripts
This article contains information about some more UNIX commands which are used widely in UNIX Scriptiing.Following commands are explained here chgrp,cat,split, grep, jobs, kill, ps, finger, gzip, gunzip, touch, whereis, which, head, tail, sort, ln, whoami, groups, grplist, top, fg, bg, nice and set
Tags: UNIX Commands, UNIX Kernal, Unix Process, unix script, UNIX Shell Script
This article contains reference documentation for some of the basic unix commands. Also it has short information about UNIX Kernal, UNIX Shell and UNIX Files and Processes.
Tags: UNIX Commands, UNIX Kernal, Unix Process, unix script, UNIX Shell Script
DotNet Framework is a Programming model of the .NET environment for building, deploying, and running Web-based applications, smart client applications, and XML Web services
Tags: ado.net, asp.net, clr, cls, cts, dotnet framework, gac, garbage handling, XML




