I have a drop-down box which fetches data from the database(fetching data from database). Can some body provide the code snippet for the same.Thanks in advanceVasco
our $dns = "dbiracle:host={HOST};sid="; #Replace Host and Service Id $ENV{'ORACLE_HOME'}={ORACLEHOME} unless $ENV{'ORACLE_HOME'}; my $db_conn = DBI->connect($dns, {USER_NAME}, {PASSWD}, {AutoCommit => 1} ) || die $DBI::errstr;
import java.sql.*;class Conn {public static void main (String args []) throws SQLException{DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());Connection conn = DriverManager.getConnection("jdbcracle:thin:@machine:1521rcl", "userid", "password");// @machineNameortID, userid, password} }