---
# System prepended metadata

title: Oracle 執行function 不 commit
tags: [ORACLE, SQL]

---

# Oracle 執行function 不 commit
###### tags: `SQL` `ORACLE`

```sql=
declare
 v boolean;
 begin
  v:=PK_FH.F_RP02(2019,'01','12');
 end;
 
 
 select* from G_F_FHRP02
```

執行完不要commit 直接select就會有
commit 就會清空
