kramer

摘要： 这个命令可以以树形结构列出进程信息。可以清楚的看清父进程子进程直接的关系。可笑我之前还以为所有的命令参数都是带有一个中划线的。 不过，这里列出的进程好像不全。应该仔细的看看ps 的命令。[root@aaaa aaaaaaaa]# ps f PID TTY STAT TIME COMMAND24724 pts/13 S 0:00 su - sysadm225054 pts/13 S 0:00 \_ -bash23132 pts/13 S 0:00 \_ su - pmtsadm14773 pts/5 S 0:... 阅读全文

摘要： Solution 1:Prior toOracle 11g, sequence assignment to a number variable could be done through a SELECT statement only in trigger, which requires context switching from PL/SQL engine to SQL engine. So we need to create before insert trigger for each row, and assign sequence new value to the column us 阅读全文