Search results for query: *

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.

Thanks for the point n click tip. I tried that by first typing an "=" sign in the destination cell then I went over to the other worksheet and clicked it and hit enter. It hightlighted as in it recognized the reference but it doesn't stick. Is there any known bugs? Please advise. Thanks again!

Here's an example of a formula that works in one cell but not another: =Details!C2 This for MS Excel 2003. Is there some kind of special formatting I need to do? Just don't get why it merges fine one some cells but the same formula won't work on another cell. Thanks in advance.

Hello, I have a hidden worksheet that I reference on a visible worksheet. I'm able to successfully reference some cells from the hidden worksheet, but I'm having trouble with others. I triple-checked my syntax and it looks good. I even used the same reference as in the cells that are working...

THanks for the tip. Round doesn't display the decimal places if it equals to 00. So, in the meantime I got the author of the form to unlock the cells, so I just formatted the cells to Numeric with 2 decimal places. Thanks!

Hello, My excel spreadsheet populates through a linked table. I was able to format the field to diplay decimals by using: =TEXT(A2,"0.00"). However, it defaults to left justification. I'd like to know if there is an option to right justify the output using the formula or if there is a TO...