PL/SQL¼¯½õ
--ÉèÖÃÊý¾Ý¿âÊä³ö£¬Ä¬ÈÏΪ¹Ø±Õ£¬Ã¿´Îдò¿ª´°¿Ú¶¼ÒªÖØÐÂÉèÖÃ
set serveroutput on
--µ÷Óà °ü º¯Êý ²ÎÊý
execute dbms_output.put_line('hello world');
--»òÕßÓÃcallµ÷Óã¬Ï൱ÓÚjavaÖеĵ÷ÊÔ³ÌÐò´ò×®
call dbms_output.put_line('hello world');
--plÓï¾ä¿éÊÇpl/sqlÀï×îСµÄ±à³Ì¿é£¬ÆäÖпÉÒÔÔÙǶÌ×begin end
begin
dbms_output.put_line('Hello World');
dbms_output.put_line('2*3='||(2*3));
dbms_output.put_line('what''s');
end;
--ÈçºÎÉùÃ÷±äÁ¿£¬ËùÓбäÁ¿±ØÐëÔÙdeclareÖÐÉùÃ÷£¬³ÌÐòÖв»ÔÊÐíÉùÃ÷
--ûÓгõʼ»¯µÄ±äÁ¿Ä¬ÈÏֵΪnull£¬ÆÁÄ»ÉÏnullÊÇ¿´²»¼ûµÄ£¬ÃüÃûÏ°¹ß£ºÒ»°ã±äÁ¿ÒÔv_¿ªÍ·
--×¢ÒânumberÒ²ÄÜ´æСÊý£¬×38룬ËùÒÔÒÔºó½¨ÒéÕûÊý¶¼ÓÃbinary_integer´æ
--longÊÇ×Ö·ûÀàÐÍ£¬booleanÀàÐͲ¹ÄÜ´òÓ¡
--±ê×¼±äÁ¿ÀàÐÍ£ºÊý×Ö£¬×Ö·û£¬Ê±¼ä£¬²¼¶û
declare
v_number1 number ;
v_number2 number(3,2) ;
v_number3 binary_integer :=1;
v_name varchar2(20) :='kettas';
v_date date :=sysdate;
v_long long :='ni hao';
v_b boolean := true;
begin
if (v_number1 is null) then
dbms_output.put_line( 'hello');
end if;
dbms_output.put_line(v_number1);
dbms_output.put_line(v_number2);
dbms_output.put_line(v_number3);
dbms_output.put_line(v_name);
dbms_output.put_line(v_date);
dbms_output.put_line(v_long);
--dbms_output.put_line(v_b);
end;
/
--×éºÏÀàÐÍ£ºrecord table
--recordÀàÐÍ×î³£Óã¬ÉùÃ÷µÄʱºò¿ÉÒÔ¼Ónot null£¬µ«±ØÐë¸ø³õʼֵ
--Èç¹ûrecordÀàÐÍÒ»Ö¿ÉÒÔÏ໥¸³Öµ£¬Èç¹ûÀàÐͲ»Í¬£¬ÀïÃæµÄ×Ö¶ÎÇ¡ºÃÏàͬ£¬²»ÄÜ»¥Ïำֵ
declare
type t_first is record(
id number(3),
name varchar2(20)
);
v_first t_first;
begin
v_first.
Ïà¹ØÎĵµ£º
´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ÀàËÆÓÚʼþº¯Êý£¬SQL Server™ ÔÊÐíΪ Insert¡¢Update¡¢Delete ´´½¨´¥·¢Æ÷£¬¼´µ±ÔÚ±íÖвåÈë¡¢¸üС¢É¾³ý¼Ç¼ʱ£¬´¥·¢Ò»¸ö»òһϵÁÐ T-SQLÓï¾ä¡£
´¥·¢Æ÷¿ÉÒÔÔÚ²éѯ·ÖÎöÆ÷Àï´´½¨£¬Ò²¿ÉÒÔÔÚ±íÃûÉϵãÓÒ¼ü->“ËùÓÐÈÎÎñ”->“¹ÜÀí´¥·¢Æ÷”À´´´½¨£¬²»¹ý¶¼ÊÇҪд T-SQL ......
תÔØ˵Ã÷£º¸øÕýÔÚ×öϵͳºÍÏë×öϵͳµÄÈË£¬SQL²©´ó¾«ÉÄãÃÇ»áÓõ½µÄ¡£——mAysWINd
Ò»¸öÌâÄ¿Éæ¼°µ½µÄ50¸öSqlÓï¾ä
Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµ ......
ÈçºÎÓÃSQLÓïÑÔÑ¡Ôñ±íÖеĵڶþÌõµÚÈýÌõµÚNÌõ¼Ç¼
--IDΪΨһÐÔ¾ÍÐÐÁË
select top 1 * from table
where ID not in(select top 1 ID from table)--µÚ2Ìõ
select top 1 * from table
where ID not in(select top 2 ID from table)--µÚ3Ìõ
......
(1) Connect to the Analysis server, select the database which we want it to be automatically processed. Right click on this database, choose ‘Process’:
(2) In the opening ‘Process database’ form, click the ‘Script Action ......