Control Panel>>Admin Tools>>Data Services (ODBC)>>
2. From ODBC Data Source Administrator dialog, select
requires DSN type
(User DSN, System DSN, File DSN). From the selected DSN,
click ?Add? button and select the required driver and
click ?Finish? button.
3. From ODBC Text Set up enter the Data Source Name and
Select the DB and click Ok button.
Please Help Members By Posting Answers For Below Questions
how can db_files > maxdatafiles since db_files is for
instance and the later is for database
I have a parent program and a child program. I want to write
a statement in Exception Block of the parent program so that
when the statement in the exception block is executed, the
control goes to the next statement in the parent block
bypassing the child block.How do i do that?
How does propagation differ between Advanced Replication and
Snapshot Replication (read-only)?
Youre getting high busy buffer waits - how can you find
whats causing it?
20. Using a set operator, display the client number of all
clients who have never placed an order.
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2
2 RETURN NUMBER AS
3 new_str VARCHAR2(4000) := factstr||'*' ;
4 fact number := 1 ;
7 WHILE new_str IS NOT NULL
9 fact := fact *
10 new_str := substr(
11 END LOOP;
13 RETURN fact;
explanation Above program?
how to clone 9i Database on to 10g Database.
hello friends Im doing my final year engineering in B.Tech..
one of uncle said he can provide job in his company if im
good in database management. but i have only basic knowledge
about database, so like to join database management course
in good intuition. so friends kindly help me to get good
intuition because its my future.
defination of bitmap index
What query tells you how much space a tablespace named test
is taking up, and how much space is remaining?
what are steps for interface?
where is exchange rate defined in which table?
Differentiate between TRUNCATE and DELETE?
We are using Oracle apps with XML publisher.In that,we are
facing some problems while giving a Footer in RTF
Template.While giving a footer in RTF Template it is
Visible in all the pages,but after the PDF is getiing
generated,the Footer are Visible on alternate pages only
(like on first page ,third page) and so on.
Please provide the Solution for getting the Footer on all
1) WIll all the user get the DEFAULT profile, if their
current profile got deleted at any point of time?
2) What are the Situation we need to MOVE the TABLE between
3) What is the use of MOVING the TABLE between SCHEMA'S?
4) What are the Table Clause, Segment Clause and the
Datafile Clause which will override each other?
5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
how do we code triggers , store procedure , Performance
and indexing in a Java Project? Pls kindly get me the
perfect answer with the code for each....thank you in
advance............pls any body kindly help me soon as