-
Timezone of database
How to find the timezone of the database?
-
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.
-
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.
-
-
-
Trigger Body
We have a trigger on database. In the trigger body we have created a body using dbms_output.put_line(********) ;How to fire this ?
ushaudayam
- Aug 22nd, 2008
Trigger is a pl/sql block that is automatically invoked on an event, when any DML command is used on corresponding table.Triggers are classified into different categories based on when they are to be ...
-
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
-
System Parameter
What are the System Parameter in Reports 6i? Where do we make use of these paramaters?
-
Rebuild Index
Why do we have to rebuild an index?
-
Dear Sir,My question is thatI want to add two columns i.e one from first group and another from seconf group. for ex f15 from g_cost_code f17 from g_area_code I think I have to make a placeholder column and add it to g_area_code group but I am not sure please help.Regards,Ashutosh Trivedi
hkrishna
- Jul 28th, 2008
Hi Friend,Question is not clear, I think you need to add a column for particular table.Just do like, alter table add column datatype;this will take you add a column in a table.
-
-
Procedure Parameter
How to take a Table Name as Parameter in Procedure?
-
Can anybody resolve this problem?">
Hi all, I recently installed Oracle 9i database and Oracle forms6i in my system. I couldn't access database through forms.If i try to connect, "ORA 12203: TNS: unable to connect destination" error is occured.Can anybody resolve this problem?
babuda
- Jul 14th, 2008
I am not sure abt this but I was successful when I did this 2 years agoOpen tnsnames.ora filetake a back upchange the service from dedicated to permanent. I am not sure which one is itORCL01 = (...
vijay
- Sep 12th, 2007
First you create database and user in Oracle 9iMapping for all database?using?tnsnames.ora file?and save it. Create DSN and connect
-
Store Image in Oracle
How to store Image in Oracle table
singh.neerajin
- May 28th, 2008
It is always better to store the images in the BLOB or CLOB datatype.......PROCEDURE apply_changes_to_illust(path varchar2)IS f_lob BFILE; b_lob BLOB; image_name VARCHAR2(30); ...
-
Multiple Row Values
How to retrieve multiple row values in a single column
lanka_satya
- Jul 4th, 2008
Dear friend, I didn't get exactly what you want,any please tell me the context so that i can help you out................coming to the question:you want the result of multiple rows in a singl...
-
What are SQL complimentary 1999 joins? How can we know whether my oracle version supports them?
lanka_satya
- Jul 4th, 2008
oracle supports two types of joins: 1.oracle joins cartesian join equi join non equi join self join outer join is exhibited ...
pawan ahuja
- Mar 8th, 2006
Hi all,Actually we r talking abt the ANSI join syntax,That's available in oracle 9i.this join cannotbe run in lower version means oracle 8i(8.17),oracle 9i releases1.The join syntax is left outer join,rigth outer join,full outer join.natural join,RegardsPawan Ahuja91(9342927335)
-
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.
-
Why is Datatype VARCAHR2 why not VARCHAR1 or VARCHAR0 orIs there VARCHAR3 too
rajeshasha
- Jul 4th, 2008
First of all this is a convention.Second thing is that if they start writing as varchar1 people will be confused this with char so they named it like this.
-
Store image, music and multimedia formats
How to store .jpg ,and .mp3, .mov formats in Oracle database?
-
Why do we need to use 'WHERE CURRENT OF' clause
saginandkishore
- Jun 24th, 2008
Where current of is used for updating the data referenced by cursor which was created as "SELECT FOR UPDATE".DECLARECURSROR MY_CURR IS SELECT COL1, COL2,...
shamkohli
- Jun 17th, 2008
While using cusor in PL/SQL, when we update a record, we can write WHERE CURRENT OF along with cursor_name.This is done in place of the where condition while updating. If we gi...
Oracle Basics Interview Questions
Ans