Select Substr(ename, 2,4), ename From emp;

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

Question Posted / devraj

2 Answers
4527 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / devraj

Select Substr(ename, 2,4), ename From emp;

Is This Answer Correct ?

9 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to run create database statement again?

1076

How to create a new table in oracle?

1065

How to create a table interactively?

996

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1010

What is an oracle transaction?

1052

How to shutdown your 10g xe server from command line?

1014

What is concurrency in oracle?

946

What are the extensions used by oracle reports?

996

How to use attributes of the implicit cursor in oracle?

947

What are privileges and grants?

1002

How to export several tables together?

986

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1794

List out the components of logical database structure of oracle database.

984

How to change program global area (pga) in oracle?

1032

How to commit the current transaction in oracle?

1043