-
Rebuild Index
What is rebuild index, why do we need to rebuild the index?
saikatrana
- Feb 1st, 2009
If you want a table moved from its own tablespace to other, then you have to rebuild index.Command:Alter Index index_name rebuild online;
-
What is variable size when showing SGA?
Variable portionThe variable portion is called variable because its size (measured in bytes) can be changed. The variable portion consists of: • large pool (optional)Provides working space for rman (although rman will also work without large pool). • Shared pool The shared pool is used for objects that are shared among all users. For example: table definitions, PL/SQL definitions, cursors and so on.
sairavi.dba
- Jan 31st, 2009
In SGA, variable size is combination of shared pool, Java pool and Large PoolSQL> show sga;Total System Global Area 612368384 bytesFixed Size &n...
dheeraj narula
- Dec 27th, 2008
Dynamic SGA allows Oracle to set, at run time, limits on how much virtual memoryOracle uses for the SGA.So under dynamic(variable ) SGA portion, in intialization parameter file the parameterSGA_MAX_SI...
-
">
What is the difference between "NULL in C" and "NULL in Oracle?"
zelani
- Jan 12th, 2009
null in c is some garbage value which cannot be predicted . If you are not intialising any value to the variable then null value is present in auto variables.null in oracle is used in sql queries for ...
symhdl
- Jan 3rd, 2009
This is not truely the right answer.When you store data in oracle its terminated with a zero byte. For example when you store HELLO its stored as 5HELLO where is the zero byte. When you don...
-
Create a report for the HR department that displays employee last names, department numbers, and all the employees who work in the same department as a given employee. Give each column an appropriate label.
-
What are the differences of view and materialised view
gautthamm
- Dec 31st, 2008
After update of the table, the view automatically gets synchronized where as the Materialised view needs an explicit refresh (either Manual or by Oracle) for synchronisation.Another diff is that the r...
Jirange
- Oct 15th, 2008
View is a replica of table.Materialized? view is remote table on local database.
-
Rownum is used to get tha top-N values. What if I want to know the value at specific position?EX: A table emp has two columns e_name and e_salary. How can I list the e_name of the employee who is getting the third highest salary?
ashishpandey52
- Nov 12th, 2008
select e_name,e_salary from emp where e_salary=(select min(e_salary) from (select e_salary from emp order by sal desc )where rownum<4;
myhotinterview
- Jun 3rd, 2008
I think we can also use this:select emp_name from from where rownum=3 order by salary desc
-
Oracle Exception
How many exception in Oracle?
ravula sudheer
- Oct 18th, 2008
In Oracle there are two types?of exceptions.USER DEFINED EXCEPTIONS.DEFINED EXCEPTIONS..(NO_DATA_FOUND,VARIRABLE LENGHT TOO LONG .. etc.)
-
Sub Queries Alias Name
SELECT * FROM (SELECT ROWNUM,ENAME,JOB,SAL FROM EMP WHERE ROWNUM
sureshkumar.mtech
- Oct 11th, 2008
Here compulsory to give the alias name for rownum because the column name is not exist in the table so it's show error for invalid columns specification.The query should be below;select * from (select rownum as num, last_name, salary, id from employeewhere rownum
-
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
-
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.
-
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.
-
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