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

Does mysql support pl sql?

1097

Write the alter statement to enable all the triggers on the t.students table.

1066

What are the two virtual tables available at the time of database trigger execution?

1155

What is partition in sql query?

943

How many databases can sql express handle?

941

What plvcmt and plvrb does in pl/sql?

1249

What are stored procedures in mysql?

966

What is flag in sql?

980

What is a full join sql?

980

explain advantages of myisam over innodb? : Sql dba

1014

Which query operators in sql is used for pattern matching?

901

What is audit logout in sql profiler?

976

Which operator is used in query for pattern matching?

1031

Which is better varchar or nvarchar?

932

Why do we use subquery?

942