Insert data into table using SQL in Oracle APEX

preview_player
Показать описание
In this video, you will learn how to create an Oracle APEX

#oraclecloud #oci #apex #oracle #PaaS #techsupper #ankur

Join this channel to get access to perks:

Follow me on Twitter, Facebook, and LinkedIn

Рекомендации по теме
Комментарии
Автор

Hi, can you please explain the difference between, after submit, validating, processing and after processing. while creating the processes.

chd
Автор

Oie, supersencillo el video pero me ayudo un monton, para los que quieran ingresar datos pero necesitan valores con nulos o vacios o en cero, VALUES(NVL(:P8_ID_PEDIDO, 0), NVL(:P8_DESCRIPCION, 'Sin descripción'), NVL(:P8_MONTO, 0), NVL(:P8_MONEDA, 'USD'), asi ingresan en las casillas donde el usuario deja vacio

jorgevazquez
Автор

How about to update data? I have an update button created, but instead of updating, creates a new row in the table. Can you help out with this? Thank you!

Later edit(for others who might have the same issue)
I created a new process, with an update statement and at the Server-side Condition you need to choose SAVE!

martart