Recent content by Roberto

  1. R

    sql & xml

    Hi, with a server test, i've migrate on oracle 9.2 and on my pc client i've installed oracle client 9.2 with all XML option. Now i've tried to execute a query in this style select XMLElement("Emp", XMLAttributes(e.employee_id AS "ID", e.last_name), XMLElement("Dept",e.dept)...
  2. R

    sql & xml

    Hi, i've find something on the web around this function (XMLElement, XMLForest, etc...) but with my oracle 8.1.7 i do not succeed to use them...there is a way to see if this function are included? If there aren't, how i can install this function? Thanks Roberto
  3. R

    sql & xml

    Hi, i would to create a xml file containing data extract with a sql query, but xml file must respect a specific dtd (and not the generic schema that i obtain whit the export of the grid). Is the first time that i must export data in a xml and...i'm very confused i work with oracle 8.1.7 and...
  4. R

    xml output

    Hi, I would have to export data extract with a sql windows in a xml file. Is possible to change the way with which the rows xml it comes created? e.g. If i have the row: Surname | Name | telephone | email Rossi | Mario | 1234 | eg@eg.com actually the file xml will be...
  5. R

    spool in a file

    Thank's
  6. R

    spool in a file

    Hi, when, from a command windows, I carry out the spool on file, at the end the output file contains the line "executed in xxxx seconds". How I can avoid it? By Roberto
  7. R

    out of memory

    thanks, this command me will be much profit
  8. R

    out of memory

    unfortunately the number of the extracted records is right indeed they would have to be in all 618155, and I cannot avoid it. there is a solution?
  9. R

    out of memory

    Hi, when my query extracts more than 200000 records appears a message of error: "Out of memory". what it depends? I set the buffer, in the preference menu, on the max value...what i do ? p.s.: scuse for my student's english
Back
Top