2) select length('HELLO')- length(replace('HELLO',&#

HP Interview -2016
Unix
1) grep command in unix
2) what is set command

Question Posted / sumanamara

Answer Posted / sumanamara

2)
select length('HELLO')- length(replace('HELLO','L',''))
FROM
dual;

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

State few characteristics of pl/sql?

723

what is the use of double ampersand (&&) in sql queries?

820

What is attribute indicator in pl sql?

719

How can I tell if sql is running?

761

Does truncate need commit?

699

Is ms sql traffic encrypted?

681

How many row comparison operators are used while working with a subquery?

754

what is not null constraint? : Sql dba

721

Why do we use partitions in sql?

720

What is the requirement of self-join?

740

What is the usage of distinct keyword?

815

Why partition by is used in sql?

726

What is a mutating table and a constraining table?

758

How does cross join work?

655

Explain the insert into statements in sql?

729