Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re^3: Static Data, SQL::Parser

by renodino (Curate)
on May 08, 2007 at 02:36 UTC ( #614084=note: print w/ replies, xml ) Need Help??


in reply to Re^2: Static Data, SQL::Parser
in thread Static Data, SQL::Parser

The DUAL actually works in the query; changing 1 to a fake column name parses correctly.
Sorry, I should've been more specific. Yes, any table name will parse OK, as will omitting the FROM clause entirely. I meant to indicate that you shouldn't rely on DUAL being supported by any underlying specialization.

(Teradata ? As I live and breathe, I never expected to encounter someone on PM who actually knows what a Teradata is...)


Perl Contrarian & SQL fanboy


Comment on Re^3: Static Data, SQL::Parser
Re^4: Static Data, SQL::Parser
by CLovegren (Novice) on May 08, 2007 at 08:21 UTC
    The good thing is, I don't need them to run; I already know they do since they are in a production level environment. I may end up just grepping the data out of the queries since I don't really need the joins to work or anything of that nature; just the statement structures were exactly what I was looking for.

    And as for Teradata... not my choice; seriously. We're just a reporting environment. :)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://614084]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (6)
As of 2015-07-07 09:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (88 votes), past polls