Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - zx8754

Pages: [1]
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

Pages: [1]