Search results for query: *

Hi All, I'm trying to do the following: Generate an output file from an SQL statement in a unix script. The name of the file should be dependent on one of the parameters that is used to call the UNIX script. I have enclosed what I have so far. -- This statement should give me an output, but its...

Hi, I'm extracting data from a temporary table that has been updated and inserted into using pl/sql. The columns are being concatenated as the data is needed as a csv file.The error I get is: ERROR at line 1: ORA-01489: result of string concatenation is too long. Any ideas on how I can bypass...

Hi, I have never used plsql tables before. I am trying to retrieve the last two rows from a cursor. What I intend to do is use the individual variables for each of the rows to carry out some calculations between the two rows. The set of record being retrieved is a mix of old and new data. By...

Hi Guys, I need some advice on how to output some text unto UNIX. What I intend doing in a loop is output data similar to what will be output when you run the query below: select 'Staff ID'||','|| 'First Name'||','|| 'Last Name'||','||...

Hello, I am generating a csv file via unix. The file is bening generated via Oracle SQL. The csv output for some reason has a chunk of space. I have tried using sed to remove the space but it does not work. I'm not very good with sed. Any help will be appreciated. I have enclosed the file...

Hi All, I trying to handle the error ora-01722 in a PL/Sql procedure. I have a columns with rows that have a mixture of varchar2 and number datatype. Originally the column is VARCHAR2. I'm looping through the column and assigning the value to a variable. What I would like is to check that I...

() Aug 23, 2004 Hi All, I trying to handle the error ora-01722 in a PL/Sql procedure. I have a columns with rows that have a mixture of varchar2 and number datatype. Originally the column is VARCHAR2. I'm looping through the column and assigning the value to a variable. What I would like is to...

Hi there, If anyone can help I'll really be greatful. I need a date in the format DD-MON-YYYY i.e.14-JUL-2004. In my UNIX script what I can get is 14-Jul-2004 using date %d-%b%Y. As I can't seem to get the correct date format, anyone know how I can convert the the date 14-Jul-2004 to...

I would like to get the number from this string. There is the possibility of the number growing to more than 5 digits. How do I go about this? select 'Standard Purchase Order 12590 has been approved' from dual Thanks in advance.

I have got the following problem... I have a cursor that will retrieve multiple rows given below... select to_number(c.description) description, b.flex_value from fnd_flex_value_sets a ,fnd_flex_values b ,fnd_flex_values_tl c...

Hi, I'm trying to use order by in a union statement. My columns are concatenated as I'm spooling to a csv file. How can I get this to work as the coumns are not mentioned individually. An extract of the sql is below: SELECT pcak.concatenated_segments||','|| ppf.employee_number||','||...

Hi, I'm trying to count the total number of lines in a file. When I use wc -l FILENAME, I get the number of lines and the filename. I only want the number returned to use in my script. How do I go about this? T

Hello All, Can anyone help me? I would like to create a script that will on start up of my UNIX session it takes in my keyboard settings. Where will I need to create this script and an example of the script e.g for erase will be helpful. Thanks...