Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: fosa
  • Content: Threads
  • Order by date
  1. fosa

    dbms_random

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

    change dynamic sql into pls/sql EXEC IMMEDIATE

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

    how to obtain all datas from 2 tables outer join

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

    Compare 2 consecutives rows in atable

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

    PIVOT query

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

    SEND MAIL body html

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

    Pivot table

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

    iterate through pipelined function

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

    Filling missing timeseries

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

Part and Inventory Search

Back
Top