| Subject | Date Asked |
|
| Number data type. | 7/7/2006 |
Q: I'm confused. If you have something like number(5,2) are you able to have 5 digits to the left of ...
A: when you declare a variable as number(m,n), it signifies the number comprises of "m" digits(0-9) out ...
|
| with check option constraint | 6/7/2006 |
Q: Can you please explain to me the with check option constraint?
A: this constraint checks the condition specified on a column whenever you do an insert/update to that ...
|
| question | 4/13/2006 |
Q: I have some questions, answer what you can, please number them some so I don't get confused, like if ...
A: 1. MySQL, PostgreSQL, Oracle, MS SQL, DB2 etc are all various kinds of RDBMS/DBMS which use SQL. ...
|
| Oracle SQL help | 10/26/2005 |
Q: I have 2 questions which I hope you will be able to answer for me. I have the following questions ...
A: query 1. select a.sname, a.sal from staff a where a.sal > (select sal from staff where sname = ...
|
| Oracle Forms 9i | 10/16/2005 |
Q: Kaustav, I hope you are doing fine and well, i extend my best wishes for you. Kaustav, i am a ...
A: you might check out the following links and see if it helps- ...
|
| LEFT OUTER JOIN | 9/30/2005 |
Q: I am using an ORACLE 9 server, and I am trying to select records from 2 tables using LEFT OUTER ...
A: try this - SELECT AWARD_ENTRY.AENT_COMPANY, AWARD_ENTRY_CREDIT.AENC_LAST_NAME, ...
|
| 0/0 PL/SQL: Compilation unit analysis terminated | 10/18/2004 |
Q: I have written a procedure in which i am just executing query. But i get error when i create ...
A: why the duplicate declaration of variables as in - Create or replace procedure test(a IN integer, b ...
|
| Improving database/webserver efficiency | 10/13/2004 |
Q: I was wondering if you could help me with an efficiency problem I'm trying to fix on my university ...
A: I am not the next door Java kind of a guy so wouldn't be able to help you much in this regard. ...
|
| Including dynamic graphics into reports | 10/13/2004 |
Q: I am quite new to Oracle Reports and I need some help with the above mentioned subject. I shall ...
A: I guess one way to go about this issue is to create a blank image file named noimage.jpg. Place it ...
|
| Why does the following statement return all record from shipment? | 10/7/2004 |
Q: But, [select clientid from shipment where destination = 'toronto'] returns only one record ?? ...
A: does changing the order to something like this make any difference - select client.clientname from ...
|
| object type query | 5/23/2004 |
Q: If i have a database for personal details, with attributes of. Title First Name ...
A: it should be something like this - create or replace type personal_details_type as object ( ...
|
| Oracle | 5/17/2004 |
Q: I created a login page that needed user their username and password to login, and I have populated a ...
A: you can try something on these lines - The query should be like - SELECT Username, Password FROM ...
|
| About OCA | 2/13/2004 |
Q: sir, Presently I am doing MCA. I am intrested to complite OCP but Presently I am just want to ...
A: after completing OCA, it would certainly be difficult to get entry level jobs too, as even people ...
|
| 1st 3 max records | 12/15/2003 |
Q: there is one table with 2 fields id & salary having 5 records--> id salary a1 ...
A: you can try this - SELECT * FROM (SELECT salary FROM table ORDER BY salary desc) WHERE ROWNUM <= 3 ...
|
