To truezerg(赵明宇):
1、ORACLE中不用AS,应该是SELECT field1 A from TableA
2、SQL SERVER中也不用=,该句的语法和ORACLE一样
3、ORACLE/SQL SERVER中的字符分隔符都是单引号
4、ORACLE中取当前日期用SYSDATE(包含时间)
SQL:
Select A=a From TableA
ORA:
Select a AS A From TableA
SQL:
With Query1 do
Begin
Sql.Close;
Sql.Clear;
Sql.Add('Select a From TableA Where b="'abc'"');
OPen;
End;
ORA:
With Query1 do
Begin
Sql.Close;
Sql.Clear;
//在ORA中将SQL下的双引号都改成两个单引号
Sql.Add('Select a From TableA Where b='''abc'''');
OPen;