The query is as follows:
select * from my_table where (rowid,0) in (select rowid, mod(rownum,n) from my_table )
no salary should be 25x higher than the lowest salary
-
This is common sense How to enforce this in a recent Oracle version? create
assertion x25 check (not exists(select * from emp e where sal*25<any(select
sal...
2 days ago

No comments:
Post a Comment