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

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 define an anonymous block?

610


How do I manually create a database in oracle?

533


How to list all tables in your schema?

597


Name the various constraints used in oracle?

560


How to create a stored function in oracle?

579






Explain how you would restore a database using RMAN to Point in Time?

1621


What are the arithmetic operations?

574


Why packages are used in oracle?

532


How to use "in out" parameter properly?

610


What is an oracle recycle bin?

542


How to create lov dynamically at runtime & attach to text field?

654


How to view the data files in the current database?

582


How to list all indexes in your schema?

572


Explain what are the different type of segments?

572


In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1772