godror基于ODPI-C的 oracle golang 驱动使用

package main

​

import (

"database/sql"

"flag"

"fmt"

​

_ "github.com/godror/godror"

​

"log"

)

​

var (

username  = flag.String("uname", "scott", "oracle username")

password  = flag.String("password", "tiger", "oracle password")

oraclehost = flag.String("oraclehost", "dbhost", "oracle database host")

oracleport = flag.Int("oracleport", 1521, "oracle database port")

dbname   = flag.String("dbname", "orclpdb1", "oracle database name")

)

​

func main() {

flag.Parse()

osqlInfo := fmt.Sprintf("%s/%s@%s:%d/%s", *username, *password, *oraclehost, *oracleport, *dbname)

db, err := sql.Open("godror", osqlInfo)

if err != nil {

log.Fatalf("connect oracle db error: %s:", err.Error())

}

rows, err := db.Query("select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') AS name from dual")

if err != nil {

fmt.Println("exec query error:", err.Error())

}

for rows.Next() {

var name string

rows.Scan(&name)

fmt.Println("fetch item:")

fmt.Println(name)

}

}