Browsing articles tagged with "substr - orasistem | Oracle E-Business Suite Paylaşım Platformu"
Tem
27
2015
Genel // PL/SQL

SUBSTR ve INSTR Fonksiyonlarının Kullanımı

SELECT SUBSTR (‘Mert AĞBABA’, 1, 4) FROM DUAL;    SELECT SUBSTR (‘Mert AĞBABA’, 3, 4) FROM DUAL; SELECT SUBSTR (‘Mert AĞBABA’,-4) FROM DUAL; SELECT SUBSTR (‘Mert AĞBABA’,4) FROM DUAL; SELECT SUBSTR (‘Mert AĞBABA’,-4,2) FROM DUAL; SELECT INSTR (‘Mert AĞBABA’,’A’,1,1) FROM DUAL; SELECT INSTR (‘Mert AĞBABA’,’A’,1,2) FROM DUAL; SELECT INSTR (‘Mert AĞBABA’,’BABA’,1,1) FROM DUAL; SELECT INSTR […]