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 |
What do you understand by a database object? Can you list a few of them?
How do I manually uninstall oracle client?
create one table to capture an employee details with a primary key.
What are triggers in oracle?
What are the Limitations of a CHECK Constraint ?
What is a Data File ?
Does oracle database need java?
what is cartesian product?
How to get a list of all user accounts in the database?
How to import one table back from a dump file?
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
What is meant by recursive hints ?