Messages

1

PSOUG / ORA-06550 PLS-00103

« on: February 18, 2010, 10:24:37 am »

DECLARE
   wages      NUMBER;

 
Error at line 1
ORA-06550: line 2, column 26:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
   begin function package pragma procedure subtype type use
   <an identifier> <a double-quoted delimited-identifier> form
   current cursor

 
Can someone explain why I get this error?
 
Thanks

2

PSOUG / Re: Date

« on: January 27, 2010, 08:11:34 am »

I am new to this place as well, but recenly was working with dates. So here is my solution.

You coud add extra condition for WHERE. Like this?

AND c.END_DATE is between March 2009 and July 2009


Example use of between:
SELECT *
FROM orders
WHERE order_date between to_date ('2003/01/01', 'yyyy/mm/dd')
   AND to_date ('2003/12/31', 'yyyy/mm/dd');

http://www.techonthenet.com/sql/between.php