Technical Notes

Execute below operations as root user. 1. vi /etc/ssh/sshd_config # comment out Banner row # no default banner path Banner /etc/ssh/ss...

e.g. select to_date('2014-12-18','yyyy-mm-dd') from dual; output: 12/18/2014 select to_date('2014-12-18 12:15',...

You may use PowerMenu tool for using "Always On Top" on the window. Download: http://www.abstractpath.com/powermenu/

MsgBox("Calculator!") a=CInt(InputBox("First number:","Enter number")) b=CInt(InputBox("Second number:...

Please follow the instructions: Run notepad  Copy below text into notepad Save as .vbs format Double click the file Example VBS file...

To upload: $ scp [desired files] [login_user]@[host]:/[remote path] e.g. $ scp *.txt alper@10.10.10.10:/home/alper/mynewtextfiles To d...

$ nmblookup -A <IP> e.g. nmblookup -A 10.10.10.10 e.g. nmblookup -A $(who | awk -F\( '{ print $2}' |  rev | cut -c 2- | re...

Global rank: 6,859,462

to get os version: #  cat /etc/*release* to get os kernel version: #  cat /proc/version to get cpu info: # cat /proc/cpuinfo or # ...

CMD> where ping C:\Windows\System32\PING.EXE CMD>  where sqlplus D:\instantclient_11_2\sqlplus.exe

1st way: CTRL + ALT + DEL 2nd way: CTRL + SHIFT + ESC

If sticky bit is active, that file can be only deleted by root or owner. to activate; chmod +t file.txt -rw-r--r-T to unactivate; chm...

vi myfile.txt to open file with vi editor vi + myfile.txt cursor goes to end of the file vi +200 myfile.txt cursor goes to 200th row :s...

Please run the sql lines in SQL Editor as "sys" user; SQL> ALTER USER "alper" ACCOUNT UNLOCK;

Level Minimum Disk Req. Performance Redundancy Suggestions 0 2 Excellent None Not recommended...

The basic flow like that; Oracle writes that "Commit has been executed" in related table from UNDO tablespace.  SGA buffer cac...

For instance, you want to see same jobs for employees that belong to different manager in employees table. Please run the sql lines in SQ...

e.g. date -d now date -d today date -d yesterday date -d mon date -d tue date -d wed date -d thu date -d fri date -d sat date -d ...

Please run the sql lines in SQL Editor as "hr" user; e.g. select CONCAT('Bilgi havuzu ','at ozsoyler.blogspot.com...

Please run the sql lines in SQL Editor as "hr" user; e.g. select INITCAP('ozsoyler.blogspot.com') from dual; result ...