作者:本人xiao13 | 来源:互联网 | 2023-07-21 15:46
本文由编程笔记#小编为大家整理,主要介绍了markdown Oracle Notes相关的知识,希望对你有一定的参考价值。
## Date Fields
```
SELECT
*
FROM
POLICY
WHERE
TRUNC (t0.ISSUE_DATE) = TO_DATE('19032019', 'ddmmyyyy') OR
TRUNC (t0.ISSUE_DATE) = TRUNC(SYSDATE)
-- EF Version :
where p.IssueDate == DbFunctions.TruncateTime(DateTime.Today)
UPDATE POLICY
SET START_DATE = TO_DATE('08082019', 'ddmmyyyy')
WHERE
ID = 8227631;
```
## Fetch first 100 Rows
```
SELECT *
FROM POLICY
FETCH NEXT 100 ROWS ONLY
```