SELECT SUBSTR(ENAME, 2, 4), ENAME FROM EMP;

13. Display the second to fifth characters in each client name.

Question Posted / nanne

Answer Posted / nanne

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is merge statement used for?

1024

What is Data Dictionary Cache in Oracle?

1165

How to assign values to data fields in record variables?

1035

What is the difference between pre-select and pre-query?

1221

How to get last row id?

994

What is a table in oracle?

981

Why packages are used in oracle?

1066

how may join possible between (requisition with purchase order)

2252

How to use group functions in the select clause using oracle?

1073

Can select statements be used on views in oracle?

1027

What are nested tables?

1174

Explain drop constraint oracle?

1067

What is the difference between hot backup and cold backup in oracle?

1014

How to see the table columns used in an index?

1024

How to load data from external tables to regular tables?

1062