Get Year, Month, Day, Hour, Minute, Second from Oracle Date column value.

Syntax:           

EXTRACT(key FROM Column_Name) 

Where Key are Following:-

• Year

• Month

• Day

• Hour

• Minute

• Second 

 For Example: SELECT EXTRACT(YEAR FROM SYSDATE) FROM DUAL

How can I rename all files in a folder using command prompt?

--For rename all html file to text file
ren *.html *.txt
--for rename all file including extra character
ren *.txt *_1.txt
---rename only first 3 character which is 123 and change to abc
ren 123*.txt abc*.txt