高分求解不同数据库(如SQL Server、Oracle等)中SQL语句的区别。可加分!!! 他们的数据类型定义有所不同。各个数据库都支持一些非标准的sql。举例,oracle插入timedate类型的数据,需要to_date('2002-08-01','yyyy-MM-dd') 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT statements语句:Oracle和Microsoft SQL Server用的SELECT语句的语法是类似的。ORACLE:SELECT [/*+ optimizer_hints*/] [ALL | DISTINCT] select_list[FROM{table_name | view_name | select_statement}][WHERE clause] [GROUP BY group_by_expression][HAVING search_condition][START WITH … CONNECT BY][{UNION | UNION ALL | INTERSECT |MINUS} SELECT …][ORDER BY clause][FOR UPDATE]SQL SERVER:SELECT select_list[INTO new_table_]FROM table_source[WHERE search_condition][ GROUP BY [ALL] group_by_expression [,…n] [ WITH { CUBE | ROLLUP } ][HAVING search_condition][ORDER BY order_expression [ASC | DESC] ] In addition:UNION Operator COMPUTE ClauseFOR BROWSE ClauseOPTION Clause INSERT语句Oracle和Microsoft SQL Server用的INSERT语句的语法是类似的。Oracle:INSERT INTO{table_name | view_name | select_statement} [(column_list)]{values_list | select_statement}Microsoft SQL SERVERINSERT [INTO] { table_name [ [AS] table_alias] WITH ( <table_hint_limited> […n]) | view_name [ [AS] table_alias] | rowset_function_limited } { [(column_list)] { VALUES ( { DEFAULT | NULL | expression }[,…n] ) | derived_table | execute_statement } } | DEFAULT VALUES UPDATE语句:Transact-SQL支持Oracle的UPDATE绝大多数语法Oracle:UPDATE{table_name | view_name | select_statement}SET [column_name(s) = {constant_value | expression | select_statement | column_list | variable_list}{where_statement}Microsoft SQL SERVERUPDATE { table_name [ [AS] table_alias] WITH ( <table_hint_limited> […n])view_name [ [AS] table_alias]| rowset_function_limited }SET {column_name = {expression | DEFAULT | NULL}| @variable = expression | @variable = column = expression } [,…n]{{[FROM {<table_source>} [,…n] ][WHERE <search_condition>] }| [WHERE CURRENT OF { { [GLOBAL] cursor_name } | cursor_variable_name} ] }[OPTION (<query_hint> [,…n] )] DELETE语句:Oracle:DELETE [FROM]{table_name | view_name | select_statement}[WHERE clause] Microsoft SQL SERVERDELETE [FROM ] { table_name [ [AS] table_alias] WITH ( <table_hint_limited> […n])| view_name [ [AS] table_alias]| rowset_function_limited }[ FROM {<table_source>} [,…n] ] [WHERE { <search_condition> | { [ CURRENT OF { { [ GLOBAL ] cursor_name } cursor_variable_name }] }][OPTION (<query_hint> [,…n])] Java的内存复制(主要是数组)效率比较 首尾质数 求concurrent 版本的LinkedHashmap 新手unicode问题,提问,谢谢 java中按照字母数字顺序输出 请问各位高手,哪里可以找到IBM viavoice引擎,或者买的话,哪里有买,急呀!!!!!!!!! 断网络和重新拨号 一个关于JAVA取ORACLE数据库中存储过程信息的问题 Struts2登录功能报错!求大神指点,在线等!! websphere的最新版本是多少?这分好拿哟!:) JFRAME大小设置问題 下面的方法访问数据库的列是null出错,怎样改进,谢谢!
Oracle和Microsoft SQL Server用的SELECT语句的语法是类似的。
ORACLE:
SELECT [/*+ optimizer_hints*/]
[ALL | DISTINCT] select_list
[FROM
{table_name | view_name | select_statement}]
[WHERE clause]
[GROUP BY group_by_expression]
[HAVING search_condition]
[START WITH … CONNECT BY]
[{UNION | UNION ALL | INTERSECT |
MINUS} SELECT …]
[ORDER BY clause]
[FOR UPDATE]SQL SERVER:
SELECT select_list
[INTO new_table_]
FROM table_source
[WHERE search_condition]
[ GROUP BY [ALL] group_by_expression [,…n]
[ WITH { CUBE | ROLLUP } ]
[HAVING search_condition]
[ORDER BY order_expression [ASC | DESC] ]
In addition:
UNION Operator
COMPUTE Clause
FOR BROWSE Clause
OPTION Clause
INSERT语句
Oracle和Microsoft SQL Server用的INSERT语句的语法是类似的。
Oracle:
INSERT INTO
{table_name | view_name | select_statement} [(column_list)]
{values_list | select_statement}Microsoft SQL SERVER
INSERT [INTO]
{
table_name [ [AS] table_alias] WITH ( <table_hint_limited> […n])
| view_name [ [AS] table_alias]
| rowset_function_limited
} { [(column_list)]
{ VALUES ( { DEFAULT
| NULL
| expression
}[,…n]
)
| derived_table
| execute_statement
}
}
| DEFAULT VALUES
UPDATE语句:
Transact-SQL支持Oracle的UPDATE绝大多数语法Oracle:
UPDATE
{table_name | view_name | select_statement}
SET [column_name(s) = {constant_value | expression | select_statement | column_list |
variable_list}
{where_statement}
Microsoft SQL SERVER
UPDATE
{
table_name [ [AS] table_alias] WITH ( <table_hint_limited> […n])
view_name [ [AS] table_alias]
| rowset_function_limited
}
SET
{column_name = {expression | DEFAULT | NULL}
| @variable = expression
| @variable = column = expression } [,…n]{{[FROM {<table_source>} [,…n] ][WHERE
<search_condition>] }
|
[WHERE CURRENT OF
{ { [GLOBAL] cursor_name } | cursor_variable_name}
] }
[OPTION (<query_hint> [,…n] )]
DELETE语句:
Oracle:
DELETE [FROM]
{table_name | view_name | select_statement}
[WHERE clause] Microsoft SQL SERVER
DELETE
[FROM ]
{
table_name [ [AS] table_alias] WITH ( <table_hint_limited> […n])
| view_name [ [AS] table_alias]
| rowset_function_limited
}[ FROM {<table_source>} [,…n] ]
[WHERE
{ <search_condition>
| { [ CURRENT OF
{
{ [ GLOBAL ] cursor_name }
cursor_variable_name
}
]
}
]
[OPTION (<query_hint> [,…n])]