<div>
that is, what type of database system are you using?
</div>


that is, what type of database system are you using?

<div>
Hi<br />
<br />
sorry for not mentioning full details<br />
<br />
i am using oracle database<br />
<br />
rajesh
</div>


Hi

sorry for not mentioning full details

i am using oracle database

rajesh

<div>
maybe you should ask this question in the oracle TA instead.
</div>


maybe you should ask this question in the oracle TA instead.

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
i had &nbsp;a user &quot;sim&quot; representing the main office having following tables <br />
acc_glday,cashes,day_one,d<wbr />ay_two andday_sub . for obtaining some consolidated <br />
reports from all branches i had created another user &quot;conso &quot;&nbsp;and created all <br />
the above tables on that user area also.<br />
i am importing data from all branches including the main office &nbsp;into tables in <br />
user conso. <br />
<br />
&nbsp;i would like to &nbsp;create a view by the union of tables of user sims and tables <br />
of user conso on the user conso. if i can do taht &nbsp; it is possible to avoid <br />
importing &nbsp;data from user sim to user conso and data redundancy can be <br />
eliminated.<br />
<br />
please help me for creating such a view of any of above mentioned tables on the <br />
user area conso.<br />
<br />
<br />
sincerely<br />
<br />
rajesh <br />
&nbsp;<br />

</div>
</div>


Hi

i had  a user "sim" representing the main office having following tables 
acc_glday,cashes,day_one,day_two andday_sub . for obtaining some consolidated 
reports from all branches i had created another user "conso " and created all 
the above tables on that user area also.
i am importing data from all branches including the main office  into tables in 
user conso. 

 i would like to  create a view by the union of tables of user sims and tables 
of user conso on the user conso. if i can do taht   it is possible to avoid 
importing  data from user sim to user conso and data redundancy can be 
eliminated.

please help me for creating such a view of any of above mentioned tables on the 
user area conso.


sincerely

rajesh 
 


Creating view of a table from another user

JavaServer Pages (JSP) allow the development of dynamically generated web pages. It uses the Java programming language; JSP pages are translated into servlets at runtime, with each servlet being cached and reused until the JSP is modified. JSP allows Java code to be interleaved with static web markup content, so the resulting page can be compiled and executed on the server to deliver the content.