Advanced Search

Test PL/SQL syntax highlighting

/ Published in: PL/SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. DECLARE
  2.   number1 NUMBER(2);
  3.   number2 NUMBER(2)    := 17;
  4.   text1    VARCHAR2(12) := 'Hello world';
  5.   text2    DATE         := SYSDATE;        -- current date and time
  6. BEGIN
  7.   SELECT street_number
  8.   INTO   number1
  9.   FROM   address
  10.   WHERE  name = 'Smith';
  11. END;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.