Plsql variables - Revision history

Jfreier at 20:16, 2 July 2013

2013-07-02T20:16:10Z

2013-04-19T17:28:41Z

‎Collections

2013-04-19T17:09:33Z

‎Collections

2013-04-19T17:08:53Z

‎Collections

2013-04-19T17:06:11Z

‎Collections

2013-04-19T17:06:04Z

2012-12-17T18:59:31Z

2012-12-17T18:58:01Z

Created page with ' DECLARE attrId number; BEGIN attId:= seq_attr.nextval; dbms_output.put_line (attId); END;'

New page

DECLARE
attrId number;
BEGIN
attId:= seq_attr.nextval;
dbms_output.put_line (attId);
END;

← Older revision		Revision as of 20:16, 2 July 2013
Line 35:		Line 35:

	END LOOP;		END LOOP;
		+
		+	END;
		+
		+	== SELECT INTO ==
		+	You can set a variable from a query by using INTO.
		+
		+	DECLARE
		+
		+	v_count NUMBER;
		+	v_total NUMBER;
		+
		+	BEGIN
		+
		+	select count(id) INTO v_count FROM user;

	END;		END;

← Older revision		Revision as of 17:09, 19 April 2013
Line 17:		Line 17:

	myList.FIRST = The first option in the list, example 'option1'		myList.FIRST = The first option in the list, example 'option1'
		+
	myList.LAST = The last option in the list, example 'option3'		myList.LAST = The last option in the list, example 'option3'
		+
		+	x = The index in the array.

@@ Line 14: / Line 14: @@
 == Collections ==
   DECLARE
   TYPE MyListType IS TABLE OF VARCHAR(21);
-  myList MyListType := MyListType('option1', 'option2', 'option2');
+  myList MyListType := MyListType('option1', 'option2', 'option3');
   BEGIN
-    FOR x IN codes.FIRST .. codes.LAST
+    FOR x IN myList.FIRST .. myList.LAST
     LOOP
-        dbms_output.put_line('COURSE:' || codes(x));
+        dbms_output.put_line('MyList:' || myList(x));
     END LOOP;
   END;

@@ Line 24: / Line 24: @@
     FOR x IN codes.FIRST .. codes.LAST
     LOOP
-−
         dbms_output.put_line('COURSE:' || codes(x));

@@ Line 9: / Line 9: @@
       attId:= seq_attr.nextval;
       dbms_output.put_line (attId);
   END;

← Older revision		Revision as of 18:59, 17 December 2012
Line 1:		Line 1:
		+	When declaring variables you must also specify the block where the variables are going to be used.
		+
		+	* attrId = Variable name
		+	* ':=' = Sets the variable to a value
		+
	DECLARE		DECLARE
	attrId number;		attrId number;