Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. YipYeppp

    OWB - GLOBAL VARIABLE

    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...
  2. YipYeppp

    OWB - GLOBAL VARIABLE

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

    OWB - GLOBAL VARIABLE

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

    INSERT DEFAULT

    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...
  5. YipYeppp

    INSERT DEFAULT

    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...
  6. YipYeppp

    INSERT DEFAULT

    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
  7. YipYeppp

    INSERT DEFAULT

    ...in the insert statement.. I was wondering if a functionnality exists to insert the default value when taking rows from the staging tables to the production tables, by making a "select *". I think it doesn't exists finally.. i will talk with the DBA about this.. Thanks a lot guys and girls..
  8. YipYeppp

    INSERT 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.
  9. YipYeppp

    INSERT DEFAULT

    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...
  10. YipYeppp

    INSERT DEFAULT

    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...
  11. YipYeppp

    Conversion from CHAR to VARCHAR2

    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 !!!
  12. YipYeppp

    How to Select the first 5 rows of any table or a view

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

    conditional select

    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..
  14. YipYeppp

    conditional select

    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..
  15. YipYeppp

    Sub query returning value...

    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??
  16. YipYeppp

    Call a C program from a PL/SQL procedure

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

    How can you call a C program from a PL/SQL procedure?

    Okay, thank you !! :o)
  18. YipYeppp

    Call a C program from a PL/SQL procedure

    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?
  19. YipYeppp

    How can you call a C program from a PL/SQL procedure?

    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?
  20. YipYeppp

    SELECT statement with a maximum of rows, or the first or the last.

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

Part and Inventory Search

Back
Top