You need to first create a table in oracle that matches with the fields of the XML data.

So to get the XMl into the table, you can create a generic procedure that moves an XML document into a table by converting the elements to Oracle Canonical format.

Oracle Canonical format is as follows:

<ROWSET>

   <ROW>  

     <column_name_1 />

     .

     .

     </ROW>

     <ROW>

         <column_name_1 />

         .

         .

      </ROW> 

        .

        .

</ROWSET>        

ROW is used for the table names

ROWSET is used for the XML document

You can get the XML into the canonical form using XSL:

<?xml version="1.0"?>

<xsl:stylesheet 

             xmlns:xsl="https://www.w3.org/1999/XSL/Transform"                   

             version="1.0">

     <xsl:template match="/">

          <ROWSET>

               <ROW>

                         <Attribute_name>                      

                             <xsl:value-of select="Table_name/Attribute_name" />

                         </Attribute_name>

                < /ROW>

          </ROWSET>

     </xsl:template>

</xsl:stylesheet>

To transform the XML document into the canonical form, you can write a procedure. Make sure you include the line below in your procedure code:

v_rows := DBMS_XMLStore.insertXML(

                v_context,    

                XMLType.transform(p_xml_in, p_xsl_in));

The only remaining step is calling your procedure: 

DECLARE

   v_xml XMLType := XMLType( YOUR XML Document );

   v_xsl XMLType := XMLType( YOUR XSL Document );

BEGIN 

   procedure_name(v_xml, v_xsl, 'table_name');

END;

Asc() - Returns ANSI Character Code 

Chr() - Returns Character from ANSI Code 

InStr() - Find a string within another 

InStrRev() - Find a string within another (Reverse) 

LCase() - Convert a string to lowercase 

Left() - Crops a string from left 

Len() - Determine the length of a string 

LTrim() - Remove leading spaces from a string 

Mid() - Crops a string 

Replace() - Replace a substring within a string 

Right() - Crops a string from right 

RTrim() - Remove trailing spaces from a string 

Space() - Creates a string with the specified number of spaces 

StrComp() - Compare two strings 

String() - Creates a repeated character string 

StrReverse() - Reverse the characters of a string 

Trim() - Remove both leading and trailing spaces from a string 

UCase() - Convert a string to uppercase 

Math object has two constant : Math.PI and Math.E

Math object has following functions:

- Math.abs(val1);

It will give absolute value of val1.

- Math.max(val1,val2);

This fuction will return maximum value from val1 and val2.

- Math.random();

This function will return a random number between 0 and 1.

- Math.floor(val1)

This function will returns decimal value of val1

Files can be read and written by using java script functions – fopen(),fread() and fwrite().

The function fopen() takes two parameters – 1. Path and 2. Mode (0 for reading and 3 for writing). The fopen() function returns -1, if the file is successfully opened.

Ex: file=fopen(getScriptPath(),0);

The function fread() is used for reading the file content.

Ex: str = fread(file,flength(file));

The function fwrite() is used to write the contents to the file.

Ex(): file = fopen("c:\MyFile.txt", 3);// opens the file for writing

fwrite(file, str);// str is the content that is to be written into the file.

NaN stands for ‘not-a-number’. The function isNaN determines the argument or the value is a NaN. The function returns true if the argument is not a number, otherwise returns false.

To send the characters that can not be specified in a URL should be converted into their equivalent hex encoding. To perform this task the methods encodeURI() and decodeURI() are used.

For example, the following code snippet performs the encoding of URL:

<script type="text/javascript">

          var uri = https://www.mysite.com/city?=Banglore; // original URI

          var ncodeuri=encodeURI(uri);

          document.write("<br />ncodeuri”);

          var dcodeuri = decodeURI(ncodeuri); 

          document.write(“<br>/>dcodeuri”);

</script>

The cursor can set to wait in JavaScript by using the property ‘cursor’ property. The following example illustrates the usage.

window.document.body.style.cursor = "wait"; 

The elements of JavaScript are accessed by their names. By default the browser is accessed by the element ‘windows’ and the page by ‘document’. The corresponding element has user defined names for forms and its elements. For example

var pwd = windows.document.frmLogin.password.value;

assigns the value of the password field of the form fromLogin in the current document, where password is the name of the element and frmLogin is the name of the form. Like wise any form element is accessed.