Search results for query: *

Hi, I'm trying to write a unix script - korn shell to execute a function in an oracle database - pretty straightforward - except I want to display the dbms_output.put_line in a file - that's where the problem comes in! Any ideas how you do it? Thanks for your help

I'm having a slight problem trying to extract a date field from a text file - any hope someone could help me out!? I have a input file from which I am trying to extract only the date field from each line - the problem is the date field is not always in the same column - sometimes it is in the...

I was hoping someone might be able to help - I'm trying to extract the 7th column from a file - each field is seperated by a tab - I'm using the following awk command but it doesn't return anything - i don't know has it something to do with the file sperator or what but was hoping someone else...

Hi, I was wondering if anyone knew if it was possible when saving a worksheet as a text file to change the delimiter - I know you can save the worksheet as a comma delimited or tab delimited file but I was wondering if you could use a different delimiter such as | or = or !? I'm using excel...

Hi, I'm having a bit of dificulty with a pl/sql block - basically I want to enter a whole load of values into a table - if there is duplicates I want to check if the duplicate exists in another table - if it does I want to enter it into table a otherwise i want to enter it into an error table...

Hi, I need to convert a time field in the format hh24:mi:ss to a number in the format hhmiss - I have tried using to the to_number function but amn't having any success... Any chance anyone knows how I can do this? Thanks for your help, jim

Hi, I have a list of order ids in a table, there may be more than one of the same order ids, i want to set a variable equal to the order_id plus a sequence so basically if I have a list of order id in a table as follows 1234 1234 1234 9876 9876 6789 I want to set another field in the table...

Hi I was wondering if anyone could help... I'm trying to execute a stored procdure from within an anonymous pl/sql block.. something like Declare var1 NUMBER; BEGIN execute test_procedure ('param1', 'param2'); END; but I get the a pl/sql error "expecting symbol :=, ...." Is it...

Hi i was wondering if it's possible to call a unix script from a pl/sql procedure. Something like If x = 0 then call the unix script else don't end if Thanks for the help. jimmy

hi, I'm using pl/sql to write a loop... basicaly this loop loops between two different times and deletes information between these two times. I'm having a problem in that the loop increments in 5000's.. but this means that it is going past the hour for example when it reaches 095500 (9:55) and...

Hi I'm trying to write an SQL query in Oracle 8i which retrieves a number of columns. In addition I want to retrieve 3 benchmark columns (the information in each varies however the rest of the data is the same) The query I have written at the moment returns the data in 3 seperate rows... I...