ITPub博客

locale -m 查看字符集locale -a 查看系统支持的locale设置hal

Dr. Codd formally presented his new relational model in a landmark work titled “A Relational Model of Data for Large Shared Databanks” in June 1970.1 He based his new model on two branches of mathem...

SQL> select dname from dept 2 where exists(select * from emp where deptno=dept.deptno) 3 /DNAME--------------RESEARCHSALESACCOUNTINGSQL> select distinct d.dname from dept d, emp e 2 where d.dept...

SQL> conn scott/tiger已连接。SQL> select dname from dept2 where not exists(select * from emp where deptno=dept.deptno)3 /DNAME--------------OPERATIONSSQL> select d.dname from dept d left outer join em...

SQL> conn scott/tiger已连接。SQL> select ename,sal from emp;ENAME SAL---------- ----------SMITH 800ALLEN 1600WARD 1250JONES 2975MARTIN 1250BLAKE 2850CLARK 2450SCOTT 3000KING 4000TURNER 1500ADAMS 1100J...

下载rlwrap的rpm包：rlwrap-0.18-1.i386.rpm以root帐号安装：rpm -ivh rlwrap rlwrap-0.18-1.i386.rpm启动SQL*Plus时，使用$ rlwrap sqlplus scott/tiger或者在oracle用户的.bashrc中设置alias：alias sqlplus="rlwr...

在Linux中，SQL*Plus不支持上、下方向键回显命令，也不支持左、右方向键移动光标，我们可以通过安装下面三个软件改变这种状况。 Term-Readline-Gnu，下载地址：http://search.cpan.org/dist/Term-ReadLine-GnuIO-Tty...

重装VMware上的操作系统，设置iso文件时，注意下面的Virtual device node要选择ide 0:0 CD-ROM-1，否则，依然从原有的操作系统启动，不能启动iso安装光盘。

安装centOS 5时，要注意选择以下安装选项：Select the Development -> Development Libraries, Development Tools and Legacy Software Development package groups.Under the Base System group, make sure you sel...

[oracle@redhat ~]$ cat sqlvalue#!/bin/bashVALUE=`sqlplus -s scott/tiger <<ENDset pagesize 0 feedback off verify off heading off echo offselect count(deptno) from dept;exit;END`echo ""$VALUE" rows retu...

Ctrl+L：刷新屏幕，相当于clear命令的效果。Shift+PgOn或Shift+PgUp：使得终端内容上下移动，每次移动一页，也可以使用Ctrl+PgOn或Ctrl+PgUp连续移动。显卡的内存决定可以回滚多少内容。Ctrl+A：使得光标移至行首Ctr...

编辑grub：其中的kernel /boot/vmlinuz-xxxxx ro root=LABEL=/1 rhgb quiet 改为：kernel /boot/vmlinuz-xxxxx ro root=LABEL=/1 rhgb quiet linux init=/bin/bash按b键启动系统，这时不需要输入密码。运行下面的命...

tune2fs -l

loin之前：/etc/issue，/etc/issue.netlogin之后：/etc/motd

方法1：修改/etc/login.defs，最后一行，CREATE_HOME no改为CREATE_HOME yes。方法2：执行useradd时，附加 -m选项。

# make mrproper # make menuconfig # make modules# make modules_install# make install

[ ]：通配符不起作用，[[ ]]会展开通配符。[root@redhat etc]# name=law[root@redhat etc]# echo $namelaw[root@redhat etc]# [[ $name = [Ll]aw ]][root@redhat etc]# echo $?0[root@redhat etc]# [ $name = [Ll]aw...

logrotate -v /ect/logrotate.conf：日志文件轮替，空文件不会发生轮替。logtotate -vf /etc/logrotate.conf：强制进行日志文件轮替-v选项使得用户可以在终端看到命令执行的过程。...

Install Oracle On Redhat

[oracle@redhat ~]$ cat test.sh#!/bin/bashSYSTEM_CONNECT=system/oraclesqlplus -s /nolog <<!!set line 200set feedback offcolumn file_name format a50connect $SYSTEM_CONNECT;select file_name from dba_data...