Encontramos dificuldades em vários momentos com os desenvolvedores para listar o Cursores e Funções, abaixo vou mostrar como listar cada um deles, forma fácil e rápida que encontramos aqui:

Cursor:

SQL Developer:
Exec1:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”VmFyIE91dEN1cnNvciBSRUZDVVJTT1IKQmVnaW4KT3duZXIuUGFja2FnZS5Qcm9jZWR1cmUo4oCYUGFyYW0x4oCZLCDigJhQYXJhbTLigJksIOKAmFBhcmFtTuKAmSwgOk91dEN1cnNvcik7CkVuZDs=” hover_enabled=”0″]VmFyIE91dEN1cnNvciBSRUZDVVJTT1IKQmVnaW4KT3duZXIuUGFja2FnZS5Qcm9jZWR1cmUo4oCYUGFyYW0x4oCZLCDigJhQYXJhbTLigJksIOKAmFBhcmFtTuKAmSwgOk91dEN1cnNvcik7CkVuZDs=[/et_pb_dmb_code_snippet]

Exec:2

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”UHJpbnQgT3V0Q3Vyc29yCgpTUUwqUGx1czoKU1FMPiBWYXIgT3V0Q3Vyc29yIFJFRkNVUlNPUgpTUUw+CjEgQmVnaW4KMiBPd25lci5QYWNrYWdlLlByb2NlZHVyZSjigJhQYXJhbTHigJksIOKAmFBhcmFtMuKAmSwg4oCYUGFyYW1O4oCZLCA6T3V0Q3Vyc29yKTsKMyBFbmQ7CjQgLwpTUUw+IHZhciBvdXRjb21lIFJFRkNVUlNPUg==” hover_enabled=”0″]UHJpbnQgT3V0Q3Vyc29yCgpTUUwqUGx1czoKU1FMPiBWYXIgT3V0Q3Vyc29yIFJFRkNVUlNPUgpTUUw+CjEgQmVnaW4KMiBPd25lci5QYWNrYWdlLlByb2NlZHVyZSjigJhQYXJhbTHigJksIOKAmFBhcmFtMuKAmSwg4oCYUGFyYW1O4oCZLCA6T3V0Q3Vyc29yKTsKMyBFbmQ7CjQgLwpTUUw+IHZhciBvdXRjb21lIFJFRkNVUlNPUg==[/et_pb_dmb_code_snippet]

Function:

SQL Developer e SQL*Plus:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”U1FMPiBTZWxlY3QgT3duZXIuUGFja2FnZS5Qcm9jZWR1cmUo4oCYUGFyYW0x4oCyLOKAmVBhcmFtMuKAsizigJlQYXJhbU7igJkpIEZyb20gRHVhbDs=” hover_enabled=”0″]U1FMPiBTZWxlY3QgT3duZXIuUGFja2FnZS5Qcm9jZWR1cmUo4oCYUGFyYW0x4oCyLOKAmVBhcmFtMuKAsizigJlQYXJhbU7igJkpIEZyb20gRHVhbDs=[/et_pb_dmb_code_snippet]

Att,
capin