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

How to delete duplicate records without using rownum/rowid concept?

cocoole

 Profile Answers by cocoole Questions by cocoole

• Jan 7th, 2016

Delete rowid not in (select the max rowid and group by each col {find the no duplicate table})

Answer Question  Select Best Answer

If an implicit index is created when we create a primary key, then what is the need of explicit cursor?

shiva sai

• Feb 15th, 2016

1. Using implicit index the data can be fetched fastly only when the where clause has primary key column.

2. Explicit cursor is used when we want to fetch more than one record and also the where condition does not have primary column.

Answer Question  Select Best Answer

Display employees who are IT_prog and salary is greater than 3000 and department is not equal to 80 and having the manager as 103

Neha

• May 26th, 2016

Code
 

Answer Question  Select Best Answer

Compose an SQL statement to show a list of two least expensive vendors (suppliers) for each raw material. In the result table, show Material ID, Material Description, Vendor ID, Vendor Name, and Supplier’s unit price. Sort the result table by Material_ID and unit price in ascending order. Note: if a raw material has only one supplier(vendor), that vendor should also be in the result (output) table...

shirley

• Apr 26th, 2017

"sql SELECT Rank() OVER (PARTITION BY MaterialID ORDER BY UnitPrice ASC) AS [Ranking], MaterialID, Description, VendorID, VendorName, UnitPrice INTO tempdb..ProductByVendor FROM ...

Answer Question  Select Best Answer

Describe use of VIEW in SQL Server?

Krishnaveni

• Aug 10th, 2018

A view is virtual table created using the real table. End users can easily access the data with out altering any table definition by using views. We can create, replace or drop the view depending on ...

Answer Question  Select Best Answer

The privilege receiver can further grant the privileges he/she has obtained from the owner to any other user.

sahu

 Profile Answers by sahu Questions by sahu

• Jan 27th, 2006

Ans:From above Commentyes, we can give  privilege receiver can further grant the privileges he/she has obtained from the owner to any other user.

Answer Question  Select Best Answer

REVOKE

Hemangi

• Oct 15th, 2005

RRVOKE

Answer Question  Select Best Answer

USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECD

sahu

 Profile Answers by sahu Questions by sahu

• Jan 27th, 2006

Ans:yes,USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECDsystem tables contain information on privileges granted and privileges obtained

Answer Question  Select Best Answer

HB, HyderabadBangalore

lakshminarsu

• Apr 13th, 2006

output of the above program:nHBnHyderabadBangalore

Answer Question  Select Best Answer

C

Johon

• Aug 28th, 2005

A. The strcpy() will seg fault as there's no allocated memory for the destination string.

Answer Question  Select Best Answer

A

vijji

• Jul 20th, 2006

A function cannot retyrn a value without declaring return statement so it gives syntax error

Answer Question  Select Best Answer

D

vikas

• Sep 11th, 2006

it ll display a blank screen. u can figure it out if u look at the code :char *st1[3]= {"Hello","World","Oracle ;// here st1[0] points to Hello, st1[1] points to World and so on !!*st1=st1[...

Answer Question  Select Best Answer

samiksc

 Profile Answers by samiksc Questions by samiksc

• Jan 19th, 2006

For case sensitive string comparison in SQL one has to use substring() and ascii() functions in the following way.Get first character of both strings using substring function as substring(str1, 1, 1)F...

Answer Question  Select Best Answer

Mainak Aich

• Mar 28th, 2006

We can do it by the following command:create or replace directory as 'c:\tmp'

Answer Question  Select Best Answer

narasimha_82

 Profile Answers by narasimha_82 Questions by narasimha_82

• Feb 28th, 2006

HI SudhaIF u get this error, then there is a problem with the Java program, U may open the cursor with the Readonly mode.Change the Resultset type then you will get it.This is not problem with the OracleNarasimha Rao

Answer Question  Select Best Answer

Alex T

• May 4th, 2006

Oracle has Schema triggers (CREATE OR REPLACE TRIGGER ... ON SCHEMA ... that will file on DDL commands. You can do things like CREATE OR REPLACE TRIGGER save_our_dbBEFORE DROP OR TRUNCATEON SCHEMAto stop/log attempts to drop a table

Answer Question  Select Best Answer

rajaram

• May 21st, 2006

you can hide the table name by creating synonyms.e.g) you can create a synonym y for table xcreate synonym y for x;

Answer Question  Select Best Answer

Bilkis

• Aug 16th, 2006

No.

Answer Question  Select Best Answer

Jerrin

• Oct 19th, 2006

The Table is called a Heap....

Answer Question  Select Best Answer