Skip to main content
  • EN

table 1

table 1table 2table 2 Expected result is :

table 3:

actgeneric_id------- fNotam_id

1.2.1.1.3.1 ---------- 1.2.1.1.3

1.2.1.1.3.5.1----------1.2.1.1.3

1.2.1.1.3.5.2----------1.2.1.1.3

....

....

.....

.....

1.2.1.1.4.1------------1.2.1.1.4

1.2.1.1.4.2------------1.2.1.1.4

......

......

 

Actually, these are xml_id hieararcy for creating the relational database tables.

 

You could use an InlineQuerier to do this,

e.g.

SELECT aa."actgeneric_id", bb."notam_id"
FROM Table1 aa, Table2 bb
where aa."actgeneric_id" like bb."notam_id"||'%'

 

Thanks @ebygomm​ for your answer. It works

 

Reply


Community Stats

30,168
Posts
114,527
Replies
37,826
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.