他们的数据类型定义有所不同。
各个数据库都支持一些非标准的sql。举例,oracle插入timedate类型的数据,需要to_date('2002-08-01','yyyy-MM-dd')
各个数据库都支持一些非标准的sql。举例,oracle插入timedate类型的数据,需要to_date('2002-08-01','yyyy-MM-dd')
解决方案 »
- 有时候他会卡住在line = reader.readLine()) != null
- 如何把结果集传递给applet?
- j2se服务器可以接收多少个客户端?
- 求救~~~~~~~~~关于FTP审计
- 算法题:根据数组访问的次数排序,请教中??
- java应用程序中如何获取浏览器的代理信息(包括认证信息)?
- 大虾们,教教我这个新手,关于read()和readLine()给金!!!!!!!!!!!!!!!!!!!!!
- java里面有没有象MSDN一样的帮助系统啊???
- 难道高手区里的人就是高手?
- 小白求助,我这代码鼠标事件为什么没作用呢?
- 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])]