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
- 6425 Views
- TCS, I also Faced
- E-Mail Answers
counting the no.of characters occurs in a string by using
pl/sql function..
Answer / 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 |
More SQL PLSQL Interview Questions
How do you know if a relationship is 2nf?
What is crud diagram?
Explain what is an index?
What is pivot query?
Explain ddl statements in pl/sql?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
Does pl sql work in mysql?
What is rtm in testing?
what is auto increment? : Sql dba
How do you go back in sql?
Explain the difference in execution of triggers and stored procedures?
What is scope of pl sql developer in future?
Categories
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
