In my table i'm having the duplicate records with sequence
number and my requirement is when in new record is coming i
want to delete existing old record(onlyone i.e maintaing the
partial duplicate date )and add new record
i have a table with the columns below as
Emp_ID Address_ID Address_Line City Country
-------- --------- ----------- ------ ---------
Q: Display the Emp_ID's those having more than one
Address_ID
i want to know rdbms certification details and syallabus and
for whom i contact for rdbms certification in bangalore i
need answer very urgent please mail to
aniltelkar50@gmail.com please as soon as possible
Hi all,
Can any one give answer for this question.
Suppose im having employee table with fields, eno, ename,
dept, address1, address2, address3.
In address field employee can fill only address1 or address2
or address3... at a time he can fill three address fields.
now i want all employee names who filled only one address
field.. Plz its urjent can any one give querry.. Thanks in
advance.
According to oracle specification VIEW is a object.
OBJECT that means anything stored in the oracle database
that has the physical existence.why VIEW doesn't take memory
in oracle database, but it is treated as a object ?Please
explain ?
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT
AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A
COLUMN ?
INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN.
WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE
ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS
NULL VALUES.
Is it possible to join two tables, that are in two different
users (e.g. SCOTT and HR etc.),but im same database
(e.g. ORCL)?
If yes, then how it is possible?
Explain with step by step procedure.
What are the Features of Forms 6i over 4.5?
What are the Features of Forms 10g?
What are the Features of Reports 6i?
What are the Features of Reports 10g ?
2073
Can u please explain me the
Discussion on Except ,using cast like type cast. Question in
the context of difference between two tables
if some data is not transfered where it will get stored
129
How we can able to import our own template (users designed
MS-Word templates) which has many tabular columns; need to
pass some values generate by Oracle-reports9i?
Actually need to import more than 400 MS-Word templates into
Oracle Reports-9i to minimize layout design in Reports.
Login
| Sign Up
To Refer this Site to Your Friends Click Here
Site Map
