Answer Posted / shrikant
Hi,
Yes Tulsi is right.
Execute the below queries & you will see the diff clearly -
SELECT instr('hello','e') FROM dual
SELECT substr('hello',2,3) FROM dual
| Is This Answer Correct ? | 34 Yes | 4 No |
Post New Answer View All Answers
Which join is like an inner join?
Explain autonomous transaction.
What is a memo field?
What is a schema sql?
How do you delete a table?
what are the type of locks ? : Sql dba
How to combine two stored procedures in sql?
Which is faster count (*) or count 1?
what are string data types? : Sql dba
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
what are all types of user defined functions? : Sql dba
Explain the difference in execution of triggers and stored procedures?
What is the main reason behind using an index?
How does postgresql compare to oracle/db2/ms sql server/informix?
Define join and name different types of joins?