| Subject | Date Asked |
|
| Use LIKE in subquery (WHERE clause) | 9/30/2008 |
Q: I would like to be able to use the results of a subquery in the where clause of the outer query ...
A: Try the following way. I have changed in your query, only the 'where' section. select myfield from ...
|
| Returning only a month from a date value | 9/26/2008 |
Q: I am currently trying to add a line to the where clause of my query so that the query only returns a ...
A: As I understand form your query that you are trying to fetch records based on Months. Try to ...
|
| Performance tuning | 7/23/2008 |
Q: What is performance tunig in oracle?
A: Please go through the link mentioned below. You will get to know about lot many things about ...
|
| Joining Null Columns | 7/22/2008 |
Q: Here is myI have two tables, Table tmp1: CODE1 CODE2 CODE3 NAME_EN ...
A: There is small change in your code as follows Try this, SELECT t1.code1, t1.code2, t1.code3 , ...
|
| diffrences in 10g and 9i | 7/16/2008 |
Q: kindly give answer as soon as possible. we are using the oracle 9i in our company. now we r going to ...
A: There should not be any problem while upgrading to 10g. 10g will support all the features of 9i. But ...
|
| Oracle Package and Stored Procedure | 7/11/2008 |
Q: I have created a Package and a procedure inside the package. I wanted to test this using sql ...
A: Please try the following process in sql plus, SQL> set autoprint on SQL> variable x refcursor; SQL> ...
|
| jd edward? | 7/9/2008 |
Q: i am pooja, i am a software engineer. could u tell me what exactly is an JD EDWARD package. for ...
A: J D Edwards is an ERP software.I don't have much idea about this. But, I can tell you that anything ...
|
| insert with select command | 6/2/2008 |
Q: I have a problem with insert statement with select. I have two tables named tbl1 and tbl2 with 5 ...
A: Here is the solution: INSERT INTO tbl_temp2 ...
|
| Using MINUS in collection | 5/28/2008 |
Q: I am using 10g. There is one nested table defined as type. There are two variables of this type. How ...
A: Basically you want to use the minus functionality for nested tables. In 10g there is a new feature ...
|
| oracle | 4/3/2008 |
Q: i would like to ask if u know any SQL,PL/SQL tutorial sits with examples. i would really appreciate ...
A: Please see the below link for your SQL and PL/SQL ref. SQL: ...
|
| doubt | 4/1/2008 |
Q: what is the difference between view and synonym? Plz give atleast four differences.
A: Following are the differences. Synonym is representation of a table. View can be created more ...
|
| oracle dba | 3/20/2008 |
Q: Hope u r doing fine,pls tell me how to start tuning from basics.
A: Plz start with the below document. Hope it will be easy for you understand tuning. ...
|
| PL/SQL insert inside a procedure | 3/19/2008 |
Q: King, I'm new to PL/SQL and am writing a program that does a variety of things. I am using ...
A: please send me the whole code if possible. like from type declaration to procedure writing. i am ...
|
| oracle | 3/3/2008 |
Q: what is sub query?
A: A sub-query is a query within a query. In Oracle, you can create sub-queries within your SQL ...
|
| Procedure execution , Toad Hangs | 2/27/2008 |
Q: Greetings , I was trying a simple block of PLSQL , but everytime when i execute it , The toad hangs ...
A: Nice to get questions form you. Thanks. Your code is absolutely fine,flawless. What i am suspecting ...
|
| pl/sql | 2/18/2008 |
Q: Begin Do something Begin Do something1 Exception Here handling Exception End ; ...
A: First of all you have to remember the basic structure of the pl/sql block that is begin do something ...
|
| Selection of Raddom Records | 12/11/2007 |
Q: for example i have a 100 questions in database, i want to select any 10 questions at randomly at ...
A: You want to fetch values from the database randomly. It is very simple. you have to use dbms_random ...
|
| Group by difference between Oracle 8 and 9 | 12/7/2007 |
Q: I have a group by in Oracle 9 that doesn't work in Oracle 8. The place where it fails and give me an ...
A: expression you are using in the SELECT list that was not in the GROUP BY clause. This is the rule ...
|
| Alternate login to remote DB using sqlplus | 10/5/2007 |
Q: I'm an sqlplus newbie and here's my doubt. I'm working on Unixes where the ORACLE_HOME installations ...
A: $ORACLE_HOME/bin/sqlplus ...
|
| oracle | 10/4/2007 |
Q: how to display the last 10 rows in atable of n rows
A: Try the following query to get the desired result. Please change the table name and column name in ...
|
| data type for dollar amount | 9/27/2007 |
Q: is there any specific data type for dollar amount other than number and integer data types.Please ...
A: To represent any currency(nothing but a float value)in Oracle you have to use the number(p,s) ...
|
| A pl/sql question. | 9/24/2007 |
Q: I am stuck in a query can you help. The question is that. Given that the salary earned by an ...
A: Create the test table us_employee and try the below procedure.Please change the column name ...
|
| Collection | 9/18/2007 |
Q: I have a procedure and it has one input prameter as collection(array type). From the front end the ...
A: There is one function called SET(collection_name) for removing duplicates from your collection. Add ...
|
