SQL> SELECT COUNT(1) FROM ALL_OBJECTS; COUNT(1)
---------
25504SQL> SELECT SUM(ID) FROM(SELECT ROWNUM ID FROM ALL_OBJECTS WHERE ROWNUM<101); SUM(ID)
---------
5050SQL>
---------
25504SQL> SELECT SUM(ID) FROM(SELECT ROWNUM ID FROM ALL_OBJECTS WHERE ROWNUM<101); SUM(ID)
---------
5050SQL>
FOR v_Counter IN 1..100 LOOP
LI_NUM= LI_NUM + v_Counter;
END LOOP;
END;
/
2 LI_NUM NUMBER;
3 BEGIN
4 LI_NUM:=0;
5 FOR v_Counter IN 1..100 LOOP
6 LI_NUM := LI_NUM + v_Counter;
7 END LOOP;
8 DBMS_OUTPUT.PUT_LINE(TO_CHAR(LI_NUM));
9 END;
10 /
5050PL/SQL 过程已成功完成。SQL>
并显示从第10行第10列起显示其结果”不懂什么意思
问问:
设有一下关系:
SSC(SNO,CNO,CNAME,SCORE,WRITER)其中SNO为学号,CNO为课号,CNAME为课程名,SCORE为分数,WRITER为书的作者。
1. 指出关系中的完全函数依赖 部分函数依赖 传递函数依赖?
2. 将SSC关系分解为3NF?