I need to get a fast answer to the following questions, please help!
- Searching varchar2-fields is case-sensitive:
...where field LIKE '%text%' will not return 'TEXT...'
I would need case-insensitive search, what can I do?
- MSSQL-Server allows to use [fieldname] if the fieldname is a reseved
keyword.
What can be used in Oracle-SQL??
- Dateformat: yyyy-mm-dd seems to be not supported.
I need to enter dd.mm.yy, but this maybe is a regional setting of my
computer.
Any suggestions how to use date-formats (maybe
regional-setting-independent)??
- I search for auto-values (self-increasing) for the primary-key-field.
I could not find such a setting. How can I create auto-incrementing fields
in Oracle?
- Is there no boolean-field in orcale?
-Do I have to use number (LONG)?
Please help
Alexander
Received on Mon Oct 01 2001 - 06:34:41 CDT