Technology Questions

ABAP/4 Query is a powerful tool to generate simple reports without any coding. ABAP/4 Query can generate the following 3 simple reports: Basic List: It is the simple reports. Statistics: Reports with statistical functions like Average, Percentages. Ranked Lists: For analytical reports. - For creating a ABAP/4 Query, programmer has to create user group and a functional group. Functional group can be created using with or without logical database table. Finally, assign user group to functional group. Finally, create a query on the functional group generated.

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.

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;

1:m

This is a scripting language developed by Microsoft and is based loosely on Visual Basic. Its functionality in a web environment is dependant upon either an ASP engine or the Windows Scripting Host, and must be used on a Windows hosting platform. 

A method declared as final can't be overridden. A sub-class can't have the same method signature with a different implementation.

Server-based network: Provide centralized control of network resources and rely on server computers to provide security and network administration.

peer-to-peer network: computers can act as both servers sharing resources and as clients using the resources.

Video: Videos can be edited, shared. High quality VGA video can be shot in portrait or landscape.

- 3 Megapixel Camera: Still photos with greater quality can be taken

- Voice control: It recognizes the names in contacts and recognizes the music on iPod.

- Compass: iPhone 3GS has built-in digital compass, used to point the way.

- Internet Tethering: Internet surfing can be done from anywhere. A 3G connection can be shared on Iphon3 with Mac notebook or laptop..