I have to get source column name of page item from apex_application_page_items where page_id = each page_item of current page. for that i need item_id which is available in #CURRENT_ITEM_ID#. But I stuck that I don't know how to use this in PL/SQL. Can someone guide?
Discy Latest Questions
I have a classic report with break columns. Prints button also create PDF. Every things is ok and as per desired except I WANT TO START NEW PAGE WHEN BREAK OF COLUMN OCCURRED. Means I want to leave page blank whenever a column break occurred. I have tried a lot but failed. can someone guide in this regard.
I have 5 columns in table. I m going to collect user inputs in 4 columns and rest 1 column will be sysdate (date+ Time stamp) which user will not view/enter/correct but my form should manage and insert accurate value. How can I do? I have set value in default/source but while inserting it gives error. <dt_created> can not insert null. Pl guide.
There are column named ADD1 of table Employee having value "Excellent House" (five blank spaces between Excellent and House. But it got trimmed while fetching in IG. How can I come out?
Hi team, I m new in APEX ORACLE. I just want to know A page item with optional-floating (Appearance/Template) displayed in two lines i.e. item label in 1st line and its value in 2nd line. I want to change font size/weight/color of label. Also I dont want 2nd line means want to stop wrapping. I need to assign another font size/weight/color to value. Pl. guide