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

Ö÷Á÷Êý¾Ý¿âMYSQL/MSSQL/ORACLE²âÊÔÊý¾Ý¿â½Å±¾´úÂë


/******************************************************************************/
/*
Ö÷Á÷Êý¾Ý¿âMYSQL/MSSQL/ORACLE²âÊÔÊý¾Ý¿â½Å±¾´úÂë
½Å±¾ÈÎÎñ:½¨Á¢4¸ö±í,Ìí¼ÓÖ÷¼ü,Íâ¼ü£¬²åÈëÊý¾Ý,½¨Á¢ÊÓͼ
ÔËÐл·¾³1:microsoft sqlserver 2000 ²éѯ·ÖÎöÆ÷
ÔËÐл·¾³2:mysql5.0 phpMyAdminÍøÒ³½çÃæ
ÔËÐл·¾³3:oracle 9i SQL*PLUSÃüÁîÐнçÃæ
author£ºchinayaosir
blog:   http://blog.csdn.net/chinayaosir/
QQ:    44633197
ÉùÃ÷£ºÑϽûÆäËüÍøÕ¾²»¾­¹ý×÷ÕßchinayaosirͬÒâÈÎÒâתÔØ
*/
/******************************************************************************/
/*script test ok with microsoft sqlserver 2000 ²éѯ·ÖÎöÆ÷ */
/******************************************************************************/
/*DB:MSSQL2000 SCRIPT*/
/*0.drop table list*/
    drop  table Employee;
    drop  table Department;
    drop  table Post;
    drop  table Account;
/*********************************************************/
/*DB:MSSQL2000 SCRIPT*/
/*1.create all table*/
create table Account(
    oid     int  not null,
    username varchar(30) not null,
    password varchar(10)  null,
    invalid    varchar(1)  null           
);
create table bab.Post(
    /*oid     int identity(1,1) not null primary key,*/
    oid     int  not null,
    postName varchar(30) not null
);
create table Department(
    oid     int  not null,
    deptName varchar(30) not null,
    parentid  int  null,
    manager   varchar(30)  null,
    email     varchar(30)  null
);
create table Employee(
    oid    


Ïà¹ØÎĵµ£º

Oracle¼ÆËãʱ¼ä²î±í´ïʽ

 
ÓÐÁ½¸öÈÕÆÚÊý¾ÝSTART_DATE£¬END_DATE£¬ÓûµÃµ½ÕâÁ½¸öÈÕÆÚµÄʱ¼ä²î£¨ÒÔÌ죬Сʱ£¬·ÖÖÓ£¬Ã룬ºÁÃ룩£º
Ì죺
ROUND(TO_NUMBER(END_DATE - START_DATE))
Сʱ£º
ROUND(TO_NUMBER(END_DATE - START_DATE) * 24)
ᅅ
ROUND(TO_NUMBER(END_DATE - START_DATE) * 24 * 60)
Ã룺
ROUND(TO_NUMBER(END_DATE - START ......

Oracle³£ÓÃÈÕÆÚÊý¾Ý¸ñʽ

Ò»¡¢ ³£ÓÃÈÕÆÚÊý¾Ý¸ñʽ
 
1.Y»òYY»òYYY ÄêµÄ×îºóһ룬Á½Î»»òÈýλ
SQL> Select to_char(sysdate,'Y') from dual;
TO_CHAR(SYSDATE,'Y')
--------------------
7
SQL> Select to_char(sysdate,'YY') from dual;
TO_CHAR(SYSDATE,'YY')
---------------------
07
SQL> Select to_char(sysdate,'YYY ......

SAPÓëORACLEµÄÇø±ð·ÖÎö¼°¶Ô±È

SAPÓëORACLEµÄÇø±ð·ÖÎö¼°¶Ô±È[ת]
Ä¿Ç°ÔÚERPÒµ½çÖдæÔÚÁ½¸ö¾Þãµ——SAP µÄ ECC ¼° ORACLE µÄ EBS £¬ÕâÁ½¸ö´óÐÍERP½â¾ö·½°¸¼¸ºõÕ¼¾ÝÁËÊÀ½çÉϸ÷¸ö²»Í¬ÐÐÒµµÄ´óÐÍÆóÒµµÄÐÅϢϵͳÊг¡£¬ËùÒÔÕÆÎÕÁ½ÕßÆäÒ»µÄÈ˱ã¿É»ñµÃ´óÐ͹ÜÀíÐÅϢϵͳҵ½çÖеİë±Ú½­É½¶ø²»¶¯£¬ÎÞÂÛÄãÊÇ´ÓÊÂSAP»òORACLE £¬Á˽âÁ½ÕßµÄÇø±ðÊǷdz£ÓбØÒª ......

php ½âÎö excel ´æ´¢µ½ mysql ÂÒÂë


±àÂëÊǸöºÜ»ù´¡µÄÎÊÌ⣬ҲÊÇ´ó¼ÒºÜÈÝÒ׺öÂÔµÄÎÊÌ⣬д´úÂë֮ǰ¶à¶à¿¼ÂÇ£¬ÒÔºó»áÉٺܶàÂé·³¡£
PHP·¢Õ¹Á˲»ÉÙ£¬ÏÖÔÚpearÓÃÆðÀ´ºÜ·½±ã£¬ÆäÖоÍÓÐÏà¹ØµÄclassÀ´¶ÁÈ¡ExcelÎļþÀïÃæµÄÄÚÈÝ£¬Èç¹û²»ÏëʹÓÃpearµÄ»°£¬¿ÉÒÔ¿¼ÂÇʹÓÃexcel_class.php£¬googleһϣ¬¿ÉÒÔÕÒµ½Õâ¸öclassµÄsource codeÏÂÔØ£¬Ò²ÄÜÕÒµ½»ù±¾µÄexample c ......

php mysql ²ÉÓà utf 8 µÄÅäÖÃ

1¡¢ÔÚÅäÖÃmysqlʵÀýµÄÓïÑÔÑ¡Ïîʱ£¬Ñ¡Ôñutf-8
2¡¢ÔÚhtml,phpÒ³ÃæÖÐ ¼ÓÉÏ <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />£¬Èç¹û²»ÐÐÔÙÔÚ phpÎļþ Æðʼ´¦¼Ó header("Content-Type:text/html;charset=utf-8");
3¡¢ÔÚphpÖÐ×öÊý¾Ý¿âÁ¬½Óʱ£¬ÎÒÓõÄʱpdoµÄÐÎʽ£¬Ë ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ