Search results for query: *

Hello, Where can I find a list of the additional APIs and Open Interfaces in R12 compared to the 11i version of Oracle Application ?

I have a script creating a file, but I am not sure of the best way to do it. Should it be echo "...." > test or cat filename <<EOF ... EOF The file is a script itself containing quotes. Thanks for your answers

Is there some best practices regarding the use of the shift command to read input parameters to a script (AIX) ? I have seen some guidelines where they use the shift command from the 7th parameter. Is there any particular reasons for that ?

The fields in the external table are INTEGER EXTERNAL. What I would like to do is to let Oracle reject the line, before I do a query on the table. If I receive some spaces in a date field, the line will not be loaded into the external table and will be rejected in the .bad file (if the option is...

Hello, I would like to know if we can use a mask for the type NUMBER in an external table. I load an file with amount that are sign, and I want to be sure that they are always signed. example +5555 -> in the DB : 5555 -123 -> -123 in the DB However 234 should be rejected (no sign)...

It is possible to do that. I found the problem, the field ACCPER is too small to be compared with a date. hen defined with a VARCHAR2(10), it works.

Hello, I want to create a partition on a VARCHAR2(6) field (year + month), but our DBAs only want partition based on dates. I tried the following: CREATE table ...( ACCPER VARCHAR2(6), .... ) PARTITION by range (ACCPER) (partition P200611 values less than (to_date('200612','YYYYMM'))) but I...

Hi, We have a problem of pointer that we are not able to solve. The problem is: we have an entity in our logical model, but when we generate the physical model, nothing appears. The merge screen, doesn't seem to see the entity. Any ideas ?

I agree with you on the obstacles, although, I am not too worried about it as the store is well designed and sources are consistent. In term of "how", I am thinking dblink, but a bit worried about the performances. Any suggestions ?

Hi, I am designing a datamart with 2 facts table. The dimension of one of these tables is very big, and therefore cannot be moved from the ODS to the datamart. How can I have a fact table in a datamart and one of its dimension in the data store ?

Hi, Is it possible to create indexes on a table via a macro ? I have some tables created with a make table query, is there a way to create the indexes without using the menu ? Thanks in advance for your answers

Hi, I am trying to display in the data from a week in year Y and year Y-1 in order to compare them in a single result: The week is formatted YYYYWW Week Income Y Income Y-1 200510 10 15 (results of the week 200410) How can I do that as the lag function cannot work...

yes, well, "a" is not a simple variable/value but an expression (greatest or some date function like extract...) Thanks for your answers.

Hi, While writing some code, I was wondering if it is better to select 1 info per select from dual, or to group them into 1 select ? i.e.: is SELECT a, b, c INTO v_a, v_b, v_c FROM dual; better than SELECT a into v_a from dual; SELECT b into v_b from dual; SELECT c into v_c from dual; ...

Hi, We would like to connect discoverer with 2 databases: 1 is for Oracle Application (to access some packages), the other one contains our datawarehouse. Is that possible with Discoverer 9i ? Our contractors don't seem to be able to do it... Thanks for your answers

Found the solution: Oracle Open Client Adapter

How can I connect a non Oracle database from Forms v6i. I have an ODBC link, but I guess there is something else to do, but I don't know what... Can you help ? Thank you

Yes, perfect, thank you.

Yes, it is from a DB table (or the result of a query that can be used as a table). The aim is to produce a text file with the data formatted as explained above.

Hi, I have a query returning amounts per outlets, per dates (7 dates): outlet Amount date 1001 12 21/02/05 1001 13 22/02/05 1001 5 23/02/05 1001 0 24/02/05 1001 0 25/02/05 1001 0 26/02/05 1001 0 28/02/05 1002 4...