ERPstuff - Oracle EBS Community

Some time you may have to round to 10,25,50,100 etc so here are few example hope would serve the purpose. SQL> select round(nvl(173,0)/10,0)*10 from dual; ROUND(NVL(173,0)/10,0)*10 ------------------------- 170 SQL> select round(nvl(173,0)/25,0)*25 from dual; ROUND(NVL(173,0)/25,0)*25 --------------...

Thanks for this nice info now I believe Oracle Alert will not be separately licensed?

In query you may get the desired results but issue is insert/update/delete.

Just download command line of winzip or any other zipping software you are using.

Here is the list of winzip,
http://www.winzip.com/downcl.htm

Instead of dropping the table I would suggest to use Oracle temporary table feature hope your problem will be resolved. By the way why are you dropping the table instead of just truncating it? As if you are changing the structure of table everytime then you must compile the report and if not changin...

Oracle Enterprise Edition $800 per user with a Minimum of 25 users i.e. you need to buy atleast a 25 Users License else you cannot buy an Enterprise Edition License so the list price for the smalled ORACLE Enterprise Edition would be 800 X 25 = US $20,000 Oracle Standard Edition $300 per user with a...

This thread will contain the contact info of different IT related companies both software and hardware.

Required info,

Company Name : ?
Business : ?
Address : ?
Contact person : ?
Contact numbers : ? cell and land line(s)
email : ?
Web site URL : ?

AoA,
If someone has Oracle Alerts info then please share with us. thanks

If you don't have library fiile like calendar.pll then you should download developer 6i demos and it will contain all libraries.

http://www.oracle.com/technology/sample ... demos.html

The following link is a very nice place to get info of the barcodes usage in oracle reports, if still any further query then pl post it under this thread.

http://www.idautomation.com/fonts/tools/oracle/

Pl paste your script/query and exact output you need with table structure.thks

Let's discuss the risks to ERP's or you may say failure causes for any company..... 1. If the companies will not adopt good practices and will try to carry bad practices (if any). 2. Professionals should not keep MS excel in use and should use ERP system as input and output. 3. There should not be a...

There are different books so better to provide title of the book.

Thanks Atif let me talk to Mr. Rahil Saeed Butt.

I need the contact info of the companies who are dealing with RFID's.