You are here:
can answer queries related to SQL, PL/SQL, triggers, D2K forms, reports.
i've been using oracle/D2K since 1999.
| User | Date | K | C | P | Comments |
|---|---|---|---|---|---|
| Phil Adams | 09/04/06 | 10 | 10 | 10 | Right on time. Thank you |
| Mark | 06/09/06 | 10 | 10 | 10 | |
| Mark | 06/09/06 | 10 | 10 | 10 | |
| west | 04/15/06 | 10 | 10 | 10 | thanks for the answers they cleared things ..... |
| amit | 01/20/06 | 10 | 10 | 10 | Thanks Buddy... It's really quick n great |
Hi Mark, when you declare a variable as number(m,n), it signifies the number comprises of "m" digits(0-9) out of which 2 are reserved for the decimal(after the .) and hence 3 for the whole number part
Hi Mark, this constraint checks the condition specified on a column whenever you do an insert/update to that column data. For ex, if I have a column salary and have specified a with check constraint
Hi West, 1. MySQL, PostgreSQL, Oracle, MS SQL, DB2 etc are all various kinds of RDBMS/DBMS which use SQL. Does that make any sense? 2. Try use PHPMyAdmin. Its a free tool and available for download
Hi Jen, query 1. select a.sname, a.sal from staff a where a.sal > (select sal from staff where sname = 'SONG') query 2. select a.sname, a.SAL, a.MGR, (SELECT SNAME from staff where staffid
Hi Beenish, you might check out the following links and see if it helps- http://www.oracle.com/technology/documentation/forms.html http://www.oracle.com/technology/sample_code/products/forms/index9i

©2012 About.com, a part of The New York Times Company. All rights reserved.