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
- 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 Error When I am trying to Execute catsbp.sql.
Hello Experts,After 12c upgrade of oracle I ran all the post update scripts, the db is up also. Now when I am trying to execute catsbp.sql using command,SQL>... 
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...- CIF error Open SQL-Array-Insert leads to duplicate records.
This error is caused by the CIF transfer of material versions. For material versions to be transferred correctly from the R/3 into an APO system, the R/3 table MATERIALID must be mapped in APO tables...
Get solutions from our experts!
Create Sequence and use that sequence to Insert values.