Oracle Sql Query by month and year

Question

I am trying to come up with an oracle sql query to get parts purchase in February 2007. Review InvoiceExample table below.

Table Name: InvoiceExample

 

InvoiceID	InvoiceDate	PartsPurchase
1	2/4/2007	Bike
2	2/5/2006	Piano
3	2/6/2007	Car
4	2/7/2007	House

 

 

The result is:

 

 

1	2/4/2007	Bike
3	2/6/2007	Car
4	2/7/2007	House

Answer 1

First of all be sure that you are importing/using (depending on language) the System.IO namespace for this to work. But what you can do is something like this

string pathToCreate = "~/UserFolders/" + TextBox1.Text;

if(Directory.Exists(Server.MapPath(pathToCreate))

{

   //In here, start looping and modify the path to create to add a number

   //until you get the value needed

}

 

//Now you know it is ok, create it

Directory.CreateDirectory(Server.MapPath(pathToCreate));