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

Answer Posted / nanne

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a system tablespace?

588


How to write text literals in oracle?

602


hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

1746


Explain the use of rows option in exp command.

577


How to handle a single quote in oracle sql?

584






how to make an oracle object

1853


What is a subquery in oracle?

574


What is the difference between view and materialized view in Oracle?

599


What are the uses of Database Trigger ?

1092


What is tns name?

535


What is the difference between translate and replace?

546


How to export your connection information to a file?

590


What is pragma autonomous transaction in oracle?

511


 What are the oracle DML commands possible through an update strategy?

574


How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1430