oracle瀹為獙浠ュ強绛旀�� - 鐧惧害鏂囧簱

鏂板缓

涓婁紶

棣栭〉

鍔╂墜

鏈�杩?/div>

璧勬枡搴?/div>

宸ュ叿

瀹為獙锛?/p>

 

SQL*Plus

鐨勪娇鐢ㄥ拰鍩烘湰

SELECT

璇�鍙�

 

瀹為獙鐩�鐨�

 

閫氳繃璇ュ疄楠屼娇瀛﹀憳鎺屾彙绠�鍗曟煡璇㈣��鍙ョ殑鍩烘湰浣跨敤鏂规硶浠ュ強鍒�鍚嶇殑鎸囧畾鏂规硶锛�

鑳藉�熷垱寤哄�?/p>

鎵ц��

SQL

鑴氭湰銆?/p>

 

瀹為獙瑕佹眰

 

锛堬紤锛?/p>

 

鎺屾彙

SQL*Plus

鐨勫熀鏈�浣跨�?/p>

 

锛堬紥锛?/p>

 

鎺屾彙

SELECT

璇�鍙ョ殑绠�鍗曠敤娉曘�?/p>

 

瀹為獙姝ラ��

 

锛堬紤锛?/p>

 

鐧诲綍鍒?/p>

SQL*Plus

锛屽垵濮嬬敤鎴峰悕涓猴細

SCOTT

锛屽彛浠や负

TIGER

銆?/p>

 

绛旓細

鎵撳紑

sql plus

锛?/p>

杈撳叆鐢ㄦ埛鍚嶅拰瀵嗙爜鐧婚檰锛?/p>

涔熷彲浠ヤ粠

dos

绐楀彛杈撳叆鍛戒护

sqlplus Scott/tiger

 

 

杩炴帴鏁版嵁搴?/p>

 

 

 

锛堬紥锛?/p>

 

鍒嗗埆鏄剧ず

EMP

銆?/p>

DETP

銆?/p>

SALGRADE

琛ㄧ粨鏋勶紝骞跺療鐪嬭〃涓�鐨勬暟鎹�銆?/p>

 

绛旓細

DESC emp; 

DESC dept; 

DESC salgrade; 

锛堬紦锛?/p>

 

鍒涘缓涓�涓�鏌ヨ�㈡樉绀烘瘡涓�闆囧憳鐨勫�撳悕銆佸伐浣溿�佸彈闆囨棩鏈熷強闆囧憳缂栧彿锛屽苟涓旇�佸皢闆囧憳缂�

鍙蜂綔涓虹��涓�鍒楁樉绀恒�傛渶鍚庡皢璇?/p>

SQL

璇�鍙ヤ繚瀛樻垚鏂囦�?/p>

p1q1.sql

锛屽苟鎵ц�岃�ヨ剼鏈�鏂囦欢銆?/p>

 

绛旓細

SELECT empno,ename,job,hiredate FROM emp; 

锛堬紨锛?/p>

 

灏嗚剼鏈�鏂囦�?/p>

p1q1.sql

璋冨彇鍒?/p>

SQL

缂撳啿鍖猴紝骞跺皢鍒楁爣棰樿�剧疆涓�

Emp 

#

锛?/p>

Employee

锛?

Job

鍙?/p>

Hire Date

锛屽皢璇?/p>

SQL

璇�鍙ヤ繚瀛樻垚鏂囦�?/p>

p1q2.sql

锛屾渶鍚庤繑鍥炴煡璇㈢粨鏋溿�?/p>

 

绛旓細

SELECT empno "Emp #",ename "Employee",job "Job",hiredate "Hire Date" FROM 

 

 

 

emp; 

鎬濊�冪粌涔犻��

 

锛戯紟

SQL*Plus

鍛戒护鏄�鐢ㄤ簬璁块棶鏁版嵁搴撶殑鍚楋�?/p>

 

绛旓細鍙�浠ヨ�块棶鏁版嵁搴撱�?/p>