Interested to Buy Any Domain ? << Click Here >> for more details...
counting the no.of characters occurs in a string by using
pl/sql function
- 1 Answers
- 6526 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / revathy
create or replace function f1(
iip in varchar2,iip2 in char)
Return number
is
tot number;
Begin
select (length(iip)-length(replace(iip,iip2))) into tot
from dual;
return tot;
end;
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
What is an implicit commit?
What are properties of the transaction?
What is using in sql?
What are synonyms in sql?
What is mutating error?
How many commands are in sql?
What is constant in pl sql?
How can I speed up sql query?
how many groups of data types? : Sql dba
what is oracle database ? : Sql dba
how can you create an empty table from an existing table? : Sql dba
When are we going to use truncate and delete?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What are the types of records?
What are different types of queries in sql?
