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

How do you write an inner join query?

953

What is the command used to fetch the first 5 characters of a string?

1209

How do you modify a trigger?

928

How does cross join work?

960

what is innodb? : Sql dba

1105

What is a clob in sql?

1021

what is cross join? : Sql dba

997

How do I install sql?

1002

Why do we use partitions in sql?

1050

What is parallel hint?

1327

How can you select unique records from a table?

1079

how to run 'mysql' commands from a batch file? : Sql dba

1120

How do I count duplicates in sql?

1105

Which is faster count (*) or count 1?

1035

Is primary key is clustered index?

1002