ora-00904 "CNT' invalid identifer
select claim_header_sid, count(*) cnt from ad_clm_hdr_condition group by claim_header_sid having cnt =1;
is there any way to avoid this error other than using inlineview
Truncate is a DDL Command where as Delete is a DML Command.
Both will delete data from table, but what is the difference between these below statements
truncate table <table_name> ??
delete from <table_name> ??
The first command cannot be …
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…