Sign Up

❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up 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

OrclQA.Com Navigation

  • Ask Question
  • Write a Tutorial
  • Online Courses
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • Image to Base64
  • PL/SQL Beautifier
  • Ask Question
  • Write a Tutorial
  • Online Courses

Discy Latest Questions

shashi
shashi

shashi

  • 52 Questions
  • 29 Answers
  • 0 Best Answers
  • 300 Points
View Profile
  • 0
shashiGuru
Asked: August 11, 2022

How to control size of image in classic report and template as card type

  • 0

Hi sir jii, I created an classic report and choose template as card type and able to display image on page but the problem is images are varying with different size can you please suggest how to control size of image.

questions
  • 0
  • 10
  • 0
Answer
swamy kumar
swamy kumar

swamy kumar

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 24 Points
View Profile
  • -1
swamy kumarContributor
Asked: August 11, 2022

Download the Zip file from the Directory to google chrome downloads in oracle apex

  • -1

HI, how to download a zip file which is stored in directory with the button click in oracle apex I had written a process to call it but throwing the error as syntaxError: Unexpected token 'P', "PK"... is not valid JSON.. Here is my piece of code written in processing: declare Lob_loc bfile; begin Lob_loc := bfilename('ABC_DIRECTORY','data file.zip'); OWA_UTIL.MIME_HEADER( 'application/zip', FALSE ); htp.p('Content-Disposition: attachment; filename="'||'data file.zip"'); owa_util.http_header_close; wpg_docload.download_file(Lob_loc); apex_application.stop_apex_engine; exception when others then raise_application_error(-20002, SQLCODE||' — '||SQLERRM); apex_application.stop_apex_engine; end;  

oracleoracle apexoracle sql
  • 0
  • 18
  • 0
Answer
Bansari
Bansari

Bansari

  • 9 Questions
  • 16 Answers
  • 0 Best Answers
  • 69 Points
View Profile
  • 0
BansariProfessional
Asked: August 11, 2022

Pl/sql procedure block to generate CSV file using database table and manual format

  • 0

Hello, I want to write a plsql procedure block to generate a CSV file using manual data as well as data from one table, using  utl_file package and cursors.   Please check the attachment. The table has records of a few lines only which has data and I want to add time column(column A) as you can see in the attachment where it will have time data after every 5 mins and for any time if a table has records, the procedure has to take the data into the file. Thanks, Bansari

question
  • 0
  • 17
  • 0
Answer
Haseeb
Haseeb

Haseeb

  • 2 Questions
  • 0 Answers
  • 0 Best Answers
  • 30 Points
View Profile
  • 0
HaseebContributor
Asked: August 10, 2022

get client desktop name

  • 0

Hi I want to get client desktop name  in oracle apex  . I am unable to find solution 

question
  • 0
  • 13
  • 0
Answer
Lyn
Lyn

Lyn

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
LynContributor
Asked: August 9, 2022

How to populate new data into Interactive Grid using button in Oracle Apex

  • 0

I have a SQL Query inside button that will return multiple data. The Interactive Grid also got it own SQL Query. How do I populate/add these data into an Interactive Grid that already have data without replacing existing data in the Interactive Grid?.

iginteractivegridoracleapex.report
  • 0
  • 23
  • 0
Answer
Ibrahim Rajar
Ibrahim Rajar

Ibrahim Rajar

  • 1 Question
  • 2 Answers
  • 0 Best Answers
  • 30 Points
View Profile
  • 0
Ibrahim RajarContributor
Asked: August 6, 2022

Call Database stored procedure in PAEX?

  • 0

How can I call Oracle Database stored procedure getting in one parameter on click of a Button in Oracle APEX? . It has nothing to return back to APEX. I should work just like a "Exec Procedure_Name (Parameter)".

call procedure
  • 2
  • 28
  • 0
Answer
Greg G
Greg G

Greg G

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
Greg GContributor
Asked: August 3, 2022

APEX_COLLECTIONS Is Not Returning Rows

  • 0

I have a colleague that is using a collection in one of his pages.  However, when he runs the query: Select * from apex_collections; No rows are returned. Any idea why no rows are found? Thanks.

apexcollections
  • 0
  • 20
  • 0
Answer
bob_finlanders
bob_finlanders

bob_finlanders

  • 2 Questions
  • 6 Answers
  • 0 Best Answers
  • 31 Points
View Profile
  • 0
bob_finlandersContributor
Asked: August 2, 2022

How to show specific row details in report on selection of checkbox | Oracle APEX |

  • 0

I have been struggling to find a way how to implement this task   Below is the GUI I have designed  I have 2 reports on my page  Interactive grid report  [ Name : Employees ]  Interactive report  [ Name : selected ]   Whatever I select from first report should be shown on second report [ selected ]  on checkbox is tick  I have refer this blog but no luck : https://www.foxinfotech.in/2019/10/oracle-apex-interactive-grid-get-selected-rows-example.html Any solution or video demonstration is much appreciated   

apexoracleapex.oracleapex20.x
  • 3
  • 38
  • 0
Answer
shashi
shashi

shashi

  • 52 Questions
  • 29 Answers
  • 0 Best Answers
  • 300 Points
View Profile
  • 0
shashiGuru
Asked: August 1, 2022

How to hide Rows in IR Report when column values is null

  • 0

Hi sir jii,             How to hide Rows in IR Report when column values is null. Can you please suggest.

question
  • 0
  • 21
  • 0
Answer
bob_finlanders
bob_finlanders

bob_finlanders

  • 2 Questions
  • 6 Answers
  • 0 Best Answers
  • 31 Points
View Profile
  • 0
bob_finlandersContributor
Asked: July 29, 2022

How to Iterate through selected checkbox in Interactive grid report and insert the values to table

  • 0

I am running out of time because of this task, No where I am able to find appropriate answers for this task. I have a interactive grid report and in which I have enabled the editing option. <Interactive grid -> attributes -> editing -> enabled /> After enabling the editing option -> The checkbox became available for me like below When I select multiple checkbox their details should be inserted to table  I posted same question on Stackoverflow but no solution  Can you please check and provide your solution or input  Stackoverflow question : https://stackoverflow.com/questions/73166100/iterate-through-selected-checkbox-oracle-apex?noredirect=1#comment129221060_73166100   Thanks & Regards, Bob finlanders   

apexoracleapex.plsql
  • 6
  • 37
  • 0
Answer
Old Questions
Advertisement

Sidebar

Ask Question
Write a Tutorial
Advertisement

Recent Blog Posts

  • Vinish

    Oracle LENGTH()

  • Vinish

    Oracle INSTR() Function

  • Vinish

    Oracle INITCAP() Function

  • Vinish

    Oracle Concat

  • Vinish

    Oracle CHR Function

Advertisement
Advertisement

Explore

  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • Image to Base64
  • PL/SQL Beautifier

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
© 2021 OrclQA.Com. All Rights Reserved.
Privacy Policy - About Us