SELECT ENAME, position('A' in ename)"#A" , position('E' in ename)"#E" from emp
SELECT ENAME, INSTR(ENAME,'A')"#A" , INSTR(ename,'E')"#E" from emp
POSTGRESQL
SELECT ENAME, position('A' in ename)"#A" , position('E' in ename)"#E" from emp
| SQL_INSTR_POSITION2 |
ORACLE
POSTGRESQL
|
| row : 2 |
| ORACLE: Note the position /INSTR of "A" or "E" in ename object
of emp table.
|
| PostgreSQL
|
| MYSQL
|