import cx_Oracle

class Empleado:
    def __init__(self):
        self.connection = cx_Oracle.connect("system", "Tardes", "localhost/XE")

    def devolverdato(self,miOficio):
        cursor = self.connection.cursor()
        try:
            consulta = ("SELECT apellido,oficio, salario FROM emp where UPPER(oficio)=UPPER(:p1)")
            cursor.execute(consulta, (miOficio,))

        except self.connection.Error as error:
            print("Error: ", error)

        return cursor
02a3bb060f185ce4a26b07cb38f6c1d210cb5cc0
<mask token>


class Empleado:
    <mask token>
    <mask token>

<mask token>


class Empleado:

    def __init__(self):
        self.connection = cx_Oracle.connect('system', 'Tardes', 'localhost/XE')
    <mask token>

<mask token>


class Empleado:

    def __init__(self):
        self.connection = cx_Oracle.connect('system', 'Tardes', 'localhost/XE')

    def devolverdato(self, miOficio):
        cursor = self.connection.cursor()
        try:
            consulta = (
                'SELECT apellido,oficio, salario FROM emp where UPPER(oficio)=UPPER(:p1)'
                )
            cursor.execute(consulta, (miOficio,))
        except self.connection.Error as error:
            print('Error: ', error)
        return cursor

import cx_Oracle


class Empleado:

    def __init__(self):
        self.connection = cx_Oracle.connect('system', 'Tardes', 'localhost/XE')

    def devolverdato(self, miOficio):
        cursor = self.connection.cursor()
        try:
            consulta = (
                'SELECT apellido,oficio, salario FROM emp where UPPER(oficio)=UPPER(:p1)'
                )
            cursor.execute(consulta, (miOficio,))
        except self.connection.Error as error:
            print('Error: ', error)
        return cursor

import cx_Oracle

class Empleado:
    def __init__(self):
        self.connection = cx_Oracle.connect("system", "Tardes", "localhost/XE")

    def devolverdato(self,miOficio):
        cursor = self.connection.cursor()
        try:
            consulta = ("SELECT apellido,oficio, salario FROM emp where UPPER(oficio)=UPPER(:p1)")
            cursor.execute(consulta, (miOficio,))

        except self.connection.Error as error:
            print("Error: ", error)

        return cursor