Dev

Topic	Reference	Document
PL/SQL Anonymous Block	how to execute an anonymous block in SQL*Plus and Oracle SQL Developer tools.
Loop
PL/SQL LOOP	PL/SQL LOOP statement is a control structure that repeatedly executes a block of code until a specific condition is met or until you manually exit the loop.
PL/SQL FOR LOOP	PL/SQL FOR LOOP executes a sequence of statements a specified number of times.
PL/SQL WHILE Loop	PL/SQL WHILE loop is a control structure that repeatedly executes a code block as long as a specific condition remains true.
PL/SQL CONTINUE statement	The CONTINUE statement allows you to exit the current loop iteration and immediately continue on to the next iteration of that loop.
PL/SQL SELECT INTO	PL/SQL SELECT INTO statement is the simplest and fastest way to fetch a single row from a table into variables.
Cursors
PL/SQL Cursor	A cursor is a pointer that points to a result of a query. PL/SQL has two types of cursors: implicit cursors and explicit cursors.
Oracle CURSOR FOR UPDATE	If you want to lock a set of rows before you can update them in your program. Oracle provides the FOR UPDATE clause of the SELECT statement in an updatable cursor to perform this kind of locking mechanism.
PL/SQL Procedure	A PL/SQL procedure is a reusable unit that encapsulates the specific business logic of the application. PL/SQL procedure is a named block stored as a schema object in the Oracle Database.
Conditional control
IF Statement	IF statement allows you to either execute or skip a sequence of statements, depending on a condition. The IF statement has three forms: 1. IF THEN 2. IF THEN ELSE 3. IF THEN ELSIF
CASE Statement	The CASE statement chooses one sequence of statements to execute out of many possible sequences. The CASE statement has two types: simple CASE statement and searched CASE statement. Both types of CASE statements support an optional ELSE clause.
GOTO Statement	The GOTO statement allows you to transfer control to a labeled block or statement for example. GOTO label_name; The label_name is the name of a label that identifies the target statement. In the program, you surround the label name with double enclosing angle brackets as shown below: <<label_name>>;
NULL Statement	The NULL statement is a NULL keyword followed by a semicolon ( ;). The NULL statement does nothing except that it passes control to the next statement. The NULL statement is useful to: 1. Improve code readability 2. Provide a target for a GOTO statement 3. Create placeholders for subprograms

Will discuss about different OS and their how to

Windows command	Details about the	Link to
Microsoft O.S.	CLI	Windows commands in nutshell
Unix	N/W stats	netstat
Unix	Performance	vmstat and iostat
Unix (Solaris and AIX)	System details	prtconf