What is difference between SUBSTR and INSTR?
Answer / parthasarathi
substr is used to get part of a string, instr is used to get particular string's position.
syntax of substr:-
substr(string,from which character we want,[how many characters we want])
syntax of instr:-
instr(string,'character')
Is This Answer Correct ? | 0 Yes | 0 No |
Which environment variables are absolutely critical in order to run the OUI?
What is a Data File ?
What are the attributes of cursor?
How to define a data source name (dsn) in odbc manager?
How to connect to the server with user account: sys?
What is ordinary table in oracle?
What are the various oracle database objects?
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to assign values to variables?
What are the factors causing the reparsing of SQL statements in SGA?
What is control file used for?