RE: query prob

thanks a lot.. one more thing...how to get the value of return key using sql.. i mean using gui data is entered and the user used enter key for next line so how to get that Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes

query prob

test where note like ' %' ; plz provide me query to get the leading as well as trailing spaces.. thanks in advance Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see

total table count

hi all i am new to MS Access database (mdb's). i want to know how to get count of tables in mdb(MS Access) file.. we use select * from tab in oracle, but this doesn't work with access. if anyone know..plz reply ASAP Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022

RE: DUPLICATE VALUE CHECK

hi all thanx for all those who contributed... my prob is solved now.. special thanks to rudy zung.. thanks again Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see

RE: DUPLICATE VALUE CHECK

CHECK Hi Shirish, FWIW: Function-based index? Reverse index? for case II? Have you considered either of these options to ease the pain of that query? HTH Lisa Koivu Clumsy Ninja-ette (WA!) Ft. Lauderdale, FL, USA -Original Message- From: Shirish Khapre

RE: DUPLICATE VALUE CHECK

i am getting duplicate records if the whole (say XYZ_A_LO_001) value is repeated without much probs.. but my prob is checking duplication of the last 7 digits.. Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes

RE: dual error

is is solved now Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank

RE: dual error

thanks all,,my probs with dual is is solved now Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish

sqltext query

clarify.. Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED

RE: dual error

it creates various support tables and views for eg dual, or tab(when u do select * from tab) etc for more info open the sql.bsq from u'r orant/home/rdbms80/admin/sql.bsq Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes

duel error

Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services