A_single_file_wiki_wifky2.png

[plugin] SQL*Wifky (Oracle 󥿡ե)

[Add this entry to hatena bookmark]

ץ饰ϡȥͥåѤǤ!!! 󥿡ͥåȾǻȤΤϡƥǤȥͥåγȯǤΤ߻ȤΤˡǤ

SQL*wifky Ȥ

sqlwifky.pl

wifky SQL*Plus ǡOracle ΥեȥɤȤƻȤΥץ饰ǤڡƥȤ SQL 񤤤ơɽ˸ִ̤ޤ

  ((sql select * from tab where tabtype=:tabtype ))

sqlwifky-image1.gif

ƥȥܥå㤨СTABLEפϤơQUERY ܥ򲡲ȡΤ褦ˤʤޤ

sqlwifky-image2.gif

ΤȤselect ʸȯԤǤޤ󤬡ǡ١ץꥱưڤʤɤ˽ʬѤǤȻפޤ

Ѥɬפʤ

  • Oracle DB ͥåȥǥǤϰϤˤɬפޤ
  • Web оˡPerl/DBI ,DBI-Oracle ƳƤɬפޤ

ƯǧĶ

    • Redhat Linux AS 2.1
    • Oracle 9i Standard Edition 9.2.0.5
    • DBI ?.?? (ǰơǧ)
    • DBD-Oracle ?.?? (ǰơǧ)
    • WindowsXP Home Edition
    • Oracle Database 10g Express Edition Release 10.2.0.1.0
    • Perl 5.8.0 (Cygwin/X on Windows)
    • DBI 1.50
    • DBD-Oracle 1.17

Ƴ

̾Υץ饰Ʊͤˡsqlwifky.pl wifky Υǥ쥯ȥ֤Ƥ ξǡTools ˸ Oracle βܤꤷƤ

ORACLE_BASE
Ķѿ ORACLE_BASE ꤹ٤ǥ쥯ȥ̾򵭽ҤƤ
ORACLE_HOME
ORACLE_HOME ꤹ٤ǥ쥯ȥ ORACLE_BASE ХѥǵҤƤ
SID
ORACLE_SID ꤷƤ
user
Oracle ³ݤΥ桼̾ꤷƤ
password (retype)
嵭桼ǥ󤹤뤿ΥѥɤꤷƤ ս񤤤Ƥ
max rows
select ˲̤ɽ롢ԿꤷƤ
  • Ĥܤ Windows Oracle Server Ǥϻꤷʤ Ok Ǥ
  • Ф Windows ξ硢١httpd Ƶưɬפޤ

|

Designed for @nifty.