Recent content by mpramods

You can use the following or modified version of the code below: select email_id, character_length(email_id) as email_length, case when email_length >15 then 'SUSPICIOUS' else 'NON-SUSPICIOUS' end as email_type from <TableName> where email_type = 'NON-SUSPICIOUS' Let me know if it...

p5wizard, The solution you mentioned uses Cron Tab. I cannot use Cron Tab to do this. Is there any way, I can do this using a Unix Shell script?

I need to write a script to run weekly jobs on particular days of the week. e.g., The schedule of Jobs could be as follows: 1. Job A needs to run every Monday at 10:00 AM 2. Job B needs to run every Monday at 3:00 PM 3. Job C needs to run every Tuesday at 12:00 PM 4. Job D needs to run every...

Try this sel cast(begin_date as date) from <table_name> Cheers, Pramod

I need to update the value in a column for 50% of the records in the table. I need to use a single sql for this. I am using the following but it does not work. update a set column_name = 'xxxxx' where acct in ( sel acct from a sample .50 ) It fails with a message saying that I cannot use...

Can you copy and paste the data in your column, so that we can see how the data looks like. Cheers, Pramod

Try this: UPDATE TNATDATA.CYBPRCU01 SET SHOP_NBR = TNATDATA.FACT_HR_ASCPAYINFO.HOME_SHOP_NBR WHERE TNATDATA.FACT_HR_ASCPAYINFO.EMP_NBR = TNATDATA.CYBPRCU01.PAYROLL_NBR AND TNATDATA.FACT_HR_ASCPAYINFO.WK_END_DATE = '2007-03-17' Cheers, Pramod

spookie, To answer your question, we need to change some sensitive data in a file. So I am creating a scrambled lookup file, the data from which will be used to replace the real data. feherke, I do not have GNU coreutils on the system I am working on. So the 'sort -R' does not work for me. I...

This is in continuation to the my previous post called 'create file with possible combinations of numbers from 3 files' I have a file with 10,000,000 numbers. Sample data(18 records) from this file1 is as follows: 100333505 100333606 100333707 100444505 100444606 100444707 100555505 100555606...

sbrews, You rock!! You get a star for the solution. Your script is working perfect. It took appro 17 minutes to generate the file with 10,000,000 numbers. Cheers, Pramod

Suppose I have 2 numbers each in 3 files file1 contains 100 200 file2 contains 333 444 file3 contains 505 606 How can I create a new file which will have all possible combinations of numbers from the 3 files, pasted side by side? The new file will contain the following: 100-333-505...

Where selected SALARY from Table2 is EQUAL TO OR FIRST DATE'S GREATER THAN Spl_Event_date of table1. Didn't get the meaning of the above sentence. Can you repost your question more clearly? Thanks, Pramod

I need to read the value of a parameter in a file. If the number of characters in this value is more than 10 then I need to take the first 10 characters of this value(something like a substring(value,1,10)) and substitute it as its value. e.g., TABLENAME=EMPLOYEE_RECORD - Here the value of...

carp, I am getting tablespace issues when I try to run the commands you provided. I cannot get the tablespace increased for this. ddiamond, I get an error with your command: SELECT max(dbms_lob.getlength(to_lob(Y))) FROM X; * ERROR at line 1: ORA-00932...

Hi, I have a column defined as LONG which contains some XML code. Is it possible to find 'The maximum size of data in this column'?. The data in the column looks as below(I have pasted 3 rows of data from this column). <!-- MemberObjectGroups="#ID#XXXX:DIS:NAM" cost="11111"...