Monday, January 16, 2006

More Simple and Important Things to Learn on The Way

Vanilla text output: SELECT 'Executing backup at ', SYSDATE FROM DUAL;

Executing a stored procedure: EXECUTE PACKAGE_NAME.PROCEDURE_NAME;

Disabling column headings: SET HEADING OFF;

2 comments:

Amit Mohanty said...

Hi,

I am Amit. I am interested to know about the compatibility of Oracle 10g on a Pentium III machine. I got to know that its recommended requirement is PIV, but it can also be used with PIII. Can you tell me the problems we will face if we install 10g on a PIII? Also, if Oracle 9i has better performance than 10g on a PIII machine. Please help.

Amir said...

Sorry - i have no idea. I am not an Oracle expert at all.

I can only tell you that RAM is much more important than CPU. If you have at least 512 MB of RAM, then it might work.

Of course, don't use it as your production server, but for some testing or exercises it will probably be OK.

vemxh