Forum Replies Created

Viewing 15 posts - 7,441 through 7,455 (of 9,399 total)

  • RE: Today's Random Word!

    SQLRNNR (9/3/2014)

    djj (9/3/2014)

    SQLRNNR (9/3/2014)

    slag

    heap

    sludge

    Flood

    September 3, 2014 at 10:56 am

    #1742915

  • RE: How bad this in terms of performance; udf in WHERE

    TheSQLGuru (9/3/2014)

    Scalar (and multi-statement table valued) user defined functions can be DEVASTATINGLY BAD!!! There are multiple ways they can screw you. A short list includes:

    1) prevent optimizer from...

    September 3, 2014 at 6:56 am

    #1742767

  • RE: Today's Random Word!

    crookj (9/3/2014)

    Ed Wagner (9/3/2014)

    Stuart Davies (9/3/2014)

    BWFC (9/3/2014)

    Ed Wagner (9/2/2014)

    SQLRNNR (9/2/2014)

    gnocchi

    Pasta

    Pizza

    Express

    Espresso 😀

    Needed (need real bad this morning......)

    Wanted

    September 3, 2014 at 6:48 am

    #1742763

  • RE: How bad this in terms of performance; udf in WHERE

    You don't want a function (built-in or UDF) on the left side of the operator (in this case, the =) because the function will have to be evaluated for each...

    September 3, 2014 at 6:23 am

    #1742752

  • RE: Today's Random Word!

    Stuart Davies (9/3/2014)

    BWFC (9/3/2014)

    Ed Wagner (9/2/2014)

    SQLRNNR (9/2/2014)

    gnocchi

    Pasta

    Pizza

    Express

    Espresso 😀

    September 3, 2014 at 5:32 am

    #1742731

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (9/2/2014)

    Ed Wagner (9/2/2014)

    ...that was pretty simple stuff that should have been easy for him to troubleshoot on his own.

    I'm glad that optimism prevails:-D

    😎

    Thanks, but I guess I spoke...

    September 2, 2014 at 1:54 pm

    #1742586

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/2/2014)

    Koen Verbeeck (9/2/2014)

    Lynn Pettis (9/2/2014)

    Am I missing something? Doesn't this error mean that the table or view doesn't exist, not that there is a problem with the...

    September 2, 2014 at 1:40 pm

    #1742580

  • RE: Are the posted questions getting worse?

    Ed Wagner (9/2/2014)

    Koen Verbeeck (9/2/2014)

    Lynn Pettis (9/2/2014)

    Am I missing something? Doesn't this error mean that the table or view doesn't exist, not that there is a problem with the...

    September 2, 2014 at 1:39 pm

    #1742578

  • RE: Error Single quote stored in variable

    Welsh Corgi (9/2/2014)

    Thanks for all of the help.

    It works Lynn.

    Ed you code worked as well.

    Thank you very much.

    I'm glad we could help and that it's working for you.

    September 2, 2014 at 1:37 pm

    #1742576

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (9/2/2014)

    Lynn Pettis (9/2/2014)

    Am I missing something? Doesn't this error mean that the table or view doesn't exist, not that there is a problem with the WHERE clause?

    OLE...

    September 2, 2014 at 1:36 pm

    #1742574

  • RE: Error Single quote stored in variable

    Look at the username you're using to make the connection to Oracle. That username must have permission to select from the table/view you're trying to select from. If...

    September 2, 2014 at 1:32 pm

    #1742570

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (9/2/2014)

    Ed Wagner (9/2/2014)

    Eirikur Eiriksson (9/2/2014)

    Lynn Pettis (9/2/2014)

    Curious how the code that our silver spooner posted even worked. After declaring all the variables I still have a bunch...

    September 2, 2014 at 12:31 pm

    #1742556

  • RE: Error Single quote stored in variable

    Lynn Pettis (9/2/2014)

    Welsh Corgi (9/2/2014)

    Ed Wagner (9/2/2014)

    Good. Now all you have to do is look at the format mask of your TO_DATE function.

    TO_DATE(''2014-09-02'',''YYYY.MM.DD'')

    The date string doesn't match the format...

    September 2, 2014 at 12:13 pm

    #1742550

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (9/2/2014)

    Lynn Pettis (9/2/2014)

    Curious how the code that our silver spooner posted even worked. After declaring all the variables I still have a bunch of red squiggly lines.

    Total...

    September 2, 2014 at 11:53 am

    #1742545

  • RE: Error Single quote stored in variable

    Good. Now all you have to do is look at the format mask of your TO_DATE function.

    TO_DATE(''2014-09-02'',''YYYY.MM.DD'')

    The date string doesn't match the format string.

    September 2, 2014 at 11:49 am

    #1742544

Viewing 15 posts - 7,441 through 7,455 (of 9,399 total)