Tip Bank

DevX - Software Development Resource

Date format

Question: My application (RIS) converts a date in an integer to store it in a Database. Integer = x seconds after 1.1.1970 (for ex., 709444800). I want to make a

DevX - Software Development Resource

Using views to improve performance

Question: We are building a Web-based interface for an existing database. We’reusing a SQL interpreter that runs the queries, then sends them to theserver without the need for a client

DevX - Software Development Resource

How can I write to OS files from Oracle?

Question: How can I write to OS files from Oracle? Answer: Oracle version 7.3 supports directreading and writing of operating system files from within Oracle.In particular, the utl_file package enables

DevX - Software Development Resource

How can I send email from Oracle?

Question: How can I send email from Oracle? Answer: A recurring question on Oracle developer listsis how to send email from “within” Oracle. One might want a certain event in

DevX - Software Development Resource

Rich text presentation style

Question: When using a rich text datawindow (not an rte control), is there a way to save the contents to a file as rich text, as is? In other words,

DevX - Software Development Resource

Referencing instances of classes

Question: How do classes communicate? If class A created one or more instances of class B and class C, how can class A keep track of all the instances of

DevX - Software Development Resource

OPO and stored procedure parameters

Question: Stored procedure on WG7.3 Oracle expects three parameters. I can get OPO 2.0 to pass the params if I cite them literally as, for example, exec sql begin addnewperson(‘John’,’Quincy’,’Doe’);