Forms
Hi All If a form is developed using Developer 2000 on a window's 95 machine having a particular resolution of the monitor (eg.640 x 480 ) and installed on a machine with a different monitor resolution(eg.800 x 600) ,the window size of the form changes.Is there any method to the make these forms independant of the monitor resolution. Regards Systems. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Basic Database Question
Hello Even if any one table in a select contains no data,use of outer join will retrieve rows for you.Please note that outer join operator (+) is not allowed in operand of OR or IN. Regards System. |+--- || Gavin | || D'Mello | || gavin_d@tis.| || co.in | || | || 05/15/02 | || 07:33 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: Multiple recipients of list ORACLE-L | | [EMAIL PROTECTED] | | cc: (bcc: systems ho/VGIL) | | Subject: Basic Database Question | | Hi I'm just about to ask a really trivial question which has never struck me before. If i write a simple select like select c.contentid from content c, persusercontentassoc p, teachercontentassoc t where t.contentid = c.contentid OR p.contentid = c.contentid; and if the table persusercontentassoc is empty no rows are returned. However, if i populate this table i get meaningful data. So what i'm asking is if any one table in a select contains no data will the select always return no rows ? Thanks, Gavin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Basic Database Question
Hello Even if any one table in a select contains no data,use of outer join will retrieve rows for you.Please note that outer join operator (+) is not allowed in operand of OR or IN. Regards System. |+--- || Gavin | || D'Mello | || gavin_d@tis.| || co.in | || | || 05/15/02 | || 07:33 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: Multiple recipients of list ORACLE-L | | [EMAIL PROTECTED] | | cc: (bcc: systems ho/VGIL) | | Subject: Basic Database Question | | Hi I'm just about to ask a really trivial question which has never struck me before. If i write a simple select like select c.contentid from content c, persusercontentassoc p, teachercontentassoc t where t.contentid = c.contentid OR p.contentid = c.contentid; and if the table persusercontentassoc is empty no rows are returned. However, if i populate this table i get meaningful data. So what i'm asking is if any one table in a select contains no data will the select always return no rows ? Thanks, Gavin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Basic Database Question
Hello Even if any one table in a select contains no data,use of outer join will retrieve rows for you.Please note that outer join operator (+) is not allowed in operand of OR or IN. Regards System. |+--- || Gavin | || D'Mello | || gavin_d@tis.| || co.in | || | || 05/15/02 | || 07:33 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: Multiple recipients of list ORACLE-L | | [EMAIL PROTECTED] | | cc: (bcc: systems ho/VGIL) | | Subject: Basic Database Question | | Hi I'm just about to ask a really trivial question which has never struck me before. If i write a simple select like select c.contentid from content c, persusercontentassoc p, teachercontentassoc t where t.contentid = c.contentid OR p.contentid = c.contentid; and if the table persusercontentassoc is empty no rows are returned. However, if i populate this table i get meaningful data. So what i'm asking is if any one table in a select contains no data will the select always return no rows ? Thanks, Gavin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Basic Database Question
Hello Even if any one table in a select contains no data,use of outer join will retrieve rows for you.Please note that outer join operator (+) is not allowed in operand of OR or IN. Regards System. |+--- || Gavin | || D'Mello | || gavin_d@tis.| || co.in | || | || 05/15/02 | || 07:33 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: Multiple recipients of list ORACLE-L | | [EMAIL PROTECTED] | | cc: (bcc: systems ho/VGIL) | | Subject: Basic Database Question | | Hi I'm just about to ask a really trivial question which has never struck me before. If i write a simple select like select c.contentid from content c, persusercontentassoc p, teachercontentassoc t where t.contentid = c.contentid OR p.contentid = c.contentid; and if the table persusercontentassoc is empty no rows are returned. However, if i populate this table i get meaningful data. So what i'm asking is if any one table in a select contains no data will the select always return no rows ? Thanks, Gavin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Basic Database Question
Hello Even if any one table in a select contains no data,use of outer join will retrieve rows for you.Please note that outer join operator (+) is not allowed in operand of OR or IN. Regards System. |+--- || Gavin | || D'Mello | || gavin_d@tis.| || co.in | || | || 05/15/02 | || 07:33 PM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: Multiple recipients of list ORACLE-L | | [EMAIL PROTECTED] | | cc: (bcc: systems ho/VGIL) | | Subject: Basic Database Question | | Hi I'm just about to ask a really trivial question which has never struck me before. If i write a simple select like select c.contentid from content c, persusercontentassoc p, teachercontentassoc t where t.contentid = c.contentid OR p.contentid = c.contentid; and if the table persusercontentassoc is empty no rows are returned. However, if i populate this table i get meaningful data. So what i'm asking is if any one table in a select contains no data will the select always return no rows ? Thanks, Gavin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Order rows
Hi All Is there any method in Oracle to capture or order the rows in a table in the order they were entered. I tried it with rowid but when a row is deleted, the rowid corresponding to this row is reassigned for a new row which is inserted into the table at a later stage. Eg. SQL select rowid,abc.* from abc order by rowid; ROWID A -- -- AAAFmYAASAAAYsqAAA100 AAAFmYAASAAAYsqAAB200 AAAFmYAASAAAYsqAAC300 I deleted one transaction. delete from abc where a=200; commit; Then I inserted two rows. insert into abc values(500); insert into abc values(600); commit; Now when I order by rowid SQL select rowid,abc.* from abc order by rowid; ROWID A -- -- AAAFmYAASAAAYsqAAA100 AAAFmYAASAAAYsqAAB600 AAAFmYAASAAAYsqAAC300 AAAFmYAASAAAYsqAAD500 I.e The values I entered last appeared second.The rowid (AAAFmYAASAAAYsqAAB ) corresponding to the row I deleted was reassigned for the last entered row (a=600). What I want is that this must be sorted in the order of its entry. Can anyone help me out. Thanks in advance Systems. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Database Replication
Hi All We have got two Oracle Databases physically connected.We want to replicate one database with the other database.We are quite new to this subject.Kindly guide us with the procedure of replication and the conditions to be considered for replication. Thanks in advance Regards Systems -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).