<div class="Section1"><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size:
10.0pt;font-family:Arial;color:navy">Hi All,</span></font><p class="MsoNormal"><font color="navy" face="Arial"
size="2"><spanstyle="font-size:
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy">I have a query regarding database.</span></font><p class="MsoNormal"><font
color="navy"face="Arial" size="2"><span style="font-size:
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy">I have database ‘customer’ which is having schema ‘cust.’</span></font><p
class="MsoNormal"><fontcolor="navy" face="Arial" size="2"><span style="font-size:
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy">I have added my tables and data into ‘cust’. But when I try to run the sql queries
againstthis schema I need to add ‘cust’ as a relationName for every query. But same is not applicable for public
schema.</span></font><pclass="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size:
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy">Same is applicable when I query with jdbc.</span></font><p class="MsoNormal"><font
color="navy"face="Arial" size="2"><span style="font-size:
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy">Can any one guide me how can I make my ‘cust’ schema to work like public schema
meansfor all the sqls I don’t need to append schema name as relationanme.</span></font><p class="MsoNormal"><font
color="navy"face="Arial" size="2"><span style="font-size:
10.0pt;font-family:Arial;color:navy"><br /> Thanks</span></font><p class="MsoNormal"><font color="navy" face="Arial"
size="2"><spanstyle="font-size:
10.0pt;font-family:Arial;color:navy">Amar</span></font></div>