数据库
文章平均质量分 60
Cindy_Chi
good good study , day day up (●'◡'●)
THE DOG OF MY PROFILE NAME IS MONEY. HE IS A VERY CRAZY BOY NOW, EVER THOUGH I THINK HE IS A LOVELY GIRL BEFORE. HAHA .BY THE WAY, HE LIKE EATING EVERYTHING !! (HIS MASTER WANTS ME TO INTRODUCE HIM TO EVERY ONE. I TRY DO TO LIKE THAT. LOL)
展开
-
sql执行时间分(ave_time)
SELECT a.* FROM (SELECT v.SQL_TEXT, v.sql_fulltext, v.FIRST_LOAD_TIME, v.last_load_time, v.elapsed_time, v.cpu_time, v.disk_reads, v...原创 2019-11-22 11:04:08 · 433 阅读 · 0 评论 -
oracle中number数据类型简单明了解释
NUMBER (p,s)p和s范围:p 1-38s -84-127number(p,s),s大于0,表示有效位最大为p,小数位最多为s,小数点右边s位置开始四舍五入,若s>p,小数点右侧至少有s-p个0填充(必须从小数点处开始并连续)。举例:number(2,1) 有效位最大为2,小数点后最多保留1位:存1.115 得1.2存1.11 的1.1存1 得1存0.0...原创 2019-11-22 10:58:32 · 1047 阅读 · 0 评论 -
java中代码块的理解
public class Demo1{ static{ System.out.println("我爱java,我要学习"); } public static void main(String[] args) { { int a=14; System.out.println(a); ...原创 2018-08-07 16:31:50 · 247 阅读 · 0 评论 -
关于栈方法和反射的理解
import java.lang.reflect.InvocationTargetException;public class LegacyStackWalk { public static void main(String[] args) { m1(); } public static void m1() { m2(); ...原创 2018-08-07 15:24:54 · 160 阅读 · 0 评论 -
ORACLE ORA-01653: unable to extend table 的错误(转)转载▼
ORACLE ORA-01653: unable to extend table的错误今天用PL SQL Developer往oracle数据库中导入数据时,突然报错,只能终止,错误的具体内容如下:ORA-01653: unable to extend table USER_DATA.JKHDFXJL by 128 in tablespace MSMS大概意思是说USER_DATA表...翻译 2019-09-25 10:27:44 · 221 阅读 · 0 评论 -
oracle错误ORA-00054: resource busy and acquire with NOWAIT sp
Oracle杀死锁进程先查看哪些表被锁住了:1、获得sidselect b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b whereb.object_id = a.object_id;2、获得sid...翻译 2019-09-25 10:29:29 · 277 阅读 · 0 评论