SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

auto_increment error at detail table

Muhammad Ahmad AftabJun 25 2016 — edited Jun 26 2016

hi all,

Today i stuck in a problem that is auto_increment in detail table.

i have a table Master with U_id that is primary key with values

03 etc

and second table in Detail with D_id that is primary key of that table

now i want to show my primary key value of this table like

(Master table value-detail table value )

01-001

01-002

01-003 with first master table value and

02-001

02-002

02-003 so on.

how can i achieve this.

Regards:

Ahmad

This post has been answered by Jiri.Machotka-Oracle on Jun 26 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 24 2016

Added on Jun 25 2016

#pl-sql, #sql

6 comments

920 views