Search results for query: *

Dear Mufasa, I am used to declare a global variable in pl/sql. The problem is that i have to work with an interface (OWB) that generates PL/SQL code, and i really dont know how to work with global variable with that tool! (I dont know if it is possible..) I found nothing on the subject on...

Hi, Does somebody knows how to declare and use a global variable in the software "Oracle Warehouse Builder 9i" ? Thanks..

Hi, Does somebody knows how to declare and use a global variable in the software "Oracle Warehouse Builder 9i" ? Thanks..

Hi, I can't use your way tomreid, because the sysdate field will not always be the last, year after year we have to add some fields to the table. I found the solution finally: use a trigger, like this: BIR means BEFORE INSERT REPLACE. --D2_BIR_01_TABLE1-- CREATE OR REPLACE TRIGGER...

Dear Gunjan14, It works with my test tables, i am really happy. I think that your procedure would be very helpful to many programers. We will now test the perforamnce with a big table to see if it takes too much time, and i think that we will use it. Anyway, i will certainly reuse it in a few...

Hey, gunjan14, are you a genius? :) I try this right now with my test tables, and i will tell you if it work.. thanks! Fanny

I know, but this is a really BIG database, for the government of quebec, with over than 400 tables, 10 millions of rows, 3 DBA's, 10 analysts, 2 architechs, etc.. And we dont want to list all the columns in the insert statement.. I was wondering if a functionnality exists to insert the default...

My table already have a DEFAULT value. But with the insert into ... (select * ...), if the field of the source table is null, it inserts the null value. And i want it to insert the default value, because we have to have the EXACT time when the row is inserted.

Dear Santa Mufasa, I can't do it this way, because the wan't to have the exact time when the row is inserted, date+hour+minute to do some statistics. So i have to insert the default value exactly at the same time than the row. The table will have more than 300 000 rows. Do you know the way to...

Hi, I have to make an insert from a table to another, example: Insert into table1 (select * from table2) If a field of table2 is empty or NULL, i'd like it to automatically insert the DEFAULT value. I've tried it, but it doesn't work, the only way it inserts the DEFAULT is when i specify it...

Hi!! I have this simple problem, but don't know how to resolve it: source table have char type, and target table have a varchar2 type. I don't know how to do the conversion from one type to the other, and the script give me an error because the types are different. I cant change them.. Help !!!

Hi! You can use ROWNUM : select * from your_table where rownum <= 5; Best regards, Yipyeppp..

SELECT * FROM A WHERE Description = 'Small widget' OR (Description = 'Big Widget' AND Date > '05/05/03') Not sure.. but i think this should work well..

SELECT * FROM A WHERE Description = 'Small widget' OR (Description = 'Big Widget' AND Date > '05/05/03' Not sure.. but i think this should work well..

I really don't know, it is supposed to work, your code is well done. Do you think it may be your &quot;)&quot; taht is not there on the line of your SUM, and the */ that is still there too??

Thank you, Dima.. it was very helpful !! Have a nice day !!

Okay, thank you !! :o)

I have to call a C program from my PL/SQL, with a string as an argument, and i don't know how to do it. Can you help me?

I have to call a C program from my PL/SQL, with a string as an argument, and i don't know how to do it. Can you help me?

Hey.. thanks a lot !! YipYeppppppppp is a happy girl now!!