Mayank Khurrana
Reputation: 15
How to locate a index in a column value
How to locate a index in a column value
For example:
Database : Oracle
INSTR('-',AEND_NATIVE_EMS_NAME)
I need to find the index of first occurrence of - in column AEND_NATIVE_EMS_NAME
For MySql DB I was using
LOCATE('-', l.AEND_NATIVE_EMS_NAME)
which is working fine for me.
Please help me out with oracle
Upvotes: 0
Views: 40
Answers (1)
Related Questions
- How to search particular value from column
- Use an index in a SELECT statement in Oracle
- Indexing for the columns in ORACLE
- Select columns of table index
- USING index clause
- Find a string in a specific table
- Find columns which are indexed in a given table
- Show me the index on the table in Oracle
- Index in part of a column in oracle?
- How do you detect if there is an index for a specific column on a table in Oracle?