Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 934C21337B68
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 16 Feb 2011 06:41:16 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 06715-09 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 16 Feb 2011 10:41:03 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from cx296.800onemail.com (CX296.800onemail.com [209.171.54.154])
	by mail.postgresql.org (Postfix) with ESMTP id DA1AD133616B
	for <pgsql-sql@postgresql.org>; Wed, 16 Feb 2011 06:41:02 -0400 (AST)
Received: from EX13-N04.exchserver.com ([10.7.5.66])
	by cx296.800onemail.com (8.13.8/8.13.8) with ESMTP id p1GAeeQ7024712
	for <pgsql-sql@postgresql.org>; Wed, 16 Feb 2011 05:40:40 -0500
Received: from EX60.exchserver.com (10.7.5.154) by EX13-N04.exchserver.com
	(10.7.40.182) with Microsoft SMTP Server id 8.3.106.1; Wed, 16 Feb 2011
	05:40:40 -0500
Received: from [127.0.0.1] ([164.164.82.29]) by EX60.exchserver.com with
	Microsoft SMTPSVC(6.0.3790.3959);	 Wed, 16 Feb 2011 05:40:39 -0500
Message-ID: <4D5BAA07.7060704@subexworld.com>
Date: Wed, 16 Feb 2011 16:12:15 +0530
From: Sivannarayanreddy <sivannarayanreddy@subexworld.com>
Reply-To: sivannarayanreddy@subexworld.com
Organization: Subex Ltd.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7
MIME-Version: 1.0
To: <pgsql-sql@postgresql.org>
Subject: Oracle Equivalent queries in Postgres
Content-Type: multipart/alternative;
	boundary="------------060606060103050105080909"
X-OriginalArrivalTime: 16 Feb 2011 10:40:39.0604 (UTC)
	FILETIME=[F3FF5740:01CBCDC5]
X-Crx-NoRoute: SMTP reroute not required
X-CRXEFW-Info: Please contact Ceryx for more information
X-CRXEFW-Virus: Clean
X-CRXEFW-From: sivannarayanreddy@subexworld.com
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201102/73
X-Sequence-Number: 35149

--------------060606060103050105080909
Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
Content-Transfer-Encoding: 7bit

Hello,
I am checking the compatibility of my product with Postgres database and 
i stucked in forming the below oracle equivalent queries in Postgres 
database, Could some one help me pleaseee

1) Trying to get index and corresponding columns  information of all the 
tables in mentioned schema

select  inx.table_name as table_name, inx.index_name as 
index_name,column_name, case  ( when inx.index_type = 'IOT - TOP' then 
'Y' else 'N'  end,
     case
      when inx.uniqueness = 'UNIQUE' then 'Y'
      when inx.uniqueness = 'NONUNIQUE' then 'N'
      end,
      'N' as ignore_dup_key,
      cast(inc.column_position as NUMBER(10))
      from    all_indexes         inx,
      all_ind_columns     inc
       where   inx.owner           = '" + database.toUpperCase() + "'
       and     inx.table_name      = inc.table_name
       and     inx.index_name      = inc.index_name
       and     inx.owner           = inc.index_owner
      and     inx.owner           = inc.table_owner
      and     inx.dropped         = 'NO'
      and     inx.table_name       = '" + tableName.toUpperCase() + "'
      order by inx.table_name, inx.index_name, cast(inc.column_position 
as NUMBER(10))


2) Trying to get the columns information of all the tables in mentioned 
schema

  select   tab.TABLE_NAME,
                   col.COLUMN_NAME,
                   col.DATA_TYPE,
                   cast(case  when col.CHAR_COL_DECL_LENGTH is NULL then 
col.DATA_PRECISION else col.CHAR_LENGTH end  as NUMBER(10)),
                   cast(col.NULLABLE as CHAR(1)),
                   cast(col.COLUMN_ID as NUMBER(10))

          from    all_tab_columns    col,
                  all_tables         tab
          where   tab.TABLE_NAME        = col.TABLE_NAME
          and     tab.OWNER             = col.OWNER
          and     tab.OWNER             = '" + database.toUpperCase() + "'
          and     tab.DROPPED           = 'NO'
         and     tab.TABLE_NAME       = '" + tableName.toUpperCase() + "'
         order by tab.TABLE_NAME, cast(col.COLUMN_ID as NUMBER(10))



*Sivannarayanareddy Nusum****| **System Analyst(Moneta GDO)*

Subex Limited, Adarsh Tech Park, Outer Ring Road, Devarabisannalli, 
Bangalore -- 560037, India.
*Phone:*+91 80 6696 3371; *Mobile:*+91 9902065831*Fax:*+91 80 6696 3333;

*Email:*sivannarayanreddy@subexworld.com 
<mailto:email.id@subexworld.com>; *URL:*www.subexworld.com 
<http://www.subexworld.com/>

/Disclaimer: This e-mail is bound by the terms and conditions described 
at //http://www.subexworld.com/mail-disclaimer.html/


--------------060606060103050105080909
Content-Type: multipart/related;
	boundary="------------090405060001000106050206"

--------------090405060001000106050206
Content-Type: text/html; charset="ISO-8859-1"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
  </head>
  <body text="#000099" bgcolor="#ffffff">
    Hello,<br>
    I am checking the compatibility of my product with Postgres database
    and i stucked in forming the below oracle equivalent queries in
    Postgres database, Could some one help me pleaseee<br>
    <br>
    1) Trying to get index and corresponding columns&nbsp; information of all
    the tables in mentioned schema<br>
    <br>
    select&nbsp; inx.table_name as table_name, inx.index_name as
    index_name,column_name, case&nbsp; ( when inx.index_type = 'IOT - TOP'
    then 'Y' else 'N'&nbsp;
    end,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
    &nbsp;&nbsp;&nbsp; case&nbsp;&nbsp;&nbsp; <br>
    &nbsp;&nbsp;&nbsp;&nbsp; when inx.uniqueness = 'UNIQUE' then 'Y'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
    &nbsp;&nbsp;&nbsp;&nbsp; when inx.uniqueness = 'NONUNIQUE' then 'N'&nbsp;&nbsp;&nbsp;&nbsp; <br>
    &nbsp;&nbsp;&nbsp;&nbsp; end,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
    &nbsp;&nbsp;&nbsp;&nbsp; 'N' as ignore_dup_key,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
    &nbsp;&nbsp;&nbsp;&nbsp; cast(inc.column_position as NUMBER(10))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
    &nbsp;&nbsp;&nbsp;&nbsp; from&nbsp;&nbsp;&nbsp; all_indexes&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; inx,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
    &nbsp;&nbsp;&nbsp;&nbsp; all_ind_columns&nbsp;&nbsp;&nbsp;&nbsp; inc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where&nbsp;&nbsp; inx.owner&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = '" + database.toUpperCase() +
    "'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and&nbsp;&nbsp;&nbsp;&nbsp; inx.table_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = inc.table_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and&nbsp;&nbsp;&nbsp;&nbsp; inx.index_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = inc.index_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and&nbsp;&nbsp;&nbsp;&nbsp; inx.owner&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = inc.index_owner&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
    &nbsp;&nbsp;&nbsp;&nbsp; and&nbsp;&nbsp;&nbsp;&nbsp; inx.owner&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = inc.table_owner&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
    &nbsp;&nbsp;&nbsp;&nbsp; and&nbsp;&nbsp;&nbsp;&nbsp; inx.dropped&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 'NO' <br>
    &nbsp;&nbsp;&nbsp;&nbsp; and&nbsp;&nbsp;&nbsp;&nbsp; inx.table_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = '" + tableName.toUpperCase() +
    "'<br>
    &nbsp;&nbsp;&nbsp;&nbsp; order by inx.table_name, inx.index_name,
    cast(inc.column_position as NUMBER(10))<br>
    <br>
    <br>
    2) Trying to get the columns information of all the tables in
    mentioned schema<br>
    <br>
    &nbsp;select&nbsp;&nbsp; tab.TABLE_NAME, <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; col.COLUMN_NAME, <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; col.DATA_TYPE, <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cast(case&nbsp; when col.CHAR_COL_DECL_LENGTH is NULL
    then col.DATA_PRECISION else col.CHAR_LENGTH end&nbsp; as NUMBER(10)), <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cast(col.NULLABLE as CHAR(1)), <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cast(col.COLUMN_ID as NUMBER(10)) <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from&nbsp;&nbsp;&nbsp; all_tab_columns&nbsp;&nbsp;&nbsp; col, <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; all_tables&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tab <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where&nbsp;&nbsp; tab.TABLE_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = col.TABLE_NAME <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and&nbsp;&nbsp;&nbsp;&nbsp; tab.OWNER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = col.OWNER <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and&nbsp;&nbsp;&nbsp;&nbsp; tab.OWNER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = '" + database.toUpperCase()
    + "' <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and&nbsp;&nbsp;&nbsp;&nbsp; tab.DROPPED&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 'NO' <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and&nbsp;&nbsp;&nbsp;&nbsp; tab.TABLE_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = '" + tableName.toUpperCase()
    + "' <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; order by tab.TABLE_NAME, cast(col.COLUMN_ID as NUMBER(10))<br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
    <br>
    <br>
    <div class="moz-signature">
      <title> </title>
      <meta name="GENERATOR" content="OpenOffice.org 2.3 (Win32)">
      <meta name="CREATED" content="0;0">
      <meta name="CHANGED" content="20090514;17180285">
      <meta name="ProgId" content="Word.Document">
      <meta name="Originator" content="Microsoft Word 11">
      <!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
      <!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Author>Connoi</o:Author>
  <o:Template>Normal</o:Template>
  <o:LastAuthor>harshitan</o:LastAuthor>
  <o:Revision>2</o:Revision>
  <o:TotalTime>4</o:TotalTime>
  <o:Created>2007-11-30T08:17:00Z</o:Created>
  <o:LastSaved>2007-11-30T08:17:00Z</o:LastSaved>
  <o:Pages>1</o:Pages>
  <o:Words>80</o:Words>
  <o:Characters>459</o:Characters>
  <o:Lines>3</o:Lines>
  <o:Paragraphs>1</o:Paragraphs>
  <o:CharactersWithSpaces>538</o:CharactersWithSpaces>
  <o:Version>11.9999</o:Version>
 </o:DocumentProperties>
</xml><![endif]-->
      <!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:SpellingState>Clean</w:SpellingState>
  <w:GrammarState>Clean</w:GrammarState>
  <w:ValidateAgainstSchemas/>
  <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
  <w:IgnoreMixedContent>false</w:IgnoreMixedContent>
  <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
  <w:Compatibility>
   <w:SelectEntireFieldWithStartOrEnd/>
   <w:UseWord2002TableStyleRules/>
  </w:Compatibility>
  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
 </w:WordDocument>
</xml><![endif]-->
      <!--[if gte mso 9]><xml>
 <w:LatentStyles DefLockedState="false" LatentStyleCount="156">
 </w:LatentStyles>
</xml><![endif]-->
      <!--[if !mso]><object
 classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object>
<style>
st1\:*{behavior:url(#ieooui) }
</style>
<![endif]-->
      <!--[if gte mso 10]>
<style>
 /* Style Definitions */
 table.MsoNormalTable
	{mso-style-name:"Table Normal";
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-parent:"";
	mso-padding-alt:0in 5.4pt 0in 5.4pt;
	mso-para-margin:0in;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Times New Roman";
	mso-ansi-language:#0400;
	mso-fareast-language:#0400;
	mso-bidi-language:#0400;}
</style>
<![endif]-->
      <!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="2050"/>
</xml><![endif]-->
      <!--[if gte mso 9]><xml>
 <o:shapelayout v:ext="edit">
  <o:idmap v:ext="edit" data="1"/>
 </o:shapelayout></xml><![endif]-->
      <style type="text/css">
	<!--
		@page { size: 8.5in 11in }
		P { color: #000000 }
		A:link { color: #0000ff }
		A:visited { color: #800080 }
	-->
	</style>
      <p style="margin-bottom: 0in;"><strong><font color="#939598"><font
              face="Arial"><font size="2">Sivannarayanareddy
                Nusum</font></font></font></strong><strong><font
            color="#000080"> </font></strong><strong><font
            color="#000080"><font face="Arial"><font size="2">|
              </font></font></font></strong><strong><font
            color="#0000ff"><font face="Arial"><font size="2">System
                Analyst(Moneta GDO)</font></font></font></strong><font
          color="#000080">
        </font>
      </p>
      <p style="margin-bottom: 0in;"><font face="Arial"><font
            style="font-size: 8pt;" size="1"><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75"
 o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
 <v:stroke joinstyle="miter"/>
 <v:formulas>
  <v:f eqn="if lineDrawn pixelLineWidth 0"/>
  <v:f eqn="sum @0 1 0"/>
  <v:f eqn="sum 0 0 @1"/>
  <v:f eqn="prod @2 1 2"/>
  <v:f eqn="prod @3 21600 pixelWidth"/>
  <v:f eqn="prod @3 21600 pixelHeight"/>
  <v:f eqn="sum @0 0 1"/>
  <v:f eqn="prod @6 1 2"/>
  <v:f eqn="prod @7 21600 pixelWidth"/>
  <v:f eqn="sum @8 21600 0"/>
  <v:f eqn="prod @7 21600 pixelHeight"/>
  <v:f eqn="sum @10 21600 0"/>
 </v:formulas>
 <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
 <o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" style='width:142.5pt;
 height:53.25pt'>
 <v:imagedata src="e-mail%20signature_files/image001.gif" o:title=""/>
</v:shape><![endif]--><img
              src="cid:part1.01010006.07070008@subexworld.com"
              name="graphics1" width="190" align="BOTTOM" border="0"
              height="71"></font></font></p>
      <p style="margin-bottom: 0in;"><font color="#808080"><font
            face="Arial"><font style="font-size: 8pt;" size="1">Subex
              Limited, Adarsh Tech Park, Outer Ring Road,
              Devarabisannalli,
              Bangalore &#8211; 560037, India.<br>
            </font></font></font><font color="#a01e55"><font
            face="Arial"><font style="font-size: 8pt;" size="1"><b>Phone:</b></font></font></font><font
          color="#000000">
        </font><font color="#000000"><font face="Arial"><font
              style="font-size: 8pt;" size="1">+91
              80 6696 3371; </font></font></font><font color="#a01e55"><font
            face="Arial"><font style="font-size: 8pt;" size="1"><b>Mobile:</b></font></font></font><font
          color="#000000">
        </font><font color="#000000"><font face="Arial"><font
              style="font-size: 8pt;" size="1">+91
              9902065831</font></font></font><font color="#c1272d">&nbsp; </font><font
          color="#a01e55"><font face="Arial"><font style="font-size:
              8pt;" size="1"><b>Fax:</b></font></font></font><font
          color="#000000">
        </font><font color="#000000"><font face="Arial"><font
              style="font-size: 8pt;" size="1">+91
              80 6696 3333; </font></font></font>
      </p>
      <p style="margin-bottom: 0in;"><font color="#a01e55"><font
            face="Arial"><font style="font-size: 8pt;" size="1"><b>Email:</b></font></font></font><font
          color="#c1272d">
          &nbsp;</font><font color="#c1272d"><font face="Arial"><font
              style="font-size: 8pt;" size="1"><a
                href="mailto:email.id@subexworld.com">sivannarayanreddy@subexworld.com</a>;
            </font></font></font><font color="#a01e55"><font
            face="Arial"><font style="font-size: 8pt;" size="1"><b>URL:</b></font></font></font><font
          color="#c1272d">
          &nbsp;</font><a href="http://www.subexworld.com/"><font
            color="#c1272d"><font face="Arial"><font style="font-size:
                8pt;" size="1">www.subexworld.com</font></font></font></a><font
          color="#c1272d">
        </font>
      </p>
      <p style="margin-bottom: 0in;"><font color="#c1272d">&nbsp;</font></p>
      <p class="msonormal"><font color="#808080"><font face="Arial"><font
              style="font-size: 8pt;" size="1"><i>Disclaimer:
                This e-mail is bound by the terms and conditions
                described at
              </i></font></font></font><a
          href="http://www.subexworld.com/mail-disclaimer.html"><font
            face="Arial"><font style="font-size: 8pt;" size="1"><i>http://www.subexworld.com/mail-disclaimer.html</i></font></font></a><font
          color="#808080"> <br>
        </font></p>
    </div>
  </body>
</html>

--------------090405060001000106050206
Content-Type: image/gif; name="graphics1"
Content-Transfer-Encoding: base64
Content-ID: <part1.01010006.07070008@subexworld.com>
Content-Disposition: inline; filename="graphics1"

R0lGODlhvgBHAHcAACH/C01TT0ZGSUNFOS4wDQAAAAFzUkdCAK7OHOkAIf8LTVNPRkZJQ0U5
LjAXAAAAC21zT1BNU09GRklDRTkuMEI8pPUALAAAAAC+AEcAh4ODg4uLi6KiotqpvP/BCf/T
U50aUPfs8P/IJe7Z4cuGosyJpfnw9P7yy/De5q9GcZwZTzY2Np4dU/71254eU3x8fLFKdf7c
d7Kystmmu2tra8nJyXV1df/ABfz8/Pz5+v/nnL5pjJUJQ6s9ar1miu3t7f/CDFtbW//RTPv1
+P/hiP/78ZqamsZ7mv7uuuHh4f/pqP78/dGVrsTExPny9f/DEqmpqdHR0f/77SwsLPHx8fXp
7uG6yvLh6KEmWKAgVb29vf/01UxMTNra2urO2VRUVKYyYv/MNM+QquXl5dyuwblehLm5ufXn
7f/NO7ZVfc2NqOnK196yxOK+zK1BbqUvX5oVTJsWTf/FG56ent3d3f++AJ4fWrtghv+/ApkS
SuTAz7RReZGRkbhagdfX1/r6+vr09/T09P37/Ojo6JsYTvz6+6g2ZRkZGfj4+Pb29uTB0N+0
xezU3v/9+dCQq6QtXpaWlv/5566urp4eUsmBn8HBwf/abKIoWs3NzUJCQiEhIdSbspkUS9Wd
tJwcUsR1lmRkZOXE0fPk6ufJ1f/rsMFxkqAkV5gQSJ8iVqMqXNCTtJ0cUMBukKQsXrlcgv7X
Yba2ttahtuvS3NejuKo4Z6YrS5wXTwgICPHg56AgVv/+++vQ2/7AA+3W4MN1lfTl654iVZwc
WrNRebBIcqQqXfry9tOYsOC3yJoSS+zT3ch+nP+9AMV4l/7YZtCSrJ8iVP/fgrNOd92ww5kV
TJ0dUr9sjv7337hZgObG1JcOR5gSSdSbs/+/A/ry9fjv85gRSZ8eVOS/z50bUZsaULVTe5kT
S50fVKQrXZ8hVf7////+/////p8gVaYuX/7+/58fVP7+/p4hVf/+/p8hVP7//p4gVPz4+Z4g
Vf79/frz9p8iVcJzk6YtX+/b47xROuWVHeSXIZ0gVf/1stF4OfPk79+2x5kXWLdXf//vwP/M
Abldib9ukf/71f76++ymL54hVOKZQ//HAJkVTf2+AP/LEf/HCNuswNurv6AhVv///wj/AP8J
HEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePIEOKHEmyJEhtJlNO/CADChI6MOlA
yRRDpc1/KG/qVMhA2q9iQIGKGMFtp8cY1IwqZUhjmgRn/qL6M5Dqw1KJ2KbIUCBLEoklS5T1
WtJlESwoYKxeXUqjylOpUx+ovWotWrR/dxN6oiCir9+/In4JjvRggYO1Rtu+lWpA7tW8Dg88
obKkkB4kmDErWHRrkg9CgtnE8Yb4pmKojB0jnuMwRtGEaA4k4KGHTTFkFsCUVnkabuO5SkFd
OHKBF0FoAyFHbBJuWaMRxAQi3y2yd2rgRoMQELYFwYUg/54J/7SrPOKaXcuWFZIObTp1j9aj
/l7boMYWAgS21LjgAsezZ9hcNI8sySCjxEDuvcdRfHFhtxM27lSChTD4eUEAAjD8lxEJjRhx
QHgkIVeeaW6hJp9qB4n3TIIWtQciQrzwYV8HBNBYQAMF2SVRP1fgk4GCITE4H3UT2OLEdiYI
YwIf4I03IkOJOLIMCQGG9IEDYPCTQSsOOJiSkCgO1MMhUmQgBRHfbIRGKVGsk8EAPLxyAGkF
geICCjSaIEoNs9xRkSePQGBEmh8NwwoVfVRjgBoU9PGAHuMcN9AaSrw5wKUDZKDEGgvJkQmm
l25Zk0BgztXEJb304QwyakTiCBskZP+QgkVEQGFBH45IoAajPjSjDCujCCSeQNjYUoMXJhAQ
ixMTjDesQ000Y8AjTXyUwQhXQEBBNT/8UA0FBiwzzQLV/lPlPzT4YAUE7LIriA80LASFCO2y
CwwVr6Fbom8PoPHPGrTUYQUneVQjTbfVSGCFIBbw4G9EDpCwzTIQGFMNt94ao6sgjFCCiUEN
FJCknhgK+yRCDvSBTDOldMSAJJxA4MzMcEkTlQRXGLFAQTSII0G3QBMyTbwKIVHMwUBDgKKQ
FqQQTCoQRGIzXDW3moovDA17zBiPXEEB1VQ7Iw0FV/RBSRwEiecOCqLg1wEKzUIUBSMrt7wR
N100Ik02M5v/GNUPUK1qhQIENSUB1bpMw8BCRvs9pL6LRYVbC8uo4QzfYEsljTPb5DKJbgxF
8cgXeUhFc9j+0MyMIBBIIZA22iAHDQhYdGBCd4pAJAUykbDMkQLL/JD58NVYAcVrhlMtwdCM
f+H40vtq/ogz1QxvvQE/rINXQS7+A4e0mV/Ttz/ig42MD7ggCKI7WNxHowoLdU+LIHnUEZ1G
ozByuPVgO3JFHZ4glVOUx7yiOY9fc2GQI6QxNf6BDRzIYATWnvUP5HhjAXQbntiMsS3MgY0Q
eYDFw/LyDF6oAAv4EUUl/HQygTCACsiAQBg8sJEMWCFzOLMC9qiGDFUcYiDJg8vy/4iWECQc
8DpAjF5UnHGNT9RMV5xQgwSqB7aZWeEW+ZLOPxKhBmT47W/hggAjEpULTlDRdM7QxRV+iBxr
COsfisDP7ZzQJINoKBOCcMYyYLG9jOgBGGG7wjR2IYkHqMGMqTMAOH4IxAEKsYBFPOKJEqhE
1KAGGcswABso0YUxaEICgtDFEk/nDEHI4CC7sAIpxdZFKuihH0QYxxRYsQRGWOFrcPEfCQZy
LoHAoH0m8AIC/ISQNaRCDdK4wo9aCBFsLEENNdNFCA7zD25kQhkSoAAywMEKnjlSKkNs3vMo
GTmqqWEEsojD/dA1BVlUwXKpc2JUdNGHYBEkA5E448woQP8IC/AjiwOJQhcYYYDT+eMHBrhE
QhqAAgIEswBxMwgrkCkBAKrpFgaAS6Psxksl5KEPcDBIEMEJSYQYcZxJLKdUrmABRCTEAe1Q
pd+cYYUx0OkfKUOGVD6RDWboIhCjShtBEsGGgpooEj6IFEKiUQn9iAIL7jCIAz7jD0GEoyNL
4ITppBGJfhwECTwYyLNGerOSflWSDUrpFx1hhQdwVDrPgAwDnnAFgzqDAoyw5z8WsAy/SWMZ
ejgINSj4DyL4oHRwWcbODBKNweIABfkwQQewYByCBMMKDFRDWFlkEVgIIpcSeAQSXNoQsvoj
nAZEKamUKDxkjCABDSkFGwgxU0H/0EIgZqBCQeFCiCoE0CGLuALVDEAFIh5kDhcwQZJQUNl/
YIINXoQAFjdyFyXscIn+0EUupqGH3yrEtKiNpGohZyKxGeBA0EjKQoAHtlzsQiChcAQz4NIN
NQwCIgnwgTFM1w1OHGghF9hCMBEAHk+wQWbMQEZYN4KccejPdKZwxA90IYg6ZOCmBwGvWQ1y
UgSqFS7MYARsqaFehYTCH/vFrhra4UYeSIAZJpKGI9rRhRrb+MY4rnEzzpg6VywWIQGaQwEE
7IUjTAAegnDEqvDFEfFYQxJ6m2nqIiFDtCFEw8Y963gZFAlNzIqwCImBBTKKXapYZQAQ2Bxc
nGEATrj5/81wjnMUZUw1K6yHIY8VhQneYY9TzBccXwgBSL7RAghsY3jduIIB2mHlCjZyfyTN
MofR+jgGWUESDxGPAr6gvBHMSgbLcKCorceJXWZtBSi4hzk2sT8J9CEUIpFFMeYLtmv4I5lq
WMTi3INlcXp4teUsBhQekpRMCFeIVYiX0UbNbHNSgrMGwcYz5EGPTZzictIQxGKhfRHkEOMJ
u6pi4KrRCEEXzmcElHRBOoxEYPutGLd1CHL6cd2yKpvTzc43BJQR1IS4UR0jMEA29gaBEXzI
XCHhBg8oAYxIOEPJX0ToLswwEG6MwIsanUS5iliM5+WLQcD4sUMGcUNkK7sYYP/bhgR0IYGW
u/zlMI95y60Qhn4nhAEWOLY/KOADIoxEQ/9IgQLqIAgKeBAu5P7xBx5ggAbu3HcKgQLK4aKG
J9zU0vGIiB7wDU5NUJwWrqCaNPowjSpM4+xoT7va1372PizB5pL6BwPG8FmpsIMcIBgPSJ5B
Dfd4Qg/++AIh+keISfRAIDG4BQRsLRUKPMK7CGmBIMoXlSt0oXCVbMzDHEIJaMIFGUy+LNWu
EAIz0OD0qE+96lefejMkBcwDmfsyGH9aQpRDHzjSBjMtAuZj7KKoflOybQdCgivIMyrG8IEc
FiKJKzjdCovAfDk/CvmFJKAPuFzivmtiXeFJxbWLIwn/N0jgPEekzhhcSMc+OuAEFtqkCajQ
+RKtYOp/UI72/mCGNECHEDSM2W9fMGwftkTboAYDkBwLAQuAtGaXJhBRAmOaY0oQAXQMkV7i
UQq9oHNiwwmQgA7KFQt88CIqkQBVoFNSkQ0r5kb/AGqpozmccIB2JB7j4AMUYCI/oAaZIH1+
JV1FwW0Vp1tgUwyE8w+IgH3llQyaEH4dMR2IkArL0EDOoAZUYBWzYCEIsAIhMQCnhBCDwAne
5w/ZsH0CEQdNt2ZXUH9C9Q+wgFmAExXVwAxYM4Cmgw8tgGEIsQBq8IVR4VMh9Q8eoAzyd2tq
4FUO0SUQ8QG9AAxqdjNXoFD//+AODiUMtsARkCEDPgABlOBzFdQ961Bv/iCG/7ADRiBKWxUJ
sjAX7oEEF8NDI6CE5AU20gABvfBWIogJXTBFYUN/N3UIFEBrSyQBk3A8OdJH//AKJNAHFtAC
SiWCBsEDFmCCqZMr4PAjAgEKfGAhJpA7jnYR0SAeMhBK5+AKRiAFGLYDFgABpnMNajAGJSYJ
eYRGq/MEr0AQKUAHVwBpUrEMLUCMDKI5X5AKU8ApBBEDUvAIguB0N+MIH0MQ6LFmabQMYbCM
BfENUPAIy0AByVAMRqAAvzVYBjEIOFMzzKAGwYCAOIAAHSAKV/gMOYERieBTM+MIMRQGlzAK
43AMt/8gf5cjCO81EFNgAPrkD0r2P+FABzLQAjC0DV/0CVbgVZDRj0t0DRCgC6mwAHFwCOsA
BWGQB7QFNp/wBXxUEA5Qgmi0QDnTAlLQA6d3AIcgAxaQC7rQN+AQCa4wDYEwKwaBC63iNz9Q
DLJgRyBgO16gAhRoEa2gCdAYFdJwSD7QB9JAZmhkBTk4EN5QCHX1RadlBV+wDIKAcWs2FZqw
A9v4iqYDDjUDAVZwOBJAMTzWgs5whnhZEHqplF8ESoSgCmYnDv6wLkJpOv4ADoLwAOUyHQkQ
Ag+GRsswBq44EKBQCRSCBRFlEaWgCkmWOZ9gDBZTRVJIKI62A1UQCdmQb1L/UQ0vOJqkGRUD
h5nSsIoaFAnMECwUZEEkAAyHljnSoDEt15pL9AO60oeOlgBG8AXZ9wnXUAuC0A7LSRAu4FBe
AAKwZx4KgA/Zx2w402j/oF6k8AsQmG/S0AjRZ54MYgrGkAzi+YkQUJLM6JFz1wgTKp7hQjjP
QgRUUFdUYwptJZoJcQco5AUF8KASsQCcgI8tmDm5IgFIgBClQAIGIKQOVDwhkKDnuXOakJMp
NmpqwAbUaEexpweOgI7i+QOcYARbKB7fQAt9YDnjAxVXwAawthAqoCQm4AIbMQiM4HypY1Dx
BBUGYDwLkQHVoAb1wETjM0p9kwxXUAgCKVJVEJfj/wMBFvANCqALBgBxtbY5eXAv1KQQ08ED
bFB0fIOnaDQzhPAFDyCR46AMxUAIpkmogpAKh8cQoOAEHcB+rOGjDaFeofAExSAIS3ox3vIt
yHAFgsAGMLgQA2AEgqBousAM+reezCABBnAFjaAJhFhihcMIxXAFVrCtVvALI1ATU8AGjXAF
yFAwF8NBrPIFPqAAH1KYBkFiArEDCuAD2YoMEmAx3HIxeUBlVlAMbCADq0AQ/TANV0B5oxSc
tHgQOgICyEIAcqp7GcENrEACFlAHjKAoxiANzTAC7YAEONoQO8AKXUAFRsAI0iAByCANjDAN
qdAFCkBa5jkQKUAKIbALNv9rsySgAA8zDgowsn1wWhIwdiPwBIWgie4qWARBBApAAlRQBT8r
ARBQDWPEBqgQAlAAs0RICl0EDngqDVZABQvpECtwBB0gDAUACsSYEWtwAKFwDErAA3BQCrEp
EdxAA3IAB1KgBGBABDvgJRfBDZ5wCK2wDnAwDilghxXBDQyQAFg5AFOQCJ7wDTYXA6xQB4gE
F+KTbSRwcBABA7ZTA+Cxe0AyuhUxHdyAHokZlczACaSQqBBxkrOaO6J7EbbaENMxHbXLe2+0
iR8BDbAXBcqgBtWAmf6ADMXQBdYKEdGAAtwBP7NLutDLEHkxCl3gD1pFpAZQB4MApQ9hCxZy
BFj/GL034QFlUBIosQYy0Ay3lDkzowZ1oIkW0QDK1QGKkLviaxBAAAQVIQAc0BBnkAUAIAYv
MBBDEAAVgAc0JBAbAAAawAIJjBfe0ALFEAnkg5nMkAvNYGU+2BBzQLZbwAf2WxLlSxAeQCcq
SBAnrAMFUb43cAMD4QGu6wFvYBB+IAY0FAAn4IcrXBBDAAhMgAF/4MIscAKWMAMAIAQqzL9A
cAN+8MBbpAtfM6jgxAwL8Krc+A8qQCPDtBRuwAFDfAID/A82UARFsAf/sAEBcMYAcMZi8A/e
UAF/wAFu8A9DvMZAsAFnHAAaUARaIBCWIAQnoAF4PBAa0AYnUAJ28Adw/6y//6AFJyAETEAQ
QxABAhEBTLAGOeAHA/EHM+ANOUAGCDEAnFCfo5Q6wSqAGzEBNVAj2mgUbmDIabDH/wAEOXAD
GAAIaaAFOSDGOeAGAtDGNmAHb6ABGPAPRQDG/2AHNvAPWfAHL2AHGvAPblDGaZADyzwQNnAC
SeABdtAGN8ACOVAGbiAEGEAGOZAEA6HLAgAAhlAGL5ADMywQB/zOZ4AQGaAGpHxr/tANgtAM
1BjCHOzBF7AUZ5ADePwCgOABGlABAiEELPAPf7AHY4wHAjAExgwAGFABy2wIliAQLIAHzPzQ
GyAE//ACafwPhnDNAsEE0fwPOPwPOtAGZzADOf+AAUBsxgKhBYBQAUWQBSWdA/UsEByAAfSM
EGBACA3kCDKpBiSwfJQoEBcQC7FQAASdAzPwDzeQA9agAS39B8ssBkUQACNdAeV7AjZQAmdA
GoYQyXQM0gJgB2dM0mnQv/9g1gRhCS390iUACGewAedcAmWQqJP8D3tdAh7wB2380wMsBIxs
ECnwAHW3QFagCvcVErxQALNQRzvhBoDwBxggBGuc1SzAAX9Qz1rQCWucAzn8DxhgCEDABCVQ
18X8D2KwzCzQxjPwB9bgAUXAAQIACCA9EBsQAfp7xITdCYAtBBqQvydszm/gycs8A4AQADYQ
AWv8DzPg0HuAAa77D3KyMALAsAzZ2gWwRRJHaxNnEAEG/NAC4QccAACx/Q/WYAcWbQNs/Q8C
UAEAkAasbdH/4AegfAN4nAQ24EZJEABZwNgEUQYGfMYg/QZiUM9nYMACcMIlwALliweMTAYA
UAGzvdIcUAEsgGHicQCBoAcKgAu9NBLPGxIF7cIl4QEsYAcAIMdAog0AbREtDhIeMAMqbBJ+
EAAs8OP3W+RGfuRI7hAnnORMXhpL3uRQHuVS/h4BAQA7
--------------090405060001000106050206--

--------------060606060103050105080909--