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
- 6319 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Does sql view stored data?
What are the disadvantages of file system?
How to fetch alternate records from a table?
What is the difference between nvl function, ifnull function, and isnull function?
what is user defined functions? : Sql dba
What is before and after trigger?
How does pl sql work?
Write the command to remove all players named sachin from the players table.
What are the types of dbms?
what is the difference between group by and order by in sql? : Sql dba
how to use in conditions? : Sql dba
How many null values can be inserted in a coulmn whihc is unique constraint
-
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)
