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. 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-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
query prob
hi all i have one table in which the note column have following entries ID NOTE - 31177340 400A 31177374 FITZGERALD FENCE 31177394 FASHION BUG 31177454 PRECISION LITHOGRAVING 31177472 TOBIN BROS - VACANT 31177497 BRAID MILL 31177514 GRAIN STORAGE 31177528 EDGEWOOD COMMONS --- i want to find the leading as well as trailing spaces in the note field, i am getting the leading spaces using the following query select id,NOTE from 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 the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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) 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-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DUPLICATE VALUE CHECK
Title: RE: DUPLICATE VALUE CHECK is it possible in oracle 8.0.5? shirish -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: Wednesday, June 27, 2001 12:37 AMTo: Multiple recipients of list ORACLE-LSubject: RE: DUPLICATE VALUE 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 [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 11:42 AM To: Multiple recipients of list ORACLE-L Subject: DUPLICATE VALUE CHECK Hi all i have one column in my table (in which daily 10 rows are added to the table) which has values like XYZ_A_LO_001 XYZ_A_LO_002 XYZ_A_LO_003 XYZ_A_LO_004 XYZ_A_LO_005 XYZ_A_LO_006 XYZ_A_LO_007 XYZ_A_LO_008 XYZ_A_LO_009 i want to check duplicate values.. there are 2 cases of duplication Case I :- i am using the following query select from my_table where rowid not in( select max(rowid) from my_table group by my_column_name ); i am getting the rows which are duplicate .. CASE II : - i want to check duplication in last 7 characters(which are actually nos) in my column like 001 002 003so on i am using substr function to get this value and i am checking the values with remaining rows.. but as the table contains nearly 45(present rowcount) the query is taking lot of time...which i can't afford... the column has index on it. plz suggest me what to do?? 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] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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. 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-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dual error
i used sql.bsq and it worked shirish -Original Message- Sent: Wednesday, June 20, 2001 6:47 PM To: LazyDBA.com Discussion Can you enlighten us with the resolution ? -Original Message- Sent: 20 June 2001 14:18 To: LazyDBA.com Discussion 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 Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sqltext query
hi all i am using the following query to get the sql_text and user select a.ADDRESS,a.SQL_TEXT,b.USERNAME from v$session b, v$sqltext a where a.address=b.SQL_ADDRESS; the user has changes his password... but i am not getting the sql_text when the user changes his password plz 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] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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. 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-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
duel error
hi i accidentally dropped duel table from sys..then recreated it. now when i am using rman during running the catrman.sql for recovery_catalog it is flashing error select '08.00.05' from dual * ERROR at line 2: ORA-00942: table or view does not exist u'r help is highly appreciated 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] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).