How to use this query , SELECT LPAD (' ', 3 * (LEVEL - 1), '-') || menu_name, oID FROM MENUS START WITH parent_oid IS NULL CONNECT BY PRIOR oid = parent_oid ORDER SIBLINGS BY menu_name ignore this error: ORA-20999: Column name "LPAD('',3*(LEVEL-1),'-')||MENU_NAME" is invalid for the LOV SQL query. Make sure that you use valid alias names for your columns.
Discy Latest Questions
SM HasemProfessional
I have billing & report page. from billing page save data into table & go to report page by branch. in this time how can I get maximum invoice number & page submit?
SM HasemProfessional
when I click row selector, then in this row data insert into another column in same row and which row I selected only this data r save in a table. SELECT ROWID , CLIENTS_ID , TITLE , PROJECT_NAME , AREA , SERVICE_CHARGE , COLLECTION_AMOUNT , BILL_MONTH , SOFTWARE_STATUS , ENTRY_DATE , BILL_MONTH_2ND FROM COLLECTION_LIST When select row_selector, in this row, SERVICE_CHARGE data transfer to COLLECTION_AMOUNT & save data, which r selected. I use IG-DML(PLSQL).
I have one item with default Interactive Grid. I want to insert item value with default Interactive Grid. Is it Posible? How?
SM HasemProfessional
How to add one column data to another column in same row in Interactive Grid on oracle apex? How to add one column data to another column in same row in Interactive Grid on oracle apex?