Nested Blocks

declare x number; begin x := 80; dbms_output.put_line(‘abc’); declare y number; begin y := 90; dbms_output.put_line(‘Inner Block variable value ‘ || y); end; dbms_output.put_line(‘Outer Block variable value ‘ || x); end; Scope of variables A variable declared in the outer block is accessible in the inner block. But a variable…

Conditional Statements – IF

The selection structure tests a condition, then executes one sequence of statements instead of another, depending on the condition There are three forms of statements IF-THEN IF-THEN-ELSE IF-THEN-ELSIF Sequence of statements is executed only if the condition evaluates to TRUE If condition evaluates to FALSE or NULL, it does nothing…

Programming Basics with PL/SQL

PL/SQL features — PL/SQL is an extension of SQL It is an application development language containing procedural statements and commands along with SQL commands It bridges the gap between database technology and procedural programming languages It allows you to process data using flow control statements like iterative loops and conditional…

Oracle , PL/SQL

In recent years, database management systems (DBMS) have established themselves as the primary means of data storage for information systems ranging from large commercial transaction processing applications to PC-based desktop applications. At the heart of most of today’s information systems is a relational database management system (RDBMS). RDBMSs have been…

Expanding or Collapsing all nodes in the Solution Explorer

*** Repost from blog.24x7code.com **** I was looking for a solution in VS2003 for Expanding or Collapsing all nodes in the Solution Explorer I found this trick on falafel blog The following two macros will collapse and expand all of the items in the Solution Explorer. To install them: Open…

1 4 5 6