AskTom – the personal touch

AskTom has been answering questions from the user community for nearly 16 years.

But what if that service could have an even more personal touch ?  We are pleased announce the largest advance in AskTom service since it started way back in 2000.

See all the details in the video below for the new service we are launching on April 1st.

4 thoughts on “AskTom – the personal touch

  1. Hello Connor,

    Glad to hear AskTom is improving.
    I have a complex issue for which I opened SR 3-10904426351 in the past.
    There were a lot of discussions in this SR and I even raised the severity up to 1 for a short time.
    I’m still unsatisfied with this resolution.
    As for me, it’s a serious limitation of EBR technology.
    I’d like to reanimate that problem on AskTom if you don’t mind.
    I hope you won’t tell us to open a new SR.

    Best regards,
    Mikhail Velikikh.

  2. dear sir ,
    please answer this question sir

    create table fromtable (col1 number(17), col2 number(17) );
    /

    create table fromtable (col1 number(17), col2 number(17) );
    /

    insert into fromtable ( col1,col2 ) values (17100617100650001, 17100617100650100 );

    /
    run all sql in HR schema
    step 1
    run above script one by one
    now the table will be created as follows

    fromtable
    col1 col2
    17100617100650001 17100617100650010

    totable ( empty table)
    col1 col2

    step 2

    Create script as follows

    Script Name :test.sql

    declare
    i number;
    exprec fromtable%rowtype;
    cursor c1 is select *from fromtable where col1 = 17100617100650001;
    begin
    open c1;

    loop
    fetch c1 into exprec;

    exit when c1%notfound;

    for i in exprec.col1 .. exprec.col2

    loop

    insert into totable(col1) values(i);

    end loop;
    commit work;
    end loop;
    close c1;
    end;
    /

    The output should be as follows

    fromtable
    col1 col2
    17100617100650001 null
    17100617100650002 null
    17100617100650003 null
    17100617100650004 null
    17100617100650005 null
    17100617100650006 null
    17100617100650007 null
    17100617100650008 null
    17100617100650009 null
    17100617100650010 null

    when run the sql

    Sql> @ drive name :\test.sql

    eg : Sql> d:\test\test.sql ;

    err message : Numeric overflow

    .
    Note : When executing

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s