-
Can any one tell me how to configure orcale(8i or 9i) database to work with jdbc means after installing the oracle 8i/9i software i am unable to connect database using jdbc program
Amanpreet Kaur
- Feb 21st, 2007
One has to configure jdbc odbc driver in case of windows. and set the oracle variables and environment paths. java will be connected to oracle.
PurnaChandarrao
- Feb 13th, 2007
Hai First you have to create DSN name ; Control Panel--->Administrative Tools--->DatabaseSources(ODBC) And give new DSN name and configure with your Data base either it is Oracle 8i or Oracle 9i se...
-
How to copy the tables from one system to another or from one user to another user?
Means i have 150 tables in one system, i want to copy those tables into another system.
-
How to set the default values in Oracle using Alter command?
rajakumar_na
- Nov 16th, 2007
Hi taraldesai! Y Not?Here is the example Try thisALTER TABLE table_nameADD (column datatype DEFAULT expr);(or)ALTER TABEL table_nameMODIFY (column datatype DEFAULT expr)
taraldesai
- Jun 23rd, 2007
Specify parameter there is nothing like you are asking..like alter system set default ... wrongalter system set sql_trace=TRUE;
-
Is it good programming practice to avoid the use of SELECT *. Is it better to list coloumn names. Why?
parthokonar1
- Aug 27th, 2007
Actually Oracle is made for query purpose not for FTS, and it obviously depends upon your requirements. In FTS oracle server process reads all the blocks concerned with the table and it is not so when...
taraldesai
- Jun 23rd, 2007
Depends, if you want certain columns then why to query whole data. bcoz it involves more IO, network traffic and many other things
-
What is the difference between bind and declare variable in pl/sql?What is the difference between number,integer, pls_integer and binary integer?
rajakumar_na
- Nov 17th, 2007
One more point Bind variables are declared outside the pl/sql block whereas declare variables are declared with in the pl/sql block
jamesravid
- Jul 18th, 2007
Bind variables are command line parameters.whereas declare variables are variables local variables declared with in the pl/sql code.scope of declare variables is within the procedure you can't use them outside of the pl/sql code. But bind variables are valid till the session is valid
-
What is the command to get the number of coloumns in table
Imran_Javed
- May 13th, 2008
SELECT COUNT(cname)FROM COL c, TAB TWHERE T.Tname = c.Tname AND T.Tabtype='TABLE' AND T.Tname ='EMP';
debasisdas
- Jul 7th, 2007
SELECT COUNT(COLUMN_NAME) FROM DBA_TAB_COLUMNS WHERE table_name = 'TABLE_NAME' AND owner = 'OWNER_NAME' ;
-
How do you decide on whether to use a Procedure or a Function for a particular task ?Is it possible to get the last 10 rows of a table? If Yes How?
jamesravid
- Jul 18th, 2007
For ur second question,select * from (select * from (select col1,col2,rownum as rank ...
jamesravid
- Jul 18th, 2007
I would consider the following points,1. Identify how many variable should be returned by your pl/sql code. If it is only one go for functions else go for procedures.2. Fuctions can be used in ur sql queries whereas procedures can't be used.
-
How SGA works if the user process issuing SELECT statement to the database?
dbashashi
- Jul 14th, 2009
Select statement works in the same way as other querries. The result set is brought from the Datafile if not already in Buffer cache. As we are aware that Buffer cache works on LRU and MRU algorithm ...
kishore.giri
- Dec 12th, 2007
When a query is submitted by the user it comes to the sharedpool and it is processed by the library cache i.e. statement is parsed their,execution plan is prepared and data is retrived from the datafi...
-
How to query data from table which has "GROUP" as column name, since it's keyword?
madhupriya.nukala
- Feb 3rd, 2008
U have to use this gropu as a column by specifiying it in "doublequotes"
madhupriya.nukala
- Feb 1st, 2008
Hi,??? Send me mail if satisfied .Thanks.MadhupriyaSQL> create table string("group" varchar2(20),name varchar2(20));Table created.SQL> insert into string values('&group','&name');Enter value for gr...
-
How to delete user wise data in Oracle 9i?
-
Oracle 9i Tools and Utilities
What is the difference between the tools and utilities in Oracle 9i?
lanka_satya
- Sep 12th, 2008
Utility is something which comes along with software?where it is intended to help us to solve a particular purpose but tool is something which enable us to develop more delebrately we can say as helpful for innovative development.
-
Replace option in Procedure
What will happen if you dont use Replace option in a Procedure when first creating it for first time?
garvi.1983
- Mar 5th, 2008
No problm. It successfully creates the procedure.But once it created ,if u modify it and compail without REPLACE ,it will give an error
-
Time taken by a query
What is the command to print the time taken by a query
hemant.agarwal03
- Feb 13th, 2008
you need to use set operetor TO GET THE TIME..LIKE THIS..SQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08SQL> SET TIMING ONSQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08Elapsed: 00:00:00.00now it will show time..
karunakaradepu
- Jan 29th, 2008
If UR Q is How TO PRINT A TIME: SELECT TO_CHAR(SYSDATE,'HH:MI:SS') FROM DUAL;
-
Composite Primary Key
WHat is Composite Primary Key?
hemant.agarwal03
- Mar 27th, 2008
Composite primary key used for multiple fields joined together to identify a records in a table. We can use maximum 16 columns for a composite primary key.
ddanda
- Mar 24th, 2008
when 2 attributes of the table form a primary key .such a key is known as composite primary key.
-
Oracle commit and commit work
What is the difference between commit and commit work
lanka_satya
- Jul 4th, 2008
actaully, both mean the same but try to understand what is commit?see..most of the people think that when we type commit data or changes of what you have made has been written to data files,but this i...
panjoshi302
- Apr 29th, 2008
As such there is no difference operationally. WORK is optional and is provided just for ANSI compatibility.
-
Null Memory
How to verify null occupy memory?
nrajakumar
- Aug 15th, 2008
Create table tblNull(col int)sp_spaceused tblNullinsert into tblNull(col) values(NULL)sp_spaceused tblNull
babuda
- Jul 14th, 2008
When we say memory occupy means it is allocated atleast a byte or char or storage space. when we run thisselect null from dual nothing is returned, in my opinion null does not occupy any storage spaceany thoughts? we can think it over
-
Is there any syntactical diff bet Oracle 9i & 10g
Is there any syntactical diff between Oracle 9i & 10g or any change in which the Queries are used....It uses SQL isn't it?
lanka_satya
- Sep 12th, 2008
In 9i we does not have the facility to brign the table that is been dropped, but in 10g we have something like flashback and also in 10g they have added one extra regular expression
meghnshah
- Jul 13th, 2008
In oracle 10g we have new datatype called binary double and binary float. 10 g also has collection api, which allows us to use procedures and funtion with collections. In Oracle 10g external procedures can also be called.
-
AND - OR Operators
In the combination of Logical Operators - AND, OR (more than 2) operators which one gets 1st preference.
-
Locking a User from performing DML Operation
Which command is used for locking a user from performing DML Operation?
karthikasathya
- Oct 1st, 2009
LOCK TABLE tablename IN EXCLUSIVE MODE;EX:LOCK TABLE emp IN EXCLUSIVE MODE;
-
Flow in Oracle Database.
What happens when a query is submitted in oracle? Please give the complete flow as to which all processes act and how the data is submitted / retrieved to / from the database .
Oracle Basics Interview Questions
Ans