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

What is the difference between conversions and interfaces? : oracle accounts receivable

0 Answers  

How can you gather statistics on a table?

3 Answers  

how to write customizations in po

0 Answers   Ernst Young,

How many segment are present in Oracle Manufacturing

0 Answers   Oracle,

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

0 Answers   Wipro,

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,

can u give guidance abt packages of plsql

0 Answers   Mphasis,

What is db_recovery_file_dest in oracle? When do you need to set this value?

0 Answers  

Explain how to close periods in ar. : oracle accounts receivable

0 Answers  

How would you determine the time zone under which a database was operating?

1 Answers  

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

0 Answers  

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

0 Answers   Punjab National Bank,