Recent content by fosa

OK thanks every body I think select round(dbms_random.value(0,1),2) from dual is interesting I wanted to have 1 among the infinited solution of radom generated vaue between 0 and 1

yes but Iwant to have 1 into the result dbms.random give only value under 1

Hi all, How can I get radom value from dbms_random where I can get the upper limit say I have 0 to 1 as possible values 0, .... 0.00000000000001 ..... 0.00000000000002 ... 0.99999999999999 ... 1 how can I obtain values from 0 to 1 randomly ? 0 <= values <=1

Thnks a lot I fond a workaroun in SQL and which doesn't use dynamic SQl update table_A f set debt_ccy =(select ccy_code from table_b s where s.ticker=f.ticker and debt_ccy is null) where debt_ccy is null and...

yes I can put desc desc table_A TICKER, QUOTE_DATE, DEBT_CCY, DEBT_INF_1Y, DEBT_1Y_3Y, DEBT_3Y_5Y, DEBT_5Y_7Y, DEBT_7Y_10Y, DEBT_SUP_10Y, LEASE desc table_B TICKER, CCY_CODE, PAR_ID, ISIN, RIC, SECURITY_NAME, IS_BASKET_OR_INDEX, INSTRUMENT_TYPE, ASSET_TYPE, HAS_COMPOSITION

when I try this I got en error 1 declare 2 hold_sql varchar2(2000); 3 begin 4 select 'update table_A set CCy_CODE = '''||ccy_code||''' where debt_ccy is null 5 and ticker='''||ticker||''' from 6 table_A f,table_b s 7 where 8 f.ticker=s.ticker 9 and...

Perhaps SELECT b.SaleId,b.Customer,a.Value FROM TableA a, TableB b WHERE a.ProductID = b.ProductID and a.SaleDate =to_date('11/10/08','DD/MM/YY'); Bye

Hi every body, I want to change this sql code select 'update TABLE_A set DEBT_CCy='''||ccy_code||''' where debt_ccy is null and ticker='''||f.ticker||''';' from TABLE_A f,TABLE_B s where f.ticker=s.ticker and debt_ccy is null; into pl/sql execute immediate how can I do ? Thanks

OK , i've not seen you post thanks I works fine

I found an old syntax that works but I want now to have the ANSI one ;-) select d.procedure_name,d.table_name,b.rows_inserted,decode (b.status,null,'MUST BE CHECKED',b.status) status from UTIL_BATCH_DESC D , UTIL_STATUS_BATCH B where d.procedure_name =b.PROCEDURE_NAME(+) and...

HI all I have 2 tables one which contents all the jobs to be done every night and a second which contains the jobs which have really been executed. CREATE TABLE UTIL_STATUS_BATCH ( PROCEDURE_NAME VARCHAR2(1024 BYTE) NULL, INFO_DATE DATE...

Thanks it is very usefull,and simple ;-)

Hi all, I am under Oacle 10G R1 I can use PL/sql sql How can I compare 2 consecutive rows in a table and show the result, I want to check the value > 0 this is the list A1 110 A2 112 A3 112.3 A4 112.4 A5 112.5 A11 113 A12 113.2 A21 114 A23 106 A31 118 A33 120 A34 122 A35 123 A36 124 A37...

Hi Mufasa, Thanks very much, your response is really what I needed In fact with Oracle, there are a lot of tools now, external table, pipelined, clob ... and in 11g we have pivot And last, your responses were done very quicky

Hi, Thanks very much for this reply but I have 2 problemS the RAW datas are separated by "|" not by carriage return so it in fact like this 15/09/2008 10:00:00:15/09/2008 10:01:00:15/09/2008 10:02:00:15/09/2008 10:03:00:15/09/2008 10:04:00|...