Oracle Query

OracleDataSource (Using a Query)
  • connectionString: the encrypted connection string
  • query: the select statement
<OracleDataSource
query="Select * from dbo.employees"
connectionString="DDE1MhWuA0xYbwFvSnu1fEZ2uD2GpsMRdw9DMV/kmMAfLUdkhkdzrD0Ikk/9dd114wRu9VKrVPSztrcIcSyz2UEFRRANfocc8KJEQXfKDuU=">
<Schema>
<Column name="employee_id" ordinal="1" dataType="Number" />
<Column name="name" ordinal="2" dataType="Text" />
</Schema>
<Filter/>
</OracleDataSource>
Last modified 3yr ago