`
文章列表

oracle导出表

导出表 exp scott/tiger@orcl file= e:\datanewsmgnt.dmp tables=(dept)  

gbase存储过程

  DELIMITER $$ DROP PROCEDURE IF EXISTS getRecord $$ CREATE PROCEDURE getRecord ( IN in_id INTEGER, OUT out_name VARCHAR(20), OUT out_age INTEGER) BEGIN SELECT name, age INTO out_name, out_age FROM Student where id = in_id; END $$ DELIMITER ;  
PowerDesigner连接数据库生成物理模型 1配置数据源 首先配置数据源      安装mysql-connector-odbc-3.51.28-win32.msi         2PowerDesigner配置         file-reverse engineer-datebase   

负载均衡

    博客分类:
  • Java
nginxlvs
在ue中,把字符替换为加车  

oracle存储过程

例1 CREATE OR REPLACE PROCEDURE proaaa IS BEGIN DBMS_OUTPUT.PUT_LINE('Hello World!'); END; /  在SQLPLUS下面运行 SQL> exec proaaa; Hello World! PL/SQL procedure successfully completed   例2 CREATE OR REPLACE PROCEDURE ddd(param1 IN VARCHAR2) IS BEGIN DBMS_OUTPUT.PUT_LINE('HELLO' || ...

oracle rowid与rownum

oracle rowid与rownum   SQL> select rownum,rowid from student; ROWNUM ROWID ---------- -------------------------------------------------------------------------------- 1 AAASkLAABAAAVqpAAA 2 AAASkLAABAAAVqpAAB  rownum rownum是个伪列,查询的时候除非特别指定,否则不会显示。 rowid: 在记录创建时就生成了, ...
先解锁,再加密码。   SQL> ALTER USER HR ACCOUNT UNLOCK identified by Hzx; User altered       identified by Hzx;加密码 ALTER USER HR ACCOUNT UNLOCK 解锁

oracle数据字典

  http://www.cnblogs.com/BradMiller/archive/2011/07/10/2102449.html 1.概念数据字典是oracle数据库用来存贮数据库结构信息的地方。数据字典是用来描述数据库数据的组织方式的,由表和视图组成。数据字典由脚本$oracle_home/rdbms/admin/catalog.sql ...
任务文件 [loader] disp_server=192.168.80.***:6666 file_list=/mppdata/datedemo.txt table_name=datedemo db_user=root db_name=bigdata format=0 delimiter=',' socket=/tmp/gbase_8a_5050.sock extra_loader_args=--parallel=12 --table_fields=' atime date "%Y-%m-%d",btime date "%Y-%m-% ...

linux expr

#!/bin/bash # 1+2+3+...+100 sum=0 for ((i=1; i<=100; i++)) do sum=$(expr $sum + $i); done echo $sum   

linux if_else

linux if_else #!/bin/bash read -p "input:" yn if [ $yn == 'y' ]; then echo "yes" exit 0 fi if [ $yn == 'n' ]; then echo "no" exit 0 fi  if_elif_else_fi #!/bin/bash read -p "input:" yn if [ $yn == 'y' ]; then echo "yes" ex ...
linux判断文件是否存在 test -e filename && echo "yes" || echo "not"   如果filename文件存在,则打印yes,如果不存在,则打印not    

linux case例子

代码: #!/bin/bash read -n1 -p "input:" name case $name in y) echo "good";; n) echo "bad";; *) echo "my god";; esac exit 0   结果    

linux read命令

代码 #!/bin/bash if read -t 5 -p "input name:" name then echo "hello,$name good." else echo "too slow." fi exit 0 ...
Global site tag (gtag.js) - Google Analytics