You are here:
Oracle/Questions Answered by Expert Kaustav Neogy
| 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 ... | |
Oracle
Kaustav Neogy
Top Expert on this page
Expertise
can answer queries related to SQL, PL/SQL, triggers, D2K forms, reports.
Experience
i've been using oracle/D2K since 1999.
©2012 About.com, a part of The New York Times Company. All rights reserved.