• python
  • javascript
  • reactjs
  • sql
  • c#
  • java
Facebook Twitter Instagram
Devs Fixed
  • python
  • javascript
  • reactjs
  • sql
  • c#
  • java
Devs Fixed
Home ยป Resolved: SQL insert into table with collection and structured data type

Resolved: SQL insert into table with collection and structured data type

0
By Isaac Tonny on 16/06/2022 Issue
Share
Facebook Twitter LinkedIn

Question:

this is my insert on a table and oracle application express returns me this enter image description here
table is defined as
and the colection “COLECTION_OF_CONTACTS” is defined as
and structured data type”ADRESA” is defined as
table, colection and structured type were generated sql from oracle data modeler
But what i need is to help with my insert into sql comand where i can’t seem to find where is the issue
thank you for the sudgestions

Answer:

You have two issues:
  • The table name is UKLIZECKA and not PERSON.
  • "" is for identifiers and '' is for string literals so to_date("10.10.2000") is looking for a column identified by "10.10.2000" rather than passing a string literal. You want TO_DATE('10.10.2000', 'DD.MM.YYYY') (with an explicit, rather than implicit, format model) or a date literal DATE '2000-10-10'.
  • It is also best practice to specify the columns you are inserting into.

Like this:
db<>fiddle here

If you have better answer, please add a comment about this, thank you!

oracle-apex sql
Share. Facebook Twitter LinkedIn

Related Posts

Resolved: significance letter above bar graphic in wrong order

01/04/2023

Resolved: VBA – Applying border around the areas with value/text

01/04/2023

Resolved: How can I implement a function depending on picked up items?

01/04/2023

Leave A Reply

© 2023 DEVSFIX.COM

Type above and press Enter to search. Press Esc to cancel.