Hi ,

The select has to be implemented from inside the MySQl and not from the OS and qx[$select_cmd] or backticks or system would only have it run in the OS .

If the administrator does not want to install the DBI then do it youselves in any other directory and access it if that is somehting you can entertain doing or else try invoking

 system " sqlplus $usernm/$passwd\@$sid \@sql_command_in_an_os_file";

This could work in Oracle and there is corresponding MySQL command that invokes the sql prompt and also kicks off the select statement if the select statement can be had in an os file of as an here document in the program itself .But DBI is THE way to do the database's level works

In reply to Re: perl and sql by OM_Zen
in thread perl and sql by suekawar

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.