Recent content by MikeM

Pete, your memory is obviously failing you in you old age :)

you can subtract one date from another then extract the days and hours from the interval returned e.g. declare date1 timestamp := to_timestamp('02-JAN-2007 12:00', 'DD-MON-YYYY HH24:MI'); date2 timestamp := to_timestamp('01-JAN-2007 13:00'...

Robert, the manual is referring to the "Edit" menu option called "Recall Statement". Not the plug-in.

Hi Marco, any update on this? Thanks, Mike

sorry... Pl/SQL Dev Version 7.1.1.1339 Oracle9i Enterprise Edition Release 9.2.0.4.0 on Tru64 and Oracle9i Enterprise Edition Release 9.2.0.6.0 on HP-UX

Run the following in an SQL window: SELECT dummy, CURSOR (SELECT dummy FROM dual) FROM dual; In version 7.0 you can view the contents of the cursor. In version 7.1 the error "ORA-01001: invalid cursor" is displayed when trying to view the contents of the cursor. We use a lot of nested...

What does compiling in SQL*Plus show?

Go to Windows -> Save Layout after positioning stuff how you want it. Or choose "Autosave desktop" from Preferences -> User Interface -> Options.

split should be before or after || but is splitting variable name: DECLARE TYPE my_rec IS RECORD( hello_there_aaaa VARCHAR2(100), hello_there_bbbb VARCHAR2(100)); TYPE my_tab_type IS TABLE OF my_rec; my_tab_with_a_long_name my_tab_type := my_tab_type(); BEGIN...

Version 7.0 and before gives this (misplaces the END IF): DECLARE b BOOLEAN := TRUE; c VARCHAR2(1) := 'A'; BEGIN IF b THEN CASE c WHEN 'A' THEN NULL; WHEN 'B' THEN NULL; END CASE; END IF; END; when it should...

Try this: http://hanbitbook.co.kr/web/example/9335/files/textio.doc

Thanks Marco, I was trying to use to_timestamp in the parameter input area, whereas simply 01/01/05 was all that is needed.

Hi, I have a procedure that accepts a DATE and a TIMESTAMP and I test it in the test window, the DATE variable has the handy date select popup but the TIMESTAMP variable is a string. This causes problems trying to get values into the TIMESTAMP variable. I'm running 10g (10.1.0.4). Is this a...