Skip to content

Instantly share code, notes, and snippets.

@charlieMonroe
Created June 7, 2011 13:50
Show Gist options
  • Select an option

  • Save charlieMonroe/1012293 to your computer and use it in GitHub Desktop.

Select an option

Save charlieMonroe/1012293 to your computer and use it in GitHub Desktop.
DECLARE
number1 NUMBER(2);
number2 number1%TYPE := 17; -- value default
text1 VARCHAR2(12) := 'Hello world';
text2 DATE := SYSDATE; -- current date and time
BEGIN
SELECT street_number
INTO number1
FROM address
WHERE name = 'INU';
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment