select substr(ename,1,1) from emp;

write a query that returns first characters of each word in
Oracel/Sql pl sql

Question Posted / priya

5 Answers
9861 Views
I also Faced
E-Mail Answers

Answer Posted / priya

select substr(ename,1,1) from emp;

Is This Answer Correct ?

18 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is not in sql?

927

What are the basic techniques of indexing?

1047

What view means?

958

What is anonymous block in sql?

1107

Can triggers stop a dml statement from executing on a table?

1064

how to include comments in sql statements? : Sql dba

937

what is 'mysqlimport'? : Sql dba

1015

What does where 1/2 mean in sql?

1047

What is before trigger?

983

what is the difference between inner and outer join? Explain with example. : Sql dba

1010

How to Declare Fixed Length String Value In PL SQL

1135

Can ddl statements be used in pl/sql?

1116

Can you have more than one trigger on a table?

984

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4244

What is example of database?

1034