Re: Interface questions from Oracle newbie

On Feb 6, 1:49 pm, johnnyfalco..._at_hotmail.com wrote:
> Hello, I'm in IT infrastructure and my division is converting to
> Oracle. The folks at corporate HQ have claimed that the following two
> things are not possible in Oracle 11i.
>
> Can anyone comment?
>
> 1) Date field on interface: We don't care how the data is stored on
> the backend; the concern in that the order entry process will be
> significantly slowed if our reps have to enter all dates as 15-AUG-07
> on the front end. Adhering to the day/month/year format is not a
> problem; the problem is that our entry people are so fast that they
> want to enter all orders as 15-08-2007. Can the front end be
> customized to accomodate this, and if so, how much work is it?

As simple as setting the default format, via NLS_DATE_FORMAT, or calling a function, ie TO_DATE()
it also could be done in your front end program. So whoever thinks this is a problem, does not understand programming, let alone ORACLE.

>
> 2) Case sensitivity issues: One of our problems is that our customer
> identifier is currently case sensitive - can this be changed so that
> Samsung and SAMSUNG are seen as the same customer, and the back end
> fields are identical? Also, can the invoices and packing lists be
> generated so that they look nice? Currently all packing slips and
> invoices are generated as SAMSUNG, in all caps. We'd like it to
> appear as Samsung - is this a huge project to make this happen?
>

Fields? You coming from a mainframe or file environment?

Data is generally case sensitive. (this isn't just an ORACLE issue). Look at the Oracle functions: UPPER(), LOWER(), INITCAP() So NO this is not a BIG project.
But I'll point out that again the person who thinks the format of the reports is an ORACLE problem really does not have a clue. It is a matter of the report program, how it was written.

> Thank you in advance for your expertise.
>
> Regards,
>
> J.F.

No expertise needed, just a basic understanding of Oracle that you can get from reading their manuals. Go to the Oracle web site and look this up.

Ed Received on Tue Feb 06 2007 - 13:09:20 CST