-
Map Discrete Data Sources to db2
How to map data from discrete sources like Notepad, MS-Excel, MS-Word to db2
-
Migrate db2 data to Notepad
How to migrate db2 data to notepad?
swaroopbns
- Apr 30th, 2008
Do you mean that you want to unlaod a db2 table into a notepad or textpad, then you can probably try this:db2> export to yourdirectory/abc.txt of del select * from tablename with ur
-
How can we retrive first row in a table?
-
DDL and DML
Why do we need a DDL and DML in a database system?
laikka_buddy
- May 5th, 2008
DDL is nothing but Data Definition Language . It is very important for a dadabase that we have to define the data such that we can create tables , alter tables, truncate and drop tables
ugly1
- Jan 25th, 2008
DDL stands for data definition language and DML stands for data manipulation language.DML changes data in an object (eg-insert,update,delete) and when we create,change or remove a database object thats DML (eg-create). so both are important.
-
Select clause execution
in the select clause there are few keywords like SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.. i would like to know execution of the select statement means which one executes first out of these keywords and their execution sequence.
-
Inserting Image
How to insert image into Sybase image data type field?
-
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...
-
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...
-
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;
-
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
-
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...
-
Strongest Normal Form
Which one is strongest normal form? Why?
-
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---...
-
POPULATE_GROUP(function) POPULATE_GROUP_WITH_QUERY(function) SET_GROUP_CHAR_CELL(procedure) SET_GROUP_DATE_CELL(procedure) SET_GROUP_NUMBER_CELL(procedure)
-
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
-
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 ...
-
-
Parallel Exender
What is the main difference between Parallel Exender and previous Parallel Editions?
-
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
-
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.
Oracle Concepts Interview Questions
Ans