Ö÷Á÷Êý¾Ý¿â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
Ïà¹ØÎĵµ£º
ÓÐÁ½¸öÈÕÆÚÊý¾Ý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 ......
Ò»¡¢ ³£ÓÃÈÕÆÚÊý¾Ý¸ñʽ
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µÄÇø±ð·ÖÎö¼°¶Ô±È[ת]
Ä¿Ç°ÔÚERPÒµ½çÖдæÔÚÁ½¸ö¾Þãµ——SAP µÄ ECC ¼° ORACLE µÄ EBS £¬ÕâÁ½¸ö´óÐÍERP½â¾ö·½°¸¼¸ºõÕ¼¾ÝÁËÊÀ½çÉϸ÷¸ö²»Í¬ÐÐÒµµÄ´óÐÍÆóÒµµÄÐÅϢϵͳÊг¡£¬ËùÒÔÕÆÎÕÁ½ÕßÆäÒ»µÄÈ˱ã¿É»ñµÃ´óÐ͹ÜÀíÐÅϢϵͳҵ½çÖеİë±Ú½É½¶ø²»¶¯£¬ÎÞÂÛÄãÊÇ´ÓÊÂSAP»òORACLE £¬Á˽âÁ½ÕßµÄÇø±ðÊǷdz£ÓбØÒª ......
±àÂëÊǸöºÜ»ù´¡µÄÎÊÌ⣬ҲÊÇ´ó¼ÒºÜÈÝÒ׺öÂÔµÄÎÊÌ⣬д´úÂë֮ǰ¶à¶à¿¼ÂÇ£¬ÒÔºó»áÉٺܶàÂé·³¡£
PHP·¢Õ¹Á˲»ÉÙ£¬ÏÖÔÚpearÓÃÆðÀ´ºÜ·½±ã£¬ÆäÖоÍÓÐÏà¹ØµÄclassÀ´¶ÁÈ¡ExcelÎļþÀïÃæµÄÄÚÈÝ£¬Èç¹û²»ÏëʹÓÃpearµÄ»°£¬¿ÉÒÔ¿¼ÂÇʹÓÃexcel_class.php£¬googleһϣ¬¿ÉÒÔÕÒµ½Õâ¸öclassµÄsource codeÏÂÔØ£¬Ò²ÄÜÕÒµ½»ù±¾µÄexample c ......
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µÄÐÎʽ£¬Ë ......