Some of the differences between Oracle and Sybase

Source: Internet
Author: User
Tags sybase oracle substr

Oracle table names, field names are case-insensitive, Sybase is strictly differentiated

2.Oracle To_char ()/to_date ()---sybase convert ()
--oracle:to_char (sysdate, ' dd-mm-yyyy Day '), To_date (String,format)
--sybase:convert (char (15), date, 108), CONVERT (datetime,string,108)
--with Sybase convert at the end of the third parameter introduction
3.Oracle substr ()--Sybase's substring ()

4.Oracle NVL ()--Sybase's IsNull ()

5.Oracle Fetch system Time sysdate--Sybase's GETDATE ()

6.Oracle Decode--Sybase's case and then
--oracle:select Decode (PARAM,NULL,RESULTA,RESULTB) from Res;
--sybase:select case where param is null and resulta else RESULTB end from Res;

7. External connection
--oracle:select * from TableA A, TableB b where a.id=b.id (+);
--sybase:select * from TableA A,tableb b where a.id*=b.id;

8.insert method
--oracle:insert into TableA (SELECT * from TableB where tableb.id= "");
--sybase:insert into TableA (id,name,age) (SELECT * from TableB where tableb.id= ""); Insert table must clear column name

Attached: Sybase convert the third parameter describes
That's the format you want to save when you convert your time into string lines.
101 USA Mm/dd/yy
102 ANSI YY.MM.DD
103 British/french Dd/mm/yy
104 German Dd.mm.yy
Italian Dd-mm-yy
106-dd Mon yy
107-mon DD, yy
108-hh:mm:ss
109 (*) Default + milliseconds mon dd yyyy hh:mi:ss:mmmAM (or PM)
Mm-dd-yy USA
111 JAPAN YY/MM/DD
ISO YYMMDD
113 (*) Europe default + milliseconds dd Mon yyyy hh:mm:ss:mmm (24h)
114-hh:mi:ss:mmm (24h)
(*) ODBC canonical yyyy-mm-dd Hh:mi:ss (24h)
121 (*) ODBC canonical (with milliseconds) Yyyy-mm-dd hh:mi:ss.mmm (24h)
126 (* *) ISO8601 yyyy-mm-dd Thh:mm:ss:mmm (no spaces)
130* Kuwaiti dd Mon yyyy hh:mi:ss:mmmAM
131* Kuwaiti Dd/mm/yy Hh:mi:ss:mmmAM

This article is from the "unrestrained" blog, please be sure to keep this source http://shaotao.blog.51cto.com/7606729/1617496

Some of the differences between Oracle and Sybase

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.