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;
This article describes and provides a custom-made tool I wrote to give businesses a means of identifying commercial music content, without having to expend too much effort. Business recordings are easily identified from possibly illegal music files …
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