How to restrict the duplicate records in table valuesets
Answers were Sorted based on User's Feedback
Answer / znaukak
Create unique key for this column where value should be
inserted.
Is This Answer Correct ? | 12 Yes | 1 No |
Answer / shalini gupta
we can create a unique index as well as primary key
constrains to restrict dulpicate record. unique key allows
one null but primary key constrains does not allow null.
Is This Answer Correct ? | 4 Yes | 2 No |
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
What is an oracle data file?
What do you understand by database schema and what does it hold?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What is format trigger?
what are pseudocolumns?
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
How to create an oracle database manually?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
How to lock and unlock a user account in oracle?