| Subject | Date Asked | Expert |
|
| oracle | 7/9/2009 | Peter Choi |
Q: how to install oracle 10 i in vista 32 bit A: Oracle has an quick easy-to-follow visual guide available here: ...
|
| Clearing Oracle Database | 7/7/2009 | Peter Choi |
Q: I have a question about how to clearing Oracle 10.2.0.3 Database (clearing database files, free it) ... A: NOTE: This will remove the database as well as all the data in this database. Tables and tablespaces ...
|
| oracle - vb | 6/29/2009 | Edson |
Q: How to insert a jpeg file into an oracle table? How to print the same column into data report in ... A: You must create a column with the type LOB (BLOB or CLOB). After you must create a procedure to ...
|
| SQL | 6/23/2009 | Peter Choi |
Q: Sir, Kindly give me the difference between the Tracing and Auditing in SQL A: When you're performing a trace you are following step by step what the SQL is doing. This is ...
|
| Oracle 7.3.3 | 6/22/2009 | Peter Choi |
Q: Where I will get the Oracle 7.3.3 version for download?? A: Oracle 7.3.3 is no longer supported and is not officially available for download. You might want to ...
|
| DECODE Function in pl/sql | 6/21/2009 | Edson |
Q: There is a table with three columns name,location& sex.in name column there are different names and ... A: select count(*), sex, substr(location,..,..) from table group by sex, substr(location,..,..) If ...
|
| Zero Length condition | 6/20/2009 | Peter Choi |
Q: While creating table, there is options like allow null or not, similarly is it possible to implement ... A: You may wish to consult the Oracle 10gR2 CREATE TABLE reference: ...
|
| Default Constraint | 6/20/2009 | Peter Choi |
Q: Will you please help me to implement Default constraint for multiple columns using alter statement. ... A: Not understanding your business requirements, I can point you to several good references on creating ...
|
| Default Constraint | 6/20/2009 | Edson |
Q: Will you please help me to implement Default constraint for multiple columns using alter statement. ... A: When you create a database table, you have the option to specify a DEFAULT value. Using default ...
|
| Creating dynamic table | 6/16/2009 | Elliot Mak |
Q: I want a help in creating dynamic table as per the csv file. The csv file which is to be uploaded ... A: Good day Rocky If you are using v9.2, you may not have the ability to create an external table. I ...
|
| Query on plsql program | 6/16/2009 | Elliot Mak |
Q: Greetings Elliot Here is my requirement .. I am given the "column_ID"s of a table. Using that i ... A: I have a little bit difficult time to understand the situation. Here is what I did based on what ...
|
| Creating dynamic table | 6/15/2009 | Elliot Mak |
Q: I want a help in creating dynamic table as per the csv file. The csv file which is to be uploaded ... A: Good day Rocky, I will need to make some assumption based on your question. 1. A new table will be ...
|
| dynamically creating table as per the csv file | 6/15/2009 | Peter Choi |
Q: I want a help in creating dynamic table as per the csv file. The csv file which is to be uploaded ... A: There isn't an easy way to create a table based on a dynamic data set (i.e. varying columns and ...
|
| How to get all the childs,subchilds of parent record | 6/15/2009 | Elliot Mak |
Q: My requirement is to get all child, subchild of parent record. Consider this explanation: I want ... A: Good day Roshan To get the parent, child, and subchild is pretty straight forward with SQL. In the ...
|
| ABOUT DECODE AND SIGN in a single query. | 6/10/2009 | Elliot Mak |
Q: Please explain me what does this query do exactly: SUM( DECODE(SIGN(ic.f_i_soh_rglr_qty ... A: Good day Raghav SIGN function returns three values. They are -1, 0, and 1. If number < 0, then ...
|
| Sorting a set of Values in PlSQL | 6/8/2009 | Suchitra Joshi |
Q: i have question regarding sorting values using Plsql.. My requirement is to get N values from user ... A: Sorry for the delay. Reading value one by one in PL/SQL is not possible. For that you can use Unix ...
|
| data transfer from CSV file to database. | 6/6/2009 | Edson |
Q: I want to transfer the data stored in CSV(comma seperated value) file to Oracle Database table. Can ... A: So you must have to use the final choice, the utl_file. Utl_file is a oracle�ackage that ...
|
| Invalid Number while using to_char date and group by of same column | 6/6/2009 | Suchitra Joshi |
Q: I have been reading your answers. All you guys are doing a great service. Thanks a lot. I am ... A: If the SOME_DATE column is a date column, then it should not be given in single quotes (since you ...
|
| data transfer from CSV file to database. | 6/6/2009 | Suchitra Joshi |
Q: I want to transfer the data stored in CSV(comma seperated value) file to Oracle Database table. Can ... A: I am not understanding exactly what you want. If you want to create an sql file with insert ...
|
| data transfer from CSV file to database. | 6/5/2009 | Edson |
Q: I want to transfer the data stored in CSV(comma seperated value) file to Oracle Database table. Can ... A: There are some good ways to do it. The simplest way is to use a interface, just like PL/SQL ...
|
| data transfer from CSV file to database. | 6/5/2009 | Peter Choi |
Q: I want to transfer the data stored in CSV(comma seperated value) file to Oracle Database table. Can ... A: You can use SQL Loader ...
|
| Oracle Surrogate key on OLTP Loads | 5/29/2009 | Peter Choi |
Q: I am loading normalized structres from denormalized inputs and want high concurrency and fast load ... A: Here's a great thread from Oracle guru, Tom Kyte, on what's the best way for managing large/high ...
|
| sql | 5/29/2009 | Elliot Mak |
Q: EMPLOYEE) of database1 to the same table EMPLOYEE of database2. How to do it pls help me A: Good day Bhuvaneswari There are multiple ways you can copy the data from one database to the other. ...
|
| pl/sql | 5/28/2009 | Peter Choi |
Q: am going through a plsql procedure by which an xls file is created using util_file. My question is ... A: Here's a great article and example of creating an XLS (MS-Excel) file using utl_file. ...
|
| oracle error | 5/28/2009 | Peter Choi |
Q: I install Oracle 9i on my Windows Xp platform..but during login it shows me error no adapter ... A: The official installation documentation for Oracle 9i (9.2.x) on the Microsoft Windows 32-Bit ...
|
| Performance issue fetching millions of rows | 5/27/2009 | Peter Choi |
Q: I need your input on a decision. We have a 10g db running on Linux and want to do selects of say 500 ... A: Oracle's Real Application Cluster (RAC) provides higger availability and allow for multiple nodes ...
|
| imp in system..... (2) | 5/23/2009 | Peter Choi |
Q: Two days ago I asked advise on cleaning out my system user after importing a dump file rather ... A: Which ever way that you are comfortable with, will work. In the case of using 1a (Excel) you ...
|
| imp in system..... | 5/21/2009 | Peter Choi |
Q: I have a question and I really hope you have an answer :-) I received an Oracle dump without ... A: Ideally, you would have taken a database backup before you imported objects into your database. ...
|
| One software support Oracle 9i and Oracle 11g | 5/21/2009 | Elliot Mak |
Q: The software 'AAA' use the Oracle 9i as the database. Now we would like to use the Oracle 11g ... A: Good morning Ning, I will assume that you are upgrading your Oracle 9i database to Oracle 11g ...
|
| Making Data as Column Names for View | 5/15/2009 | Elliot Mak |
Q: Good day Sir! How do I create a view where the columns are based on data in the table?Is that ... A: Good day Vee, I apologize for the late reply. It is currently a long weekend here in Canada and I ...
|
| Search query | 5/13/2009 | Suchitra Joshi |
Q: i have to write a search statement on a table which is index based where the user wants to search ... A: If you have to search all remaining columns for my_search, then give the following conditions - ...
|
| PL/SQL function | 5/13/2009 | Elliot Mak |
Q: I have a requierement as below. - I have a formula (Ex: (120/(120+20))*100). I need to pass this ... A: Good day Uma When you are passing PL/SQL a formula, as you said in your email, PL/SQL interprets it ...
|
| Need some help un PL/SQL procedures | 5/13/2009 | Suchitra Joshi |
Q: I have a requierement as below. - I have a formula (Ex: (120/(120+20))*100). I need to pass this ... A: I am not sure if the following will work, but you can try it. 1) Pass formula p_formula as IN ...
|
| Two Oracle 10g DBs under two different AIX users | 5/12/2009 | Peter Choi |
Q: I have AIX Server 5.3 and installed Oracle 10g (10.2). One DataBase (DB1) already working under ... A: By using the ALTER SYSTEM SET LOCAL_LISTENER, you are forcing that database to use the specified ...
|
| Two Oracle 10g DBs under two different AIX users | 5/11/2009 | Peter Choi |
Q: I have AIX Server 5.3 and installed Oracle 10g (10.2). One DataBase (DB1) already working under ... A: 1. You need to make sure that you have defined 2 separate Oracle Homes. If user oracle1's ...
|
| How to avoid mutating error | 4/29/2009 | Suchitra Joshi |
Q: I have a table in which i need to insert a row. before inserting into that table i need to check a ... A: Here is logic you can apply - 1) Create a package and declare a variable for total issue qty in the ...
|
| Peoplesoft Tuxedo traffic | 4/21/2009 | Peter Choi |
Q: Peoplesoft 8 and 9 utilizes Tuxedo as the underlying technology)it handles traffic from the ... A: From a networking / infrastrcuture perspective ---------------------------------------------- In the ...
|
| Oracle error | 4/21/2009 | Peter Choi |
Q: Sir , My orcle 7.3 database is in Sco open server 5.6 RAM is 4GB while starting the oracle database ... A: Your problem may be related to how much memory is allocated to the SGA vs. what RAM is physically ...
|
| table | 4/20/2009 | Peter Choi |
Q: What is table? what is field, record,column and row and their difference? A: In databases, a table is composed of attributes, typically called columns. Theses columns (or ...
|
| file transfer | 4/14/2009 | Suchitra Joshi |
Q: How to convert oracle output text document into excel file. If its possible please suggest me. ... A: These are some ways to convert oracle output to excel file - 1) Using TOAD - select the rows from ...
|