racsonp

/*   
Mapping a POCO - Direct Query (Command Text) and OracleDataReader 
*/
   public class Persona
    {
        public int Id { get; set; }
        public string PrimerApellido { get; set; }
        public string SegundoApellido { get; set; }
        public string ApellidoCasado { get; set; }
        public string PrimerNombre { get; set; }

racsonp

<?xml version="1.0"?>
<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.0"/>
  </startup>
  <system.data>

racsonp

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

racsonp

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Data;
using System.Data.SqlClient;

namespace WebApplication9
{
    public partial class WebForm1 : System.Web.UI.Page
    {

racsonp

--Install-Package Microsoft.AspNet.Mvc -Version 5.2.3 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using WebApplication1.Models;
using System.Data.Entity;

namespace WebApplication1.Controllers

racsonp

#!/usr/bin/perl -w
use DBI;
use DBD::mysql;
use CGI qw(:standard);
use warnings;

my $host = "localhost";
my $database = "otrs";
my $port = 3306;
my $tablename = "user";

racsonp

#!/usr/bin/perl
use strict;
use IO::Scalar;
use DBI;
use CGI;
use Spreadsheet::WriteExcel;

use constant C_HEADING => 0;
use constant C_WIDTH   => 1;
my @columns = (

racsonp

#!/usr/bin/perl -w
use DBI;
use DBD::mysql;
use CGI qw(:standard);
use warnings;

my $host = "localhost";
my $database = "otrs";
my $port = 3306;
my $tablename = "user";

racsonp

#!/usr/bin/perl -w

# DBI is the standard database interface for Perl
# DBD is the Perl module that we use to connect to the <a href="http://mysql.com/" />MySQL</a> database
use DBI;
use DBD::mysql;

# we use CGI since this will be executed in a browser
use CGI qw(:standard);

racsonp

#!/usr/bin/perl
use strict;
use IO::Scalar;
use DBI;
use CGI;
use Spreadsheet::WriteExcel;

use constant C_HEADING => 0;
use constant C_WIDTH   => 1;
my @columns = (