Find last modified tables Oracle

Oracle > Scripts

USER_TAB_MODIFICATIONS describes modifications to tables owned by the current user that have been modified since the last time statistics.

Example: Find last modified tables:

select * from USER_TAB_MODIFICATIONS order by timestamp desc

System.Drawing.Printing C#

C# > System.Drawing.Printing

Contains print services for Windows Forms applications.

• Print Preview Dialog
• Print Document

Gets the default printer C#

C# > Printing > PrinterSettings > IsDefaultPrinter

Gets the default printer.

Example

PrintDocument printDoc = new PrintDocument();

if (printDoc.PrinterSettings.IsDefaultPrinter)

{

MessageBox.Show (printDoc.PrinterSettings.PrinterName);

}

Get all printers installed on computer C#

C# > Printing > PrinterSettings > InstalledPrinters

Contains the names of all printers installed on the computer.

Example: Get all printers installed on computer

foreach (string prt in System.Drawing.Printing.PrinterSettings.InstalledPrinters)

{

    MessageBox.Show(prt);

}

DateTime Compare C# Example

C# > System Namespace > DateTime > Compare

Compares two dates of type DateTime.

Example

DateTime date1 = new DateTime(2014, 4, 1, 0, 0, 0);

DateTime date2 = new DateTime(2014, 5, 1, 0, 0, 0);

int cmp = DateTime.Compare(date1, date2);

if (cmp < 0)

MessageBox.Show("date1 is earlier than date2");

else if (cmp == 0)

       MessageBox.Show("date1 is equal to date2");

else

       MessageBox.Show("date1 is later than date2");

Check if a date is weekend day C#

C# > System Namespace > DateTime > DayOfWeek

The DayOfWeek enumeration represents the day of the week.
Its value ranges from zero (DayOfWeek.Sunday) to six (DayOfWeek.Saturday).

Example: Check if a date is weekend day

DateTime date1 = DateTime.Now;

           

if ((date1.DayOfWeek == DayOfWeek.Saturday ||  date1.DayOfWeek == DayOfWeek.Sunday ))

{

  // action

}

DateTime Structure C#

C# > System Namespace > DateTime 

DateTime structure represents an instant in time.

• Days in month
• Add methods
• Nullable
• First & Last day of the month
• DayOfWeek
• Compare
• Convert string to date

Example

  DateTime dt= DateTime.Now;

Days In Month C# Example

C# > System Namespace > DateTime > DaysInMonth 

Returns the number of days in the specified year and month.

Example

int daysInMonth = System.DateTime.DaysInMonth(2014, 4);