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

Define a temp table?

1029

What are sql data types?

1037

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1198

What is the difference between having and a where in sql?

1113

discuss about myisam key cache. : Sql dba

1024

What is the difference between left outer join and left join?

1002

Name the different types of indexes in sql and define them.

1158

What are stored procedures used for?

1009

What are pl/sql packages?

1107

What is the difference between microsoft access and sql server?

1069

Determine if oracle date is on a weekend?

1050

What is trigger and how to use it in sql?

1028

What are sql functions? Describe in brief different types of sql functions?

1111

What is database sql?

1059

Can a procedure in a package be overloaded?

1052