Search results for query: *

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

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

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...

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 all, I have datas like this , they come from a 3 party tool not from an oracle table 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:15/09/2008 10:05:00 44.22:44.2:44.165:44.175:44.17:44.2 44.24:44.21:44.2:44.19:44.235:44.21...

hi all, I want to send mail with demomail from orale SAMPLE http://www.oracle.com/technology/sample_code/tech/pl_sql/htdocs/mailexample_sql.txt I want to send an html file in the body like this DECLARE conn utl_smtp.connection; vInHandle utl_file.file_type; vNewLine VARCHAR2(25000)...

Hello everybody I have a table and I want to pivot my request is select info_date, max(decode( dense_rank, 1, last_price,null )) as "TICKER1 max(decode( dense_rank, 2, last_price,null )) as "TICKER2", max(decode( dense_rank, 3, last_price,null )) as "TICKER3" from...

Hello, I create a pipelined function CREATE OR REPLACE TYPE EVENT_ROW_TYPE AS OBJECT ( ID_STOCK VARCHAR2(22), SERVER_TIME DATE, OPEN number, LOW number, HIGH number, CLOSE number, VOLUME number, TRADE...

Hi all, I want to fill a minutelly historical table CREATE TABLE MY_HISTO ( ID_STOCK VARCHAR2(22 BYTE) NOT NULL, SERVER_TIME TIMESTAMP(3) NOT NULL, LOW NUMBER, HIGH NUMBER, OPEN NUMBER, CLOSE NUMBER, VOLUME NUMBER, TRADE NUMBER ); insert into table1 values ('3IN LN...