LINQ Enumerable Except Example

C# > LINQ > Enumerable > Except

Produces the set difference of two sequences


Example

            double[] num1 = { 1.0, 1.1 , 1.2  };
            double[] num2 = { 1.1 };

            var onlyInNum1 = num1.Except(num2);

            foreach (double number in onlyInNum1)

Determining NLS_DATE_FORMAT Oracle

Oracle > NLS_DATE_FORMAT

NLS_DATE_FORMAT specifies the default date format to use with the TO_CHAR and TO_DATE functions

Example:
Get NLS_DATE_FORMAT 

SELECT value
FROM   nls_session_parameters
WHERE  parameter = 'NLS_DATE_FORMAT'

Result:

Change and replace text line in file C#

C# > IO > File > Read/Write Lines

ReadAllLines reads all lines of the file into a string array  and closes the file.
WriteAllLines creates a new file  writes strings to the file and closes the file.

Example:

Replace text line in a file

var lines = File.ReadAllLines(Pathfile);

lines[64] = "new text";

File.WriteAllLines(Pathfile);

Remove first character from string

C# > String > Substring

Remove first character from string

myString.Substring(1)

Check number is even or odd C#

C# > Operators > % Operator

Computes the remainder after dividing its first operand by its second.

Example: Check number is even or odd

  for (int x = 0; x < 100; x++)

  {

     if (x % 2 == 0)

      //even number

     else

      //odd number

  }

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