If statement - syntax, PL-SQL Programming

IF Statement

The IF statement executes a series of statement conditionally. Whether the series is executed or not depends on the value of the Boolean expression.

Syntax:

1891_if statement.png

Posted Date: 10/8/2012 7:01:26 AM | Location : United States







Related Discussions:- If statement - syntax, Assignment Help, Ask Question on If statement - syntax, Get Answer, Expert's Help, If statement - syntax Discussions

Write discussion on If statement - syntax
Your posts are moderated
Related Questions
Package Specification The package specifications contain the public declarations. The scopes of these declarations are local to your database representation and global to the

Project Description: I have two types of data sources. One that is a list in SharePoint and another that is an access desktop database. The access desktop database is fairly com

An analyst in the quality assurance office reviews the time lapse between receiving an order and shipping an order. Any orders that have not been shipped within a day of the order

Definition of FROM - SQL Recall that the operand of FROM is denoted by a commalist, each element of that commalist being a table expression optionally accompanied by a range v

Using Cursor Attributes To process the SQL data manipulation statements, the SQL engine must opens an implicit cursor named SQL. This cursor's attributes (%FOUND, %NOTFOUND, %

Count Operator in SQL Example: Counting the students who have scored more than 50 in some exam (SELECT COUNT (*) FROM (SELECT DISTINCT StudentId FROM EXAM_MARK WHE

Data Types in SQL - Timestamp TIMESTAMP for values representing points in time on a specified uniform scale. DATE is used for timestamps on a scale of one day, such as DATE '2

SQL Database: So, an SQL database is one whose symbols are organized into a collection of tables. Now, shows an SQL table as the current value of an SQL variable, ENROLMENT, b

Many of the reports generated from the system calculate the total dollars in a shopper''s purchases. Follow these steps to create a function named TOT_PURCH_SF that accepts a shopp

Project Description: I want to write some SQL statements. The things I need are between pages 5-7. The only problem is that i want it till tomorrow. Skills required is SQL