Oracle Database Discussions

I've been using oracle for a year now after coming from various open source databases (sqlite, mysql, postgres), and although i've been able to get everything working eventually there are a number of features that I miss from the other dbs. Take a quick peek at my list and tell me if you think any of these features have been or will be implemented in a future version (i'm currently on 10g)

- no limit statement, and no replacement for it either, rownum doesn't give you the same functionality without having to wrap your statement in a subselect
- no offset
- can't limit inserts, updates, or deletes
- can't use aliases in group by statements, in the where clause etc
- sequences are overly complex for the majority of cases, a simple default sequence (i.e. an auto increment sequence flag could fix this)
- searches are case-sensitive (most of the time, especially for information systems you always want case-insensitive), disabling case-sensitivity leads to woefull performance and issues with indexes etc
- mysql's replace into is a much simpler version of merge
- 30 Characters for table, view or sequence names is far too small, I find i have to abbreviate table names all the time.

it would be great if we could get some of these features into oracle.