随笔分类 -  database

sqlite
摘要：sqlite3 test.dbcreate table tb_test_self_type(int_type integer primary key, real_type real, text_type text);insert into tb_test_self_type values(1,3.1 阅读全文

posted @ 2020-05-27 22:17 阮減显 阅读(119) 评论(0) 推荐(0)

oracle 安装
摘要：groupadd dba groupadd oinstall useradd -g oinstall -G dba oracle passwd oracle mkdir -p /home/oracle/network/admin chown -R oracle:oinstall /home/oracle chmod -R 755 /home/oracle root用户下 xhost + su ... 阅读全文

posted @ 2019-02-13 09:03 阮減显 阅读(81) 评论(0) 推荐(0)

mysql c-api 预处理语句
摘要：stmt = mysql_stmt_init(mysql) mysql_stmt_prepare(stmt, "SELECT ?", strlen("SELECT ?")) mysql_stmt_bind_param(stmt, param_bind) mysql_stmt_execute(stmt) mysql_stmt_bind_result(stmt, result_bind) mys... 阅读全文

posted @ 2018-03-09 20:02 阮減显 阅读(258) 评论(0) 推荐(0)

oracle使用3DES加密
摘要：CREATE OR REPLACE PACKAGE dbc_cryptor IS SYSKEY VARCHAR2(16) := '0000000012345678'; SYSIV VARCHAR2(16) :=chr(0)||chr(0)||chr(0)||chr(0)||chr(0)||chr(0)||chr(0)||chr(0); FUNCTION encrypt_3des... 阅读全文

posted @ 2017-11-13 17:06 阮減显 阅读(560) 评论(0) 推荐(0)

导航