Tip Bank

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

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

Can Crystal Reports output to MS Word?

Question: The Crystal Reports help file contains “Pro-only Topics.” Can I use these Pro features with the Crystal Reports engine I recieved with OPO? If so, where can I find

DevX - Software Development Resource

Field-level and interfield validations

Question: Field-level validations should be done when the user visits the field. How can this be done?Interfield validations on the same screen also should be done when the user visits

DevX - Software Development Resource

Sending email from within OPO applications

Question: Is there a way to send email from within anOracle Power Objects application? Answer: There is not a native function to do this within OPO.However, you can use any

DevX - Software Development Resource

Connecting to Oracle

Question: I have been trying to connect to our Oracle General Ledger Version 10.SC from PB5 Ent. I am accessing it from my PC running Win95 and a database that

DevX - Software Development Resource

OPO 2.0 and mathematic operations

Question: Yesterday I received a description for a reality problem I must represent in my OPO-database application. It concerns the drinking water supply for a city, and the staff of