Actually I am having a emp table, I need name, Can I get 1st and last letter same time? How to get? Pls tell me the ans? When we will get mutating error?
Question asked by visitor ramesh
Actually I am having a emp table, I need name, Can I get 1st and last letter same time? How to get? Pls tell me the ans? When we will get mutating error?
Question asked by visitor ramesh
hi
you can get the first and last letter same time in a single column.
i will give one query u go through it
select to_char(substr(QWF_WARRANTY_TYPE_CD,0,1)||substr(QWF_WARRANTY_TYPE_CD,8,9)) from qa_warranty_fir
where QWF_FIR_JOBCARD_ID=1017
by using this we can get the first and last name in a single column.
if wrong pls reply me.
Select substr(ename,1,1)||substr(ename,-1,1) name from emp;
Hi
u can get the first and last letter from a column by using :
Select substr(,1,1)||substr( ,length( ),1) from
Mutating tAble Error will come mainly in the TRiggers /
When ever the Table data is manipulating is not yet commited ( like update / delete/ insert) , at the same time if u are trying to access the table data
then you will get the Mutating table error.
hi friends
we never got a confirmation from ramesh that could he solve the above problem
however in oracle if you want the first and the last letter from ename of emp
then we can use the following syntax
SELECT SUBSTR(ENAME,1,1)||SUBSTR(ENAME,-1,1) AS [ALIAS]
FROM EMP;