I have many cursors that all return rows with the same fields: a numeric ID field and an XMLType field. Every time I access one of these cursors (each cursor has now got its own function for access),
I need to create a table every morning based on overnight generated data from a massive table. This will then be accessed by a handful of users form Excel.
I\'ve come across an example of doing this on the net which also f开发者_运维问答ails on my DB (10g) but here\'s my version.
I am working on a project where I am importing in orders from an external vendor.I will need to validate the information prior to loading it into our ERP system and then send a response with shipping
I have this procedure: create or replace PROCEDURE CONVERTE IS CURSOR oldemployees IS SELECT * FROM emp1 WHERE data_saida= NULL;
I have table which holds a company hierarchy. It was decided to use this flat table as there is no defined number of levels in the company. The table workes great, and if you were to use cascading lis
I have this big code where I want 3 things in my search: 1- look for all the orders (delivered and not) that match the search:
I have a little DB, for academic purpose only, and I have object tables at most. I\'ve created a entity-relationship model (ERM) in Power Designer and the program, by default, creates index for the se
We currently are in a debate within our IT group over what the best practice is for handling the majority of all of our processes. Our IT director is pushing for everything to be event driven.His reas
I tried to register a schema in Oracle the other day to validate an XML document. The code I used was fairly simple:
加载中,请稍侯......