Skip to content

Instantly share code, notes, and snippets.

@charlieMonroe

charlieMonroe/SnippetFile

Created June 7, 2011 13:50
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save charlieMonroe/1012293 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save charlieMonroe/1012293 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SnippetFile
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