Mart 22, 2010

“Kur’an’la amel eden dünyaya hakim olur.”
MAHMUD USTAOSMANOĞLU EFENDİ

Hangi portu hangi program kullanıyor.

Şubat 13, 2017

netstat -o -n -a | findstr 0.0:8080 verilen PID no görevyöneticisinden hangi uygulamanın kullandığını göre biliriz

Hot to get the current date in T-SQL

Şubat 13, 2017

SELECT SYSDATETIME() as SYSDATETIME,
SYSDATETIMEOFFSET() as SYSDATETIMEOFFSET,
SYSUTCDATETIME() as SYSUTCDATETIME,
CURRENT_TIMESTAMP as “CURRENT_TIMESTAMP”,
GETDATE() as GETDATE,
GETUTCDATE() as GETUTCDATE,
CAST(GETDATE() As date ) CAST,
CONVERT (date, GETDATE()) as “CONVERT”;

 

SYSDATETIME 2017-02-13 17:16:16.0697359
SYSDATETIMEOFFSET 2017-02-13 17:16:16.0697359 +03:00
SYSUTCDATETIME 2017-02-13 14:16:16.0697359
CURRENT_TIMESTAMP 2017-02-13 17:16:16.067
GETDATE 2017-02-13 17:16:16.067
GETUTCDATE 2017-02-13 14:16:16.067
CAST 2017-02-13
CONVERT 2017-02-13

Ubuntu upgrade operation

Eylül 1, 2016

I tried this version: 15.10 to 16.04

cat /etc/apt/sources.list

1- sudo sed -i -e “s/wily/xenial/g” /etc/apt/sources.list

cat /etc/apt/sources.list

2- sudo apt-get update
3- sudo apt-get dist-upgrade

lsb_release -a

SQL Developer Setup Configuration

Kasım 30, 2015

…/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf

SetJavaHome ../../jdk

terminalde Jdk yı indirdiğiniz klasörün içerisine gelerek (teyit etmek için bulunduğunun klasörün icinde bin klasörü var ise doğru yerdesiniz) pwd komutunu yazıp enter a basarsanız o klasörün path ini vercecektir.

LISTAGG YAN YANA

Kasım 19, 2015

SELECT PERSONEL_ID, LTRIM(LISTAGG(PERIOD, ‘,’) WITHIN GROUP (ORDER BY PERIOD),’,’) PERIODS
FROM PERSONEL_INF0
WHERE PERSONEL_ID =317
AND CREATED_TIMESTAMP >= sysdate-100
GROUP BY PERSONEL_ID
ORDER BY PERSONEL_ID;

PERSONEL_ID PERIODS
——– —-
1 David
1 John
1 Alan
1 David
2 Julie
2 Charles
And I want the following result:

PERSONEL_ID PERIODS
——– —–
1 ‘Alan, David, John’
2 ‘Charles, Julie’

======================= ** 2 ** =========================

with my_tabe as
(
select ‘M01’ as scycle, ‘1’ as sdate from dual union
select ‘M01’ as scycle, ‘2’ as sdate from dual union
select ‘M02’ as scycle, ‘1’ as sdate from dual
)
select scycle, ltrim(sys_connect_by_path(sdate, ‘,’), ‘,’)
from
(
select distinct sdate,
scycle,
count(1) over (partition by scycle) as cnt,
row_number() over (partition by scycle order by sdate) as rn
from my_tabe
)
where rn = cnt
start with rn = 1
connect by prior rn + 1 = rn
and prior scycle = scycle

 

How to install Eclipse Resource Bundle Editor

Ekim 22, 2015

Update Site:

Create a new update site in Eclipse with the following:

Site name: ResourceBundle Editor
Site URL: https://raw.githubusercontent.com/essiembre/eclipse-rbe/master/eclipse-rbe-update-site/site.xml

Whitelabel Error Page

Haziran 24, 2015

This application has no explicit mapping for /error, so you are seeing this as a fallback.

Wed Jun 24 16:48:24 EEST 2015
There was an unexpected error (type=Not Found, status=404).
No message available

How to read Query Parameters key and value

Haziran 11, 2015

How to read Query Parameters key and value

javax.persistence.Query

Query query = ….
query.setParameter(“PARAM_1″,”1”)
.setParameter(“PARAM_2″,”2”)
.setParameter(“PARAM_3″,”3″)

…;
I want to get parameters and write Console. Like this;

System out ;

PARAM_1 – 1
PARAM_2 – 2
PARAM_3 – 3

ANSWER ;
java.util.Set<Parameter> params = query.getParameters();
for (Parameter p : params) {
String paramName = p.getName();
System.out.print(paramName + ” – “);
System.out.println(query.getParameterValue(paramName));
}

Target : http://stackoverflow.com/questions/28046207/how-to-read-query-parameters-key-and-value

Yonca Bilişim Teknolojilerine Yazılım Geliştirme Uzmanı Aranıyor !!!

Haziran 9, 2015

Yonca Bilişim Teknolojilerine Yazılım Geliştirme Uzmanı Aranıyor !!!

İlana aşağıdaki linkten ulaşabilirsiniz.

Yazılım Geliştirme Uzmanı Aranıyor
http://www.kariyer.net/yonca-bilisim-teknolojileri/yazilim-gelistirme-uzmani-is-ilani-i1384295/?&tmpsno=1&isaramalog=337894012&sirano=1&isaratipi=2

gVim

Mayıs 14, 2015

gVim

Begining of line – :%s/^/”/g
End of line – :%s/$/”+/g


..
.