Updating oracle table sequence

19-Jul-2019 00:36

p_name

NEXTVAL in order to populate a table, I get a PK violation, since that number is already in use in the table.I want to update table with sequence number, I cant create procedure or sequence object so need a update query for this.I have a table with date column, based on minimum date I need to generate a number.Table Data:- Your example shows that you store dates as a string using custom representation - not compliant with dates format.So we need to convert your dates to date datatype to be able to order them accordingly.

NEXTVAL in order to populate a table, I get a PK violation, since that number is already in use in the table.I want to update table with sequence number, I cant create procedure or sequence object so need a update query for this.I have a table with date column, based on minimum date I need to generate a number.Table Data:- Your example shows that you store dates as a string using custom representation - not compliant with dates format.So we need to convert your dates to date datatype to be able to order them accordingly.Since you can't list more than one table in the Oracle UPDATE statement, you can use the Oracle EXISTS clause.