Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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´¥·¢Æ÷ÈëÃÅ1 ´´½¨Ò»¸ö¼òµ¥µÄ´¥·¢Æ÷

´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ÀàËÆÓÚʼþº¯Êý£¬SQL Server™ ÔÊÐíΪ Insert¡¢Update¡¢Delete ´´½¨´¥·¢Æ÷£¬¼´µ±ÔÚ±íÖвåÈë¡¢¸üС¢É¾³ý¼Ç¼ʱ£¬´¥·¢Ò»¸ö»òһϵÁÐ T-SQLÓï¾ä¡£
´¥·¢Æ÷¿ÉÒÔÔÚ²éѯ·ÖÎöÆ÷Àï´´½¨£¬Ò²¿ÉÒÔÔÚ±íÃûÉϵãÓÒ¼ü->“ËùÓÐÈÎÎñ”->“¹ÜÀí´¥·¢Æ÷”À´´´½¨£¬²»¹ý¶¼ÊÇҪд T-SQL ......

Ò»¸öÌâÄ¿Éæ¼°µ½µÄ50¸ö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Ìõ¼Ç¼

ÈçºÎÓÃ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Ìõ
......

Auto process Cube with SQL Agent job

(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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ