RE: How apply cursor attribute to non-cursor %NOTFOUND

LP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amjad Saiyed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

RE: Suggestions for a single sign on in Forms and Reports ....

ase see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amjad Saiyed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---

RE: Finding out last 10 records

ACLE-L Hi Santosh, If I understand your requirement correctly, this could be the solution for first 10 records : select * from TABLE_NAME where rownum<=10 order by rowid; for last 10 records : select * from contract where rownum<=10 order by rowid desc; MILIND SHITOLE [EMAIL PROTECTE

RE: To_Char Problem

ODY, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amjad Sai

RE: Finding out last 10 records

rder by rowid desc; MILIND SHITOLE [EMAIL PROTECTED] >From: "Amjad Saiyed" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Finding out last 10 records >Date: Wed, 14 Aug 2002 04:28:24 -0800

RE: Finding out last 10 records

i thought santosh wanted records based on value that is 1st 10 minimal values and last 10 max values...well if this is not the case than the solution that i had send using rownum is obsolete and hence ignore it   rgds, Ams. www.medicomsoft.com. -Original Message-From: [EMAIL PR

RE: Finding out last 10 records

Hi Santosh,   i assume that u will b ordering the query based on some criteria so say u have table A with column x   for finding the 1st 10 records we will use the following query:   select x from A where rownum < 11order by 1 /   for finding the last 10 records we will use th

RE: Slow Application

ou may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amjad Saiyed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Transferring data from one table to another

- Sent: Monday, August 12, 2002 11:23 AM To: Multiple recipients of list ORACLE-L Thank you, Amjad, The problem is that then I have to write a procedure for each of the tables. I was looking for something that could be set at database level and would apply to every table. Aleem -Original

RE: Transferring data from one table to another

#x27;) 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amjad Saiyed

RE: TO_CHAR got one space in front

well that space is used 4 the sign bit...   rgds, Ams. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of shuanSent: Monday, August 12, 2002 6:53 AMTo: Multiple recipients of list ORACLE-LSubject: TO_CHAR got one space in front Hi all,  

RE: How to insert Special Characters ?

TECTED] (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). | | -- Please see the official ORACLE-L F

RE: Select Query - Help required

CLE-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). | | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amjad Saiyed INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: OS

moved from). You may |also send the HELP command for other information (like subscribing). | | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amjad Saiyed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: where should i start to learn to become a DBA?

istGuru') 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). | | | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -

RE: dblink problem ( ORA-02019 )

this list is made to help each other... i hope u can understand...   thanx and regards, Amjad. www.medicomsoft.com   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Anand Kumar N - SystemsSent: Tuesday, July 16, 2002 11:03 AMTo: Multiple

RE: partitioned tables and the optimizer's behavior

ge 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). -- Please see

RE: cursor and no data found

/www.orafaq.com -- Author: Amjad 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 ma

RE: dblink problem ( ORA-02019 )

CREATE  PUBLIC DATABASE LINK dblink CONNECT TO user IDENTIFIED BY password USING ’connect_string’ Regards, Amjad.  www.medicomsoft.com : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Anand Kumar N - SystemsSent: Thursday, July 11, 2002 9:33 AMTo: Multiple recipients of list

RE: Delete query...question.

t, 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: dblink problem ( ORA-02019 )

. Regards Amjad. PS: hey give my regards to Murtuza Chitalwala working in ur company (New Bombay). thanx. -Original Message- Kumar Singh Sent: Wednesday, July 10, 2002 4:53 PM To: Multiple recipients of list ORACLE-L hi i have 3 databases(A,B,X) on 3 diff boxes. i have created 1 dblink each

RE: Error on creating index

try waiting 4 some more time while creating index it usually takes time if number of records r more.. regds, Amjad. www.medicomsoft.com -Original Message- Sent: Tuesday, July 09, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Thank you all for your interest. 1 - I

RE: Error on creating index

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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amjad INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: table size.

-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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amjad INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-

RE: converting fmt to fmb

Title: converting fmt to fmb Hi Amar,   use the following to convert ur files   ifcmp60 along with the various parameters that u want to pass   regards, Ams. www.medicomsoft.com   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Amar Kumar