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

Answer Posted / priya

Is This Answer Correct ?

18 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What does trigger mean in psychology?

962

how many columns can be used for creating index? : Sql dba

946

Can we use the cursor's to create the collection in PL/SQL?

1027

What is substitution variable in pl sql?

1044

Can we insert data into view?

903

Does group by remove duplicates?

1044

What are sql procedures?

1026

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1269

How do you declare a constant?

960

how to fetch common records from two tables? : Sql dba

1172

Is it possible to create startup or shutdown trigger for on-schema?

1029

what are tables and fields? : Sql dba

1055

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1033

Is crud a cuss word?

1036

Explain the order of sql statement execution?

1045