Answer / aparna

select substr(ename,-5) from emp

Answer / tanmay

select substr(ename,-5)as name from emp

Answer / samrendra

select substr(empname,-5)from emp

Answer / david

@swati ...

their is no any keyword like "right" as u used in ur
answer's statement......

david

Answer / kd

"select substr(ename,-5)as name from emp " is not right
because you will get no name if the ename is shorter than 5
letters.
right way:
select reverse (substr (reverse(ename), 1, 5))
from emp;

Answer / swati

select right(ename,5) as name from emp

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

0 Answers   TCS,

What command would you use to encrypt a PL/SQL application?

1 Answers  

write a query to find the third maximum salary of a employee.(table:employ col name:salary)

7 Answers  

8. Supporting AP, AR and GL?

0 Answers   Oracle,

Name two files used for network connection to a database.

1 Answers  

Difference between transaction type and transaction sources. : oracle accounts receivable

0 Answers  

A scenario for amount correction & how to use amount correction functionality in AP invoices

0 Answers  

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

0 Answers   TCS,

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers   Cap Gemini, Syntel,

Olap tools

0 Answers  

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

0 Answers   jusco,

How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun

8 Answers