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

What do you know by pl/sql cursors?

574

What are system versioned tables?

553

what is auto increment? : Sql dba

577

Mention what does the hierarchical profiler does?

565

What are the subsets of sql?

553

How to move files from one directory to another in pl sql?

643

What are stored procedures in mysql?

569

Do we need to create index on primary key?

471

How do I run pl sql in sql developer?

630

Is sql dba a good career? : SQL DBA

539

how many columns can be used for creating index? : Sql dba

524

Can a table contain multiple foreign key’s?

579

How to raise user-defined exception with custom sqlerrm ?

682

What is a delimiter in sas?

550

What is an index in sql with example?

519