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
The select into statement is most often used to create backup copies of tables or for archiving records?
What are all types of user defined functions?
What is the process of debugging?
can sql servers linked to other servers like oracle? : Sql dba
What are the topics in pl sql?
What is trigger with example?
What are the ways on commenting in a pl/sql code?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
Is sql easier than java?
What is secondary key?
What is the difference between microsoft access and sql?
What is the benefit of foreign key?
What are sql functions? Describe in brief different types of sql functions?
What is rowid in sql?
Do we need to create index on primary key?