What is the meaning of I and G in Oracle 9i & 10g versions

poonam192005

 Profile Answers by poonam192005 Questions by poonam192005

• Nov 2nd, 2010

Meaning of i in ORACLE 9i is INTERNET and meaning of g in ORACLE 10g is GRID COMPUTING

Answer Question  Select Best Answer

How can I insert an image into oracle database?

Mythili karanam

• Aug 9th, 2011

1)Create one directory in OS(Operating System) Place all the images in this directory 2) create one directory in data base with the link of this os directory eg:E:ordb Create table images(img_na...

Answer Question  Select Best Answer

Which type of binding does PL/SQL use?

kanhaiya

• Oct 9th, 2014

Early binding

Answer Question  Select Best Answer

Dear All,Suppose i have Excel table and within that i have some records. Please tell me the SQL query so that i can create table and populate the Excel sheet data

vannalas

 Profile Answers by vannalas Questions by vannalas

• Feb 17th, 2011

Elaborate the question.?

Answer Question  Select Best Answer

dinesh.smhdr

 Profile Answers by dinesh.smhdr Questions by dinesh.smhdr

• Sep 13th, 2011

"oracle8 declare cursor c_emp (cin_No NUMBER) is select count(*) from employee where id = cin_No; v_deptNo employee.id%type:=10; v_countEmp NUMBER; begi...

Answer Question  Select Best Answer

Supplier Name
Supplier Site
Supplier Street
Supplier Contact Person
Supplier City
Supplier State
Supplier Phone number

Business requirement is : One Supplier can have multiple ( n number of
Sites ), One Supplier Site can have Multiple Contacts Persons ( n
number of Contact persons ), One Supplier Contact Person can have
multiple phone...

ashadevi21

 Profile Answers by ashadevi21 Questions by ashadevi21

• Oct 5th, 2011

Supplier Table Columns : Supplier id , supplier name (Supplier ID, supplier name as Primary Key) Supplier Site Details Columns : Supplier name , site, street, city, state (Supplier name as foreign Ke...

Answer Question  Select Best Answer

DEPARTMENT_ID ,EMP_COUNT, DEPT_PERCENTAGE

VIBHAV MISHRA

• Jun 30th, 2014

Update

Answer Question  Select Best Answer

what is the size of parameter that we passed in sql query

Kumar

• Sep 27th, 2011

32765 bytes(32KB)

Answer Question  Select Best Answer

What is the difference between inner join and outer join?

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Sep 30th, 2011

First to define what Inner Join and Outer Join mean. Inner Join: A join between two tables were only those records in both tables that meet the conditions of the join expression are returned. In most...

Answer Question  Select Best Answer

indira

• Feb 1st, 2012

Sub query: A sub query is executed once for the parent statement. Correlated Sub query: Correlated sub query runs once for each row selected by the outer query. It contains a reference to a value fr...

Answer Question  Select Best Answer

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Feb 18th, 2012

Force view creates the view even if the underlying tables / referenced objects are not present. Force View are used while executing a script that has create tables and views statements or while creating a view for remote table.

Answer Question  Select Best Answer

Hi,

I have 3 files each having 2 cols
e.g
File1
empid deptid
1 100
2 200
3 200
4 100
5 300

File2
empid salary
1 10
2 20
3 30
4 40

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Mar 2nd, 2012

I believe what you are looking for is a query like this:

select f3.deptname dept_name, sum(isnull(f2.salary,0)) amt_spent_each_dept
from file3 f3 left join file1 f1 on (f3.deptid = f1.deptid)
left join file2 f2 on (f1.empid = f2.empid)
group by f3.deptname
order by f3.deptname

Answer Question  Select Best Answer

V.E.Rajani

• Oct 3rd, 2012

Only SELECT statement can be used in Functions. INSERT,UPDATE,DELETE are used.

Answer Question  Select Best Answer

In a table the persons name is in lower case "abc" and is there any SQL query to obtain that persons name as "ABC" as an output?

Muzeeb

• Jan 6th, 2013

Yes, using SQL UPPER function.

Code
 

Answer Question  Select Best Answer

Explain the normalization and why it is done. explain the case when we avoid the normalization in database.

ppad001

 Profile Answers by ppad001 Questions by ppad001

• Feb 27th, 2013

For perfomance optimization.
Like in case of datawarehousing operation the no of tables to be joined to get the desired output might be too high. In such a case we de-normalize to serve our purpose.

Answer Question  Select Best Answer

Aria Ansari

• Nov 12th, 2013

It is about referential integrity or making data both reliable and Secure. As an example by applying a foreign key constrain between customer and order tables It will not be allowed to create an order...

Answer Question  Select Best Answer

I want to add a new column in our table and i already have 4 column in table i want that my column should be added at 3rd position not in last position ..

S. Venmathi

• Jan 5th, 2015

if we are a Admin there is some possible. As my thought, it is not possible. but we can change the order of the column when we show the table. Example, consider your your fourth column is last_name, w...

Answer Question  Select Best Answer

Elango

• Jan 23rd, 2015

PL/SQL packages are schema objects that groups logically related PL/SQL types, variables and subprograms. A package will have two mandatory parts: Package specification Package body or defi...

Answer Question  Select Best Answer

kamlesh mishra

• May 18th, 2015

Default type of index is B-Tree - usually created when the column have more distinct or unique values like emp_no. When column have sequential values e.g 111,112,113,114 then use reverse key index wh...

Answer Question  Select Best Answer

What is the use Index Organized Table (IOT)?

Vishal BHOSALE

• Nov 16th, 2015

Index-organized tables have full table functionality. They support features such as constraints, triggers, LOB and object columns, partitioning, parallel operations, online reorganization, and replica...

Answer Question  Select Best Answer