Advanced Search

Return to Snippet

Revision: 8376
at September 17, 2008 15:38 by jaytee
Initial Code 
DECLARE
  number1 NUMBER(2);
  number2 NUMBER(2)    := 17;
  text1    VARCHAR2(12) := 'Hello world';
  text2    DATE         := SYSDATE;        -- current date and time
BEGIN
  SELECT street_number
  INTO   number1
  FROM   address
  WHERE  name = 'Smith';
END;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Test PL/SQL syntax highlighting

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
PL/SQL