Sign Up

Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then this place is just for you and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • About
Home/pavlos/Answers
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Comments
  • Followers Questions
  • Followers Answers
  • Followers Posts
  • Followers Comments
  1. Asked: February 21, 2021

    How to create time duration item in Oracle APEX?

    pavlos

    pavlos

    • 22 Questions
    • 71 Answers
    • 0 Best Answers
    • 211 Points
    View Profile
    pavlos Professional
    Replied to answer on February 24, 2021 at 2:45 pm
    This answer was edited.

    Thanks a lot! How can I use 0-24h format?

    Thanks a lot!

    How can I use 0-24h format?

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  2. Asked: February 8, 2021

    Is it possible to create report with switch items in rows?

    pavlos

    pavlos

    • 22 Questions
    • 71 Answers
    • 0 Best Answers
    • 211 Points
    View Profile
    pavlos Professional
    Replied to answer on February 8, 2021 at 7:57 pm
    This answer was edited.

    I've created it with items only, and it looks like in screenshot below: Now, I will create load for this items and the save process. I hope it will work :) Your suggestion is good but I need the left columns :)

    I've created it with items only, and it looks like in screenshot below:

    Now, I will create load for this items and the save process. I hope it will work 🙂

    Your suggestion is good but I need the left columns 🙂

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  3. Asked: February 5, 2021

    How to save data from rich text editor, without HTML tags

    pavlos

    pavlos

    • 22 Questions
    • 71 Answers
    • 0 Best Answers
    • 211 Points
    View Profile
    pavlos Professional
    Replied to answer on February 6, 2021 at 3:50 pm

    I changed comment text column type to Percent Graph and it works :)

    I changed comment text column type to Percent Graph and it works 🙂

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  4. Asked: February 5, 2021

    How to save data from rich text editor, without HTML tags

    pavlos

    pavlos

    • 22 Questions
    • 71 Answers
    • 0 Best Answers
    • 211 Points
    View Profile
    pavlos Professional
    Replied to answer on February 6, 2021 at 3:19 pm

    Hi Vinish! I tried with regexp_replace function, but it only hide HTML tags. I want to display bold and italic text in comments region.

    Hi Vinish!

    I tried with regexp_replace function, but it only hide HTML tags.
    I want to display bold and italic text in comments region.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  5. Asked: November 28, 2020

    How to highlight row based on condition using Classic Report

    pavlos

    pavlos

    • 22 Questions
    • 71 Answers
    • 0 Best Answers
    • 211 Points
    View Profile
    pavlos Professional
    Replied to answer on February 5, 2021 at 9:05 pm

    Thanks a lot @afzal, works :)

    Thanks a lot afzal, works 🙂

    See less
    • 2
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  6. Asked: November 28, 2020

    How to highlight row based on condition using Classic Report

    pavlos

    pavlos

    • 22 Questions
    • 71 Answers
    • 0 Best Answers
    • 211 Points
    View Profile
    pavlos Professional
    Replied to answer on January 29, 2021 at 12:42 am

    Sorry for bad explanation, I want to compare data in the Classic Report.

    Sorry for bad explanation, I want to compare data in the Classic Report.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  7. Asked: November 28, 2020

    How to highlight row based on condition using Classic Report

    pavlos

    pavlos

    • 22 Questions
    • 71 Answers
    • 0 Best Answers
    • 211 Points
    View Profile
    pavlos Professional
    Replied to answer on January 29, 2021 at 12:40 am

    Thanks a lot, it works. But, I am using faceted search with checkbox group, and when I filter column using checkboxes, rows aren't highlighted.

    Thanks a lot, it works. But, I am using faceted search with checkbox group, and when I filter column using checkboxes, rows aren't highlighted.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  8. Asked: November 28, 2020

    How to highlight row based on condition using Classic Report

    pavlos

    pavlos

    • 22 Questions
    • 71 Answers
    • 0 Best Answers
    • 211 Points
    View Profile
    pavlos Professional
    Replied to answer on January 24, 2021 at 2:02 pm
    This answer was edited.

    How can I get vales into :P1_yourdate for all rows and compare them?

    How can I get vales into :P1_yourdate for all rows and compare them?

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  9. Asked: January 23, 2021

    How to add one column data to another column in same row in Interactive Grid on oracle apex?

    pavlos

    pavlos

    • 22 Questions
    • 71 Answers
    • 0 Best Answers
    • 211 Points
    View Profile
    pavlos Professional
    Added an answer on January 23, 2021 at 3:29 pm

    Hi! You can use pipes: SELECT ename||' - '||sal as "Ename and Sal" FROM emp;

    Hi!

    You can use pipes:

    SELECT ename||' - '||sal as "Ename and Sal"
    FROM emp;
    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  10. Asked: November 28, 2020

    How to highlight row based on condition using Classic Report

    pavlos

    pavlos

    • 22 Questions
    • 71 Answers
    • 0 Best Answers
    • 211 Points
    View Profile
    pavlos Professional
    Added an answer on January 23, 2021 at 3:23 pm
    This answer was edited.

    Hi! How can I compare date column with JavaScript? I want to change row color where date is less than current date.

    Hi!

    How can I compare date column with JavaScript?
    I want to change row color where date is less than current date.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
1 2 3 … 8

Sidebar

Ask Question
Write a Post
  • Recent
  • Answers
  • pavlos

    How to change color of image in Oracle APEX?

    • 0 Answers
  • Bheem

    How to deploy oracle apex app in oracle SaaS

    • 0 Answers
  • Rameez Tariq

    How to create View with Blob column through DBLINK

    • 0 Answers
  • Huy Nguyen

    Dynamic action on column on Interactive Grid

    • 3 Answers
  • hamed
    hamed added an answer hi i want to display image in the report as… March 6, 2021 at 8:33 pm
  • Huy Nguyen
    Huy Nguyen added an answer Thank you for your good idea. March 5, 2021 at 12:09 pm
  • Vinish
    Vinish added an answer Oh, this will work for only new rows. For existing… March 5, 2021 at 11:22 am
  • Vinish
    Vinish added an answer I think you do not need to create the dynamic… March 5, 2021 at 11:14 am
  • Vinish
    Vinish added an answer Are you converting your CLOB to varchar2 in the report?… March 5, 2021 at 6:56 am

Recent Blog Posts

  • Vinish

    Oracle Apex - Display External File in Region

  • Vinish

    Oracle PL/SQL Download BLOB File to Disk

  • Vinish

    Oracle Convert External File to BLOB

  • Vinish

    Oracle Apex Calendar Example

  • Vinish

    Oracle Apex - Open Modal Dialog Page Using JavaScript

Explore

  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • About

© 2021 OrclQA.Com. All Rights Reserved. Privacy Policy