I have opened the connection to an oracle database using the code below.
Dim oradb As String = "Data Source=(DESCRIPTION=" _
+ "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxx)(PORT=1521)))" _
+ "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=yyyy)));" _
+ "User Id=uname;Password=pw;"
Dim conn As New OracleConnection(oradb) ' VB.NET
and it is successful.
I want to read the views. but I have no idea.
I have been using like the code below to read data in the PLSQL. where I am told "mim_ADHOC" is a schema.
select * from mim_ADHOC.vw_marketing_datamart where smonth = 201312;
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…