MAX(DATE)

From: <jeanch_at_my-deja.com>
Date: Wed, 29 Mar 2000 19:11:36 GMT
Message-ID: <8btkgn$h7g$1@nnrp1.deja.com>

Folks

Can anybody help ?

I am trying to get the latest (timewise) entry to the clipboard.

when I run the below select using SQL it works but not using PL/SQL;

It seems like the MAX function does not understand Date type.

....

v_undoString CLIPBOARD.DATA%TYPE DEFAULT NULL;
p_eid INTEGER;
v_name VARCHAR(30);


BEGIN
	SELECT data
		INTO v_undoString
		FROM CLIPBOARD WHERE
		timestamp = (SELECT MAX(timestamp)
		FROM CM_UNDO_CLIPBOARD
		WHERE num = p_num AND OWNER = v_Name);

END; Table description

 Name                            Null?    Type
 ------------------------------- -------- ----
 num                                      NUMBER(38)
 TIMESTAMP                                DATE
 OWNER                                    VARCHAR2(100)
 DATA                                     VARCHAR2(2000)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 29 2000 - 13:11:36 CST