[Oracle] Startup & Shutdown Oracle Instance

Posted by cikul | Posted in Oracle, SQL | Posted on 17-07-2012-05-2008

0

For DBA,  starting up and shutting down database is a routine operation. How to start and stop Oracle database (windows & Unix base)

Starting Up Oracle Database

To starting up Oracle Database,  you must connect using SQLPLUS /as sysdba or an oracle account that has DBA privilege.

Read the rest of this entry »

Share and Enjoy

Query data from specific date SQL Server

Posted by cikul | Posted in SQL, Tips | Posted on 01-03-2012-05-2008

2

for example, you have sort of data from table order :

Order id Order_date Value
1 2005-12-15 13:04:42.667 500
2 2006-03-16 19:08:30.423 350
3 2007-07-28 15:14:30.350 400
4 2006-03-16 20:11:25.413 150
5 2000-09-10 16:09:58.817 200

and you want to get data for date 2006-03-16,

Read the rest of this entry »

Share and Enjoy