Learn Oracle Apex

 Soon will be good article for how to start and learn Apex

Learn Oracle for free

 https://m.youtube.com/watch?v=Q5JM8nWWfnI&list=PLc9GCtRxQqZgvbfREKjy1Vi9X7Rle0Nhs&index=1&t=9s

Case Sensitive Passwords in Oracle Database 11g Release 1

Case sensetive login password

 ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;

Yasser

Lear HTML

 https://www.websiteplanet.com/blog/html-guide-beginners/

Oracle Select all column and one in the begining

Oracle Select all column and one in the begining

example

 select i.BONUS_ITEM_FLAG,i.* 

from SAL_INVOICES_ITEMS i ;

My youtube links

 https://www.youtube.com/channel/UCDlpipY3srYehE9EcqoN_kQ/

Oracle Forms add_list_element

ADD_LIST_ELEMENT built-in

Description

Adds a single element to a list item.

Syntax

PROCEDURE ADD_LIST_ELEMENT (list_name VARCHAR2, list_index, NUMBER list_label VARCHAR2, list_value NUMBER);

PROCEDURE ADD_LIST_ELEMENT (list_id ITEM,

list_index VARCHAR2, list_label VARCHAR2, list_value NUMBER);

Built-in Type  unrestricted procedure

Enter Query Mode  yes

Parameters

list_id   Specifies the unique ID that Form Builder assigns when it creates the list

item.  Use the FIND_ITEM built-in to return the ID to an appropriately

typed variable.  The data type of the ID is ITEM.

list_name         The name you gave to the list item when you created it.  The data type of

                           the name is VARCHAR2.

list_index      (counter)        Specifies the list index value.  The list index is 1 based.

list_label       Specifies the VARCHAR2 string that you want displayed as the label of the

                       list element.

list_value       The actual list element value you intend to add to the list item.

------------------------

ADD_LIST_ELEMENT restrictions

For a base table list with the List Style property set to Poplist or T-list, Form Builder does not allow you to add another values element when the block contains queried or changed records. Doing so causes an error. This situation can occur if you have previously used DELETE_LIST_ELEMENT or CLEAR_LIST to remove the other values element that was specified at design time by the Mapping of Other Values list item property setting.

Note: The block status is QUERY when a block contains queried records. The block status is CHANGED when a block contains records that have been either inserted or updated.

ADD_LIST_ELEMENT Example:

------

PROCEDURE YLISTE IS

cursor c is 

select CODES_ID,       

USER_CODE ||' - '||

DECODE(GET_USER_LANG(:GLOBAL.LANGUAGE_ID), 'P', PRIMARY_NAME, SECONDARY_NAME) ITEM_NAME

 from codes where code_types_id = 583007;

cnt number := 1;

it_id ITEM;

begin

it_id := Find_Item('SAL_INVOICES.DRIVER_ID');

clear_list(it_id);

for i in c loop

add_list_element(it_id,cnt,i.ITEM_NAME,i.CODES_ID);

cnt := cnt + 1;

end loop;

end; 

-----------

Yasser