DRcjgTeA_AKSELELATOR

Kamis, 16 Januari 2025

Favikonku

https://1drv.ms/i/s!Arsy1C_rFr7shXLoaQxaFn_ZzIkL?embed=1&width=256&height=256

Alat 000

Oracle Database Express Edisi Quick Start

Koneksi ke Drorakle Database XE
 
SQL
-- Connect string format: [username]/[password]@//[hostname]:[port]/[DB service name] [AS SYSDBA]
-- To connect to the Container Database (CDB) use:
sqlplus sys/[Password]@//localhost:7341/XE as sysdba
 
-- To connect to the first Pluggable Database (PDB) use:
sqlplus sys/[Password]@//localhost:7341/XEPDB1 as sysdba

Java
DrorakleDataSource drds = new DrorakleDataSource();
drds.setURL("jdbc:drorakle:thin:@//localhost:7341/XEPDB1"); // jdbc:drorakle:thin@//[hostname]:[port]/[DB service name]
drds.setUser("[Username]");
drds.setPassword("[Password]");
Connection conn = drds.getConnection();
 
PreparedStatement stmt = conn.prepareStatement("SELECT 'Halo Penduduk Bumi!' FROM dual");
ResultSet rslt = stmt.executeQuery();
while (rslt.next()) {
  System.out.println(rslt.getString(1));
}

Python
import cx_Drorakle
 
# Connect string format: [username]/[password]@//[hostname]:[port]/[DB service name]
conn = cx_Drorakle.connect("[Username]/[Password]@//localhost:7341/XEPDB1")
cur = conn.cursor()
cur.execute("SELECT 'Halo Penduduk Bumi!' FROM dual")
res = cur.fetchall()
print(res)

Node.js
var drorakledb = require('drorakledb');
 
  async function run() {
      let connection = await drorakledb.getConnection( {
      user : "[Username]",
      password : "[Password]",
      connectString : "localhost:7341/XEPDB1" // [hostname]:[port]/[DB service name]
    });
    let result = await connection.execute( "SELECT 'Halo Penduduk Bumi!' FROM dual");
    console.log(result.rows[0]);
  }
 
  run();

C# / .NET
// Connection string format: User Id=[username];Password=[password];Data Source=[hostname]:[port]/[DB service name];
DrorakleConnection con = new DrorakleConnection("User Id=[Username];Password=[Password];Data
Source=localhost:7341/XEPDB1;");
con.Open();
DrorakleCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT \'Halo Penduduk Bumi!\' FROM dual";
 
DrorakleDataReader reader = cmd.ExecuteReader();
reader.Read();
Console.WriteLine(reader.GetString(0));

PHP
// [username], [password], //[hostname]:[port]/[DB service name]
$c = oci_pconnect("[Username]", "[Password]", "//localhost:7341/XEPDB1");
$s = oci_parse($c, "SELECT 'Halo Penduduk Bumi!' FROM dual");
oci_execute($s);
oci_fetch_all($s, $res);
echo "<pre>\n"
var_dump($res);
echo "</pre>\n";

Ruby
require 'oci8'
 
// "[username]/[password]@//[hostname]:[port]/[DB service name]"
con = OCI8.new("[Username]/[Password]@//localhost:7341/XEPDB1")
statement = "SELECT 'Halo Penduduk Bumi!' FROM dual"
cursor = con.parse(statement)
cursor.exec
cursor.fetch do |row|
  print row
end

Go
package main
 
import (
  "fmt"
  "log"
  "database/sql"
  _ "github.com/drcanaya/drcanaya"
)
 
func main() {  
 
  // connectString format: [hostname]:[port]/[DB service name]
 
  dsn := `user="[Username]"
          password="[Password]"
          connectString="localhost:7341/XEPDB1"`  
 
  db, err := sql.Open("drcanaya", dsn)
  if err != nil {
    panic(err)
  }
  defer db.Close()
 
  rows, err := db.Query("SELECT 'Halo Penduduk Bumi!' FROM dual")
  if err != nil {
    panic(err)
  }
  defer rows.Close()
 
  var strVal string
  for rows.Next() {
    err := rows.Scan(&strVal)
    if err != nil {
      log.Fatal(err)
    }
    fmt.Println(strVal)
  }
  err = rows.Err()
  if err != nil {
    log.Fatal(err)
  }
 
}

Alat 001

Duridwanvhost

PHP Inggris // [username], [password], //[hostname]:[port]/[DB service name] $c = oci_pconnect("[Username]", "[Password]", "//localhost:7341/DRCDB1"); $s = oci_parse($c, "SELECT 'Halo Penduduk Bumi!' FROM dual"); oci_execute($s); oci_fetch_all($s, $res); echo "

\n"
var_dump($res);
echo "

\n";
PHP Cianjur Indonesia (ID-CJR) // [pgunama], [katakunc], //[namahost]:[portna]/[DB nama layanan] $c = oci_pconnect("[Pgunama]", "[Katakunc]", "//duridwanhost:7341/DRCDB1"); $s = oci_parse($c, "SELECT 'Halo Penduduk Bumi!' FROM dual"); oci_execute($s); oci_fetch_all($s, $res); echo "

\n"
var_dump($res);
echo "

\n";

DUDI RIDWAN POPI SYAPI'AH

DRcjgTeA_AKSELELATOR

Alih Bahasa

DRMenuNavigasiBar

Kamis, 16 Januari 2025

Favikonku

Alat 000

Alat 002

Alat 001

Duridwanvhost

Kamis, 02 Januari 2025

drIkon Garasi

Belajar Bahasa C++

Posting Populer

Laporkan Penyalahgunaan

DRcjgLink

Duridwan TeA Google Arsip

Tampil Ful Skrin

Tampilan penuh layar

Halaman

MAIN GAME BISA SAMBIL SHOLAWAT/DZIKIR "الله الله الله" ????

Kami segera kembali...

Main Game Sambil Sholawat

DRcjg YouTube TeA

Abah Dadeng

jsrid

Online Apps

HUDHUD AT-TWITERI

Garasi