Technical Notes

We're all on the same page!

Friday, 28 November 2014

What is Sticky Bit?

›
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...
Saturday, 22 November 2014

Useful shortcuts for vi editor

›
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...

How to unlock database user account?

›
Please run the sql lines in SQL Editor as "sys" user; SQL> ALTER USER "alper" ACCOUNT UNLOCK;
Wednesday, 19 November 2014

What are RAID levels 0/1/5/10?

›
Level Minimum Disk Req. Performance Redundancy Suggestions 0 2 Excellent None Not recommended...
Friday, 14 November 2014

What is Oracle doing when you run commit?

›
The basic flow like that; Oracle writes that "Commit has been executed" in related table from UNDO tablespace.  SGA buffer cac...
Wednesday, 12 November 2014

How to use Intersect function?

›
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...
Wednesday, 5 November 2014

Linux date function examples

›
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 ...

[CONCAT] How to merge two strings as a single string?

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

[INITCAP] How to make uppercase the first character of each word in a string?

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

[ADVICE] Free Windows Disk Defragmenter Alternative

›
I strongly recommend to use  Smart Defrag tool instead of classical Windows Defragmenter tool.
Sunday, 26 October 2014

How to check NTFS file system in CMD?

›
Only you need to run this command. e.g. chkntfs C: C:\Windows\system32>chkntfs C: The type of the file system is NTFS. C: is not ...

How to defrag disk partiton in CMD?

›
Only you need to run this command as Administrator. e.g. defrag C:

How to change font color in CMD?

›
Only you need to run this command in cmd. e.g. color A 0 = Black 1 = Blue 2 = Green 3 = Aqua 4 = Red 5 = Purple 6 = Yellow 7 = W...

How to define a tablespace in Windows?

›
Please execute the commands as "sys"; To define the tablespace: SQL>  CREATE TABLESPACE ALPER_DATA  DATAFILE 'C:\table...

How to prepare a video with steps via windows tool?

›
Please you run this command first in cmd. CMD> psr Then you can record the steps by clicking start record. After finish your video...

How to know hostname from IP in Command Prompt?

›
Press Windows button + R and press cmd then click "OK". Then, write down "below command" and press enter nbtstat -a ...
Wednesday, 22 October 2014

How to delete linux user?

›
# sudo userdel -r alper -r -> Remove home directory and mail spool
Tuesday, 21 October 2014

How to run sql query in shell script?

›
Please add these codes into your .sh file then you can run .sh file e.g.  ssh -q -T oracle@192.168.2.2  << EOF sqlplus / as sysdb...

How to know file format description in CMD?

›
Please you run this command in CMD. e.g. assoc .rar .rar=WinRAR e.g. assoc .txt .txt=txtfile
Monday, 20 October 2014

What are testing types and methods?

›
There are two test methods which are Black Box Testing and White Box Testing Basically, there are two test types which are Functional ...
‹
›
Home
View web version
Powered by Blogger.