December 2019 – Jun Kim

DBMS_OUTPUT not working (Doesn’t display anything)

December 31, 2019Jun Kim

From the Oracle SQL Developer, when you can’t see any output although you added DBMS_OUTPUT as following: BEGIN DBMS_OUTPUT.PUT_LINE(‘This should be displayed’); END; It doesn’t display anything as following: You…Continue readingDBMS_OUTPUT not working (Doesn’t display anything)

Clean Coding, General Windows

Encrypt ConnectionStrings in web.config

December 30, 2019Jun Kim

This is the sample connection string in the web.config file Before Encrypt <configuration> <connectionStrings> <add name=”SqlServices” connectionString=”Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind;” /> </connectionStrings> </configuration> Encrypting web.config file 1. Open Command…Continue readingEncrypt ConnectionStrings in web.config

Database, Oracle

Merge Code Sample – Oracle

December 24, 2019Jun Kim

It’s Oracle Script. The Oracle MERGE statement selects data from one or more source tables and updates or inserts it into a target table. The MERGE statement allows you to specify a condition to determine whether to update data…Continue readingMerge Code Sample – Oracle

.NET, Clean Coding

C# How to add DataRow Manually

December 24, 2019December 24, 2019Jun Kim

To create DataRow on the DataTable: DataTable table = new DataTable(); DataRow row = table.NewRow(); row.valueWantToChange = 200; table.Rows.Add(row); To enable this, make sure you have System.Data.DataSetExtension on your project…Continue readingC# How to add DataRow Manually

Database, Oracle

How to get Blob size in Oracle

December 24, 2019December 24, 2019Jun Kim

DBMS_LOB.GetLength returns the number of characters (bytes) in the CLOB/BLOB column. SELECT DBMS_LOB.GetLength(“BlobColum”)/1024/1024 AS SizeMB FROM MY_SCHEMA.MY_TABLE_WITH_BLOB_CLOB

Database, Oracle

To trace query executed for Oracle

December 24, 2019Jun Kim

This is the query to identify what query were executed on my machine. Since Oracle doesn’t have Profiler as SQL Profiler, this is the script that we can get through…Continue readingTo trace query executed for Oracle

Clean Coding, General Windows

Windows Host File Location

December 24, 2019December 24, 2019Jun Kim

Microsoft kept the hosts file alive in Windows networking which is why it varies very little whether used in Windows, macOS, or Linux. The syntax stays mostly the same across…Continue readingWindows Host File Location

Clean Coding, General Windows

Machine.Config Location

December 24, 2019December 24, 2019Jun Kim

Common Location: C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config The Machine.Config file, which specifies the settings that are global to a particular machine. This file is located at the following path: [Windows Directory]\Microsoft.NET\Framework\[Framework Version]\CONFIG\machine.config As web.config…Continue readingMachine.Config Location

Month: December 2019