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

shivkumarojha

 Profile Answers by shivkumarojha Questions by shivkumarojha

• Sep 6th, 2006

Self Join-The SELF JOIN is used to join a table to itself, as if the table were two tables, temporarily renaming at least one table in the SQL statement. The syntax is as follows:SELECT A.LAST_NAME, B...

shivkumarojha

 Profile Answers by shivkumarojha Questions by shivkumarojha

• Sep 6th, 2006

NonEquiJoin-NON-EQUIJOIN joins two or more tables based on a specified column value not equaling a specified column value in another table. The syntax for the NON-EQUIJOIN isSELECT EMPLOYEE_TBL.EMP_ID...

Answer Question  Select Best Answer

NAGA

• Aug 29th, 2006

This will not give any outputThis will throw a error missing expression

krishna

• Aug 11th, 2005

A. It selects the total no of emplyoyees in stores

Answer Question  Select Best Answer

Bilkis

• Aug 16th, 2006

No.

Answer Question  Select Best Answer

Yugma

• Aug 13th, 2006

Database is simply a collection of related data nothing else. It can be manual?or automatic both.DBMS is collection of application programs which enables a user to define, create and manipulate database.

ashutosh mishra

• Jun 7th, 2006

hiin simple way ,we can say that database is collection of data which can be easily manipulate and retrive.databse  is thing which can be store backendin database software.

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

vvijaychandra

 Profile Answers by vvijaychandra Questions by vvijaychandra

• Jul 4th, 2006

Clustered Index:- A Clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table may have only one clustered index.Non-Clustered Index:-...

zanhsieh

 Profile Answers by zanhsieh Questions by zanhsieh

• Apr 24th, 2006

The difference is that, Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resort...

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

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

FALAK

 Profile Answers by FALAK Questions by FALAK

• Apr 25th, 2006

A user defined package can be invoked in sql only if we r using it to call public functions or variables.but packaged procedures can not be called from sql

Mainak Aich

• Mar 17th, 2006

Hi,Everyone forgot to point out 1 thing,which is most essential to use a user defined package which is he/she must have the execute permission to use the package if he/she is not the creator of that package.If it is ok definitely an user defined package can be used.

Answer Question  Select Best Answer

HB, HyderabadBangalore

lakshminarsu

• Apr 13th, 2006

output of the above program:nHBnHyderabadBangalore

Answer Question  Select Best Answer

Gopi

• Apr 8th, 2006

Subtype Relation

sujatha

• Jan 21st, 2006

Arc Relation

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

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

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

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

DROP TABLE &TABLE_NAME;Variable names should start with an alphabet. Here the table name starts with an '&' symbol.

Poonam Sachdeva

• Nov 23rd, 2005

This does not give an error in Oracle 9iFollowing is the outputSQL> DROP TABLE &TABLE_NAME;Enter value for table_name: temp_special_payslip(this has been eneterd by me)old   1: DROP TABLE &TABLE_NAMEnew   1: DROP TABLE temp_special_payslipTable dropped.

naveen

• Sep 19th, 2005

this works in oracle9i and it will ask for table nameand the given table will be deleted

Answer Question  Select Best Answer

It is used to drop constraints specified on the table.

chitra

• Nov 14th, 2005

The rtrim function requires 1 arguments.

Anuradha

• Oct 13th, 2005

Ans:The given answer says the use of DROP command.but not the drop option in the ALTER TABLE command.       Drop option in the ALTER TABLE command is uesd to drop columns...

Answer Question  Select Best Answer

REVOKE

Hemangi

• Oct 15th, 2005

RRVOKE

Answer Question  Select Best Answer