Skip to content

Instantly share code, notes, and snippets.

@racsonp
Last active November 21, 2018 22:43
Show Gist options
  • Save racsonp/4c1b547b731947765f948cb1b8f3cf15 to your computer and use it in GitHub Desktop.
Save racsonp/4c1b547b731947765f948cb1b8f3cf15 to your computer and use it in GitHub Desktop.
https://www.akadia.com/services/ora_return_result_set.html
http://www.devjoker.com/contenidos/articulos/55/Paquetes-en-PLSQL.aspx
https://stackoverflow.com/questions/32953374/return-sys-refcursor-of-the-oracle-to-c-sharp?rq=1
https://www.mkyong.com/oracle/oracle-stored-procedure-select-into-example/
https://dba.stackexchange.com/questions/12749/finding-the-last-time-a-table-was-updated
SELECT last_user_update
FROM sys.dm_db_index_usage_stats us
JOIN sys.tables t
ON t.object_id = us.object_id
WHERE database_id = db_id()
AND t.object_id = object_id('dbo.YourTable')
---------------------------------------------------------------------------------------------------------------------
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/index.html
---------------------------------------------------------------------------------------------------------------------
https://stackoverflow.com/questions/3451534/how-do-i-do-top-1-in-oracle
---------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------
https://www.codeguru.com/csharp/azure/reading-text-from-images-using-c.html
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="oracle.manageddataaccess.client"
type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.122.18.3, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
</configSections>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1"/>
</startup>
<system.data>
<DbProviderFactories>
<remove invariant="Oracle.ManagedDataAccess.Client"/>
<add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver"
type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.122.18.3, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
</DbProviderFactories>
</system.data>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<publisherPolicy apply="no"/>
<assemblyIdentity name="Oracle.ManagedDataAccess" publicKeyToken="89b483f429c47342" culture="neutral"/>
<bindingRedirect oldVersion="4.122.0.0 - 4.65535.65535.65535" newVersion="4.122.18.3"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
<oracle.manageddataaccess.client>
<version number="*">
<dataSources>
<dataSource alias="SampleDataSource"
descriptor="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL))) "/>
</dataSources>
</version>
</oracle.manageddataaccess.client>
</configuration>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment