Oracle basic questions

[nando]

Hello,

I'm starting to export my codes from mysql to oracle and have some questions:

1) Oracle query's are case sensitive?
select from table where name like 'A%'
is deferent of
select from table where name like 'a%'

2) Can I use my SQL Querys (used in mysql db) with oracle database? My query's are no complex, some uses two tables and simple "group by"

Tanks!

[Anon]

By default queries in Oracle are case sensitive. There are ways to achieve case insensitivity, but each way has its advantages and disadvantages.

Assuming that your SQL code doesn't utilize MySQL-specific syntax, then you should be able to port your SQL with minimal (if any) problems. Simple table joins and "group by" functionality should be easy to port. However, if your code does take advantage of MySQL-specific features, then expect to do some syntax tweaking.

-- Michael
Darkstreak Consulting
www.darkstreak.com

[Anon]

Yes it is case sensitive.

Simple queries SHOULD work. Why not post the most complex so we can say whether they will or not.