-
Wat is the difference between object library and pl/sql library
mohtaak
- Nov 21st, 2008
Object group can be used within same form but Object library can be used through out the data base connectivity in any form.
akhileshkaddi
- Jun 23rd, 2006
when object library is attached to a form, complete object library are compile/used in compilation, assume that object library has some objects like 1, 2,3. But my form don't use 1,2 & 3 all, it u...
-
How we can findout the Nth largest No from the table.
prashant.kathole
- Nov 11th, 2008
select distinct sal from emp e where &n=(select count(distinct sal) from emp where e.sal<=sal);
Geetha
- Nov 5th, 2007
Select distinct sal from emp e where &n=(select count(distinct sal) from emp where e.sal>=sal);
-
Write a sql query to reflect changes made in one table if u have two tables Emp1& Emp2.
Mad Hatter
- Nov 6th, 2008
For example, if tables Emp1 and Emp2 both have identical structure, and some changes were applied in them, then MINUS can show the difference. Likeselect *from Emp1MINUSselect * from Emp2 UNIONselect * from Emp2 MINUSselect * from Emp1
ddkdhar
- Feb 10th, 2007
With triiger we can do this......but in sql there is no such thingbut we can do it by viewfor example emp1 is a table and emp2 is view .if you iinsert rows into view tht may maynot reflect in the base table
-
-
Log File Information
How can we get information about log files in the database?
UncaAlby
- Nov 3rd, 2008
That is a vendor-specific question.In Sybase, you can get log file information as follows:prompt$ isql1> sp_help {database} 2> goThat will list the devices used by the database, including log de...
-
How can we improve the data retrival speed?
chenw2000
- Jul 11th, 2008
The first thing I can think of is to do indexingsecond, modify the table structure to reduce the possible comparison like "where col like '%AA%'third, modify the query to retrieve less rows of intermediate data.
-
Tree Relationship
What is a tree relationship and give an example
narendranaidu.g
- Oct 16th, 2008
It is ahierarchical relation ship. In this structure parentnode (rootnode) and then child nodes, siblings etc
-
Parallel Exender
What is the main difference between Parallel Exender and previous Parallel Editions?
-
-
Hi, my question isIn a screen i have 1 datagrid with the data i have to do 2 things1)Save the data in the grid to the CSV format2)Load the Saved CSV format file into the grid as well as into the Sql Server database table at a time..
gtomar
- Jul 28th, 2008
Hi, you can do it directly also by saving datagrid as sql loader file .and then login to toad and choose csv file directly to load data into table.Thanks,Gunjan
gtomar
- Jul 28th, 2008
Hi,If you are using Toad then you need to follow up the steps given below:-1. Right click on the left top of the grid then Save datagrid in .xls format.2. Open .xls file and again ...
-
How to know max three salary and their sum from table
gtomar
- Jul 25th, 2008
Select sum(sal) from (select distinct sal from emp order by sal desc) where rownum < 4try this
ddkdhar
- Feb 12th, 2007
YOU CAN USE DENSE RANK TO RETRIEVES MAX SALARIES AND EMPLOYEES DETAILSSELECT * FROM ( SELECT A.* ,DENSE_RANK () OVER ( ORDER BY SALARY DESC ) R FROM EMPLOYEES A) WHERE R
-
POPULATE_GROUP(function) POPULATE_GROUP_WITH_QUERY(function) SET_GROUP_CHAR_CELL(procedure) SET_GROUP_DATE_CELL(procedure) SET_GROUP_NUMBER_CELL(procedure)
-
Tables in database
How to find how many tables in each data base
babuda
- Jul 14th, 2008
what abt this ? 1* select sum(count(*)) from all_tables group by ownerSQL> /SUM(COUNT(*))------------- 39SQL>
babuda
- Jul 14th, 2008
Someone need to confirm whether this is correct! Each owner is treated as schema(?),bang me if I am wrong 1* select count(1),owner from all_tables group by ownerSQL> / COUNT(1) OWNER---...
-
Strongest Normal Form
Which one is strongest normal form? Why?
-
1. What is Bitmapped indexes?2. What is b-tree index?
sweetytrivedi
- Jun 25th, 2008
B-Tree indexes are usually associated with the index that stores a list of ROWIDs for each key.While Bitmap is also organized as B tree , but the leaf node stores a bitmap for each value instead of a list of ROWIDs. B tree can be used for OLTP while bitmap is used for data warehousing system.
hemshikha
- Sep 1st, 2006
Conventional wisdom holds that bitmap indexes are most appropriate for columns having low distinct values?such as GENDER, MARITAL_STATUS, and RELATION. This assumption is not completely accurate, howe...
-
Case and Decode
What is the difference between Case and Decode?In what situation we can use Case and Decode
veerisetty
- Jun 18th, 2008
DECODE works with expressions which are scalar values.CASE can work with predicates and subqueries in searchable form:CASE is an ANSI standard, where as Decode is proprietary for OracleWe can use expressions as part of case statements, where as Decode looks for a value.regardsveerisetty
-
Explaint the nvl2 function
nandk.sharma
- Jun 16th, 2008
nvl2 function is the upgraded form of nvl function.In nvl function we need to pass two parameters.i.e. nvl(interest_rate ,returned_value) if the value of interest_rate is null then the nvl function r...
thumunagamani
- Jun 13th, 2008
Nvl2(exp1,exp2,exp3)if exp1 is null it manipulate exp3,if exp1 is not null it manipulates exp2eg:select ename,nvl2(comm,comm+sal,sal) net from emp;
-
Alleviate i/o problem in the new Oracle 10g database
If new Oracle 10g database will soon replace the current database, the old database has serious performance problems that seemed to be caused by an overload on the disk drive's i/o channel. Your analysis has also shown that two important and large tables are frequently accessed the CAR-PART table and ENGINE-PART table. You have a new computer with three large - capacity disk drives F,G and H describe...
-
What is Retention Policy for backup?
Kandeepan
- Jun 4th, 2008
How many days, we are going to retain the data after taking the backup. For example the data which backed up today that will get expire in 90 days. That means, it is 90 days retention policy for backup
Mohammed Abdul Afroze
- Oct 30th, 2007
You can configure retention policy command to create a persistent and automatic backup retention policy.When a backup retention policy is in effect, RMAN considers backups of datafiles and control fil...
-
Inserting Image
How to insert image into Sybase image data type field?
Oracle Concepts Interview Questions
Ans