Hello Experts,
My table does not contain any primary key columns, i want to avoid the duplicate values when i am inseting values? How?
Kindly share your valuable views here so i can proceed further.
Thansk in advance.
How Can I Avoid the Duplicate Values When I am Inserting Values?
Answered
Next Story
Related
- Passing Runtime Values to SQL Loader
I want to pass the values GJ, TN and KR to sql loader control file For cir in GJ TN KR do echo "OPTIONS (SKIP=1)" > abcd.ctl echo "LOAD DATA" >> abcd.ctl echo... 
SQL Server Analysis and Avoiding Deadlocks Interview Questions and Answers
FAQ: SQL server analysis and avoiding deadlocks1. What is the relationship between SAP work processes and SQL server processes?Each work process is connected to the MS SQL server database via the...- How to Update the Target table with Incremented values Instead of Inserting into it?
Hello Experts,I tried incremental aggregation by setting \"treat source as\" property to insert and target property as update else insert and still it worked.Here my question is when i am flagging... - How to Read a Hexadecimal Value from a Binary File Using Oracle SQL Loader
I have a Mainframe file which is FTP'ed to Oracle server in Binary. It's a fixed width file having a field with hexadecimal values. I need to read those values and convert those to decimal...
Forums
Books
Jobs
-
Opening for Sr. SAP Basis Consultant @ Bangalore (Immediate
Exp :6 - 15 years | City : Bangalore -
SAP Hana Cloud Integeration | 6 - 9 Years | Pune | Atos
Exp :6 - 9 years | City : Pune -
SAP with Portuguese & English Langauge Support | 3 - 6 Years
Exp :3 - 6 years | City : Hyderabad -
Solution Architect for the Oracle Hyperion EPM Suite | 8 - 1
Exp :8 - 13 years | City : Bangalore -
Sr. SAP ABAP FI Developer | 8 - 13 yrs | Hyderabad / Secunde
Exp :8 - 13 years | City : Hyderabad
Get solutions from our experts!
Create Sequence and use that sequence to Insert values.