Recent content by cuetzpalin

Hi, Thank for taking time to read my thread. I'm new to PL/SQL so I need some help. I don't know if a loop will work or what to use to accomplish what I need. I have a table with product codes that can be associated with more than one product category. What I'm looking to do is create code...

Hi, Thank for taking time to read my thread. I'm new to PL/SQL so I need some help. I have a table with product codes that can be associated with more than one product category. What I'm looking to do is create code that will look at all the product codes and basically loop through the...

Thank you. I'll take a look at the link...

Hi, I'm looking more for an example on how to use external tables where the external table being an excel file or csv file. If you could provide a step by step on how to do this or lead me to a good reference site I'd greatly appreciate it! THanks in advance for your help!

Hi, How would I select rows from an excel file if I were to place the excel file in the same directory as the Oracle DB? I have a process where somebody send data in excel via email. I'd like to know if it's possible to drop the excel file in a directory and execute a script than can read the...

Hi, How would I calculate a person's age by using the DOB vs. the current date? The format of the DOB is: YYYYMMDD What would be the easiest way of doing this? Please advise. Thank you! - Eli

Hi, I created a table based of another dataset and added a field that is a sequence number for each record. The spool file should spool all the fields in a record on one line....basically concatenating all fields... For example 0001 John Does 02/10/10 0002 Jane Doe 03/10/10 0003 Jack...

The header should have the an "H" followed by the current date YYYYMMDD then a number that will be sequential. The trailer should have a "T" followed by the number of records for each client. Example: H20100325000001 1 John T00000000000001 H20100325000002 2 Ray 2 Ray 2 Ray T00000000000003...

Hi, I need help in putting together a script that will query a client table and spool the results after each unique client ID. The spool data will need a trailer and a header. I understand how to write a simple sql query and how to spool data but I don't know how to code for this situation...

Thanks for your suggestion. The value actually changed from True to 1.

Hello, I built an Access App that generates and sends out an email through Lotus Notes. I recently upgraded Lotus Notes to version 8.0.1 and now the emails aren't being sent with High Importance. In my code module I have to following references checked: Lotus Domino Objects Lotus Notes...

Hi, I have a table that contains "daily" data and another table containing "historical" data. I need to insert the "daily" data into the "historical" data but I don't want any duplicates added to the "historical" table if the "daily" record already exists. Can you please provide the INSERT...

That's slick! Thanks Mufasa!

Hi All, I have a script that has an input for region code. I'm expecting the user to enter NC or SC as the values. Based on those input values I want to be able to call a certain script. Here's a code snippet: -------------------------------------------- PROMPT PROMPT ENTER REGION CODE...

Thanks Skip! I opted to go the easy way and had the author unlock the worksheet, so I was able to format the cells as numeric with 2 decimal places.