How to restrict the duplicate records in table valuesets
Answer Posted / znaukak
Create unique key for this column where value should be
inserted.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What is the maximum number of triggers that can be applied to a single table?
What is oracle host variable?
WHAT IS ecc 6.0
What is rich query?
How to run the anonymous block again?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Explain do view contain data?
What happens to indexes if you drop a table?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How to define a variable to match a table column data type?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
Explain the difference between a procedure and a function?
Name the various constraints used in oracle?