Posts by Gustavo • 59 points
5 posts
-
1
votes1
answer1458
viewsA: Oracle Store Procedure reading XML
Dear friends, I have found this solution. My tables are : Temporary "INFO_XML" Final Table: "TAB_XML" I have only 10 days in the Oracle world, I hope I’m not too mistaken, but I learned that a…
-
4
votes1
answer1914
viewsQ: Procedure oracle to copy data between tables
I need to make a trial copy of my TAB_FORNECEDOR table, everything you have in it and pass to TAB_FORNECEDOR2 table. I know I need to make a loop cursor, a commit delete before everything, can give…
-
0
votes1
answer222
viewsA: Extract value, Procedure
I came to the following conclusion, through a link I found from TOAD, posted in the comments. I am currently here, and what I am solving is the issue of my xml file appears with Japanese font in my…
-
0
votes1
answer222
viewsQ: Extract value, Procedure
Initially I needed to create a precedent that would read an xml file and put the data in an oracle table, create the table, the directory, I have the following structure: create or replace package…
-
0
votes1
answer1458
viewsQ: Oracle Store Procedure reading XML
I need to make a stored procedure read an XML file and write it to a table in my database, but I have no idea how to do this... Can someone help me? I have 2 hours to deliver this.…