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
9700 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 dense_rank?

879

how tsql statements can be written and submitted to the database engine? : Transact sql

924

Which is faster count (*) or count 1?

968

how to install mysql? : Sql dba

1047

How do you create a unique index?

991

What is numeric function sql?

988

What is sql engine in oracle?

930

Can a varchar be a primary key?

955

How to return an array from java to pl/sql?

1063

What is the difference between an inner and outer join?

963

Is ms sql is free?

960

What is the difference between in and between in sql?

996

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2230

What is the difference between left join and right join?

889

What is mutating sql table?

1040