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

Oracle APEX Tutorials & Forum

Oracle APEX Tutorials & Forum Logo Oracle APEX Tutorials & Forum Logo

Oracle APEX Tutorials & Forum Navigation

  • Home
  • Oracle Apex
  • PL/SQL
  • SQL
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Ask Question
  • Write a Tutorial
  • Tools
    • Oracle Table Script Generator
    • PL/SQL Package Generator
  • Users
  • Tags
  • FAQs
  • Badges
  • Home
  • Oracle Apex
  • PL/SQL
  • SQL

Discy Latest Questions

Tonny
Tonny

Tonny

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 27 Points
View Profile
  • 2
TonnyContributor
Asked: December 5, 2023

Use table with DBLINK and without DBLINK PL/SQL ORACLE

  • 2

Use table with DBLINK and without DBLINK I have a procedure to use with DBLINK but I also need to use it without DBLINK, I could duplicate the procedure and it is already solved. But I want to just have an Oracle pl/sql procedure that can be used with DBLINK and that can also be used without DBLINK Please can you help me. CREATE PROCEDURE credit_account (acct NUMBER, new_balance NUMBER) AS BEGIN UPDATE accounts@dblink_histo SET balance = new_balance WHERE acct_id = acct; COMMIT; END credit_account; I do not want to repeat the following procedure that does not have DBLINK CREATE PROCEDURE credit_account (acct NUMBER, new_balance NUMBER) AS BEGIN UPDATE accounts SET balance = new_balance WHERE acct_id = acct; COMMIT; END credit_account; How can I use the table with DBLINK and without DBLINK so as not to repeat another procedure? Do you help me please?  

dblink
  • 1
  • 38
  • 0
Answer
RD_DEVVBR
RD_DEVVBR

RD_DEVVBR

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
RD_DEVVBRContributor
Asked: December 3, 2023

how to access Excel tables?

  • 0

Hello, my boss asked me to carry out a task, but I have doubts, he asked me to create an application where I could edit the Excel table that was uploaded within the apex itself, and then be able to compare the previous table with a new one that was added later

apextabels
  • 1
  • 18
  • 0
Answer
atif24
atif24

atif24

  • 1 Question
  • 2 Answers
  • 0 Best Answers
  • 26 Points
View Profile
  • 1
atif24Contributor
Asked: December 1, 2023

How to display image in Bi Publisher report by querying from Oracle Apex

  • 1

I want to display image in BI Publisher report in MS Word. I am downloding query xml file from Oracle Apex. Like :- SELECT name, image FROM Image_table. When I upload sample xml in BI publisher it don't show any data. Any Idea how do it ??

apexbipublisher
  • 4
  • 118
  • 0
Answer
apex-learner
apex-learner

apex-learner

  • 1 Question
  • 2 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
apex-learnerContributor
Asked: September 18, 2021

how to add date facet in faceted search

  • 0

Hi. How can I include DATE RANGEĀ  search criteria in Faceted Search? (while I was trying, I am getting the following error. Facet is not supported for DATE or TIMESTAMP columns.) Thanks,  

apexfacetfaceted search
  • 3
  • 1k
  • 0
Answer
Jorge.criv
Jorge.criv

Jorge.criv

  • 17 Questions
  • 17 Answers
  • 0 Best Answers
  • 129 Points
View Profile
  • 0
Jorge.crivProfessional
Asked: September 16, 2021

How to call apex_mail.send from outside of apex 20?

  • 0

Can apex_mail.send be called from outside of apex 20?

apex_mail.send
  • 2
  • 336
  • 0
Answer
pavlos
pavlos

pavlos

  • 37 Questions
  • 107 Answers
  • 1 Best Answer
  • 376 Points
View Profile
  • 0
pavlosGuru
Asked: September 15, 2021

How to call ajax callback process in modal dialog page?

  • 0

Hi! I have page with ajax callback which is executed on button click (submit). After I move page to modal dialog, ajax callback doesn't work. How to use ajax callback in modal dialog page?  

oracle apex
  • 1
  • 132
  • 0
Answer
Jorge.criv
Jorge.criv

Jorge.criv

  • 17 Questions
  • 17 Answers
  • 0 Best Answers
  • 129 Points
View Profile
  • 0
Jorge.crivProfessional
Asked: September 11, 2021

How to save and remember user on login page ?

  • 0

How to save and remember user login page in Apex 20?

loginrememberuser
  • 2
  • 495
  • 0
Answer
shashi
shashi

shashi

  • 15 Questions
  • 22 Answers
  • 0 Best Answers
  • 130 Points
View Profile
  • 0
shashiProfessional
Asked: September 8, 2021

How to get confirmation message for Logout

  • 0

Hi sir ji,How to show confirmation message for logout/signout when the user clicks the signout button from navigation bar list and redirect to logout url. can u please suggest.

question
  • 3
  • 505
  • 0
Answer
Ali Akbar
Ali Akbar

Ali Akbar

  • Faisalabad, Pakistan
  • 10 Questions
  • 6 Answers
  • 0 Best Answers
  • 85 Points
View Profile
  • 0
Ali AkbarProfessional
Asked: September 7, 2021

how can i send report direct on printer ?

  • 0

when i press button for print then report should beĀ  send to directly on printer instead any popup/page . How can we achieve this using BI Publisher or Jasper Report . please share code whose attempted this one task. Thank You.

print
  • 1
  • 105
  • 0
Answer
Jorge.criv
Jorge.criv

Jorge.criv

  • 17 Questions
  • 17 Answers
  • 0 Best Answers
  • 129 Points
View Profile
  • 0
Jorge.crivProfessional
Asked: September 3, 2021

how to modify distance between lines in an apex 20 form

  • 0

I have a form to load data and there are several items, I put them one below the other and they take up a lot of vertical space, even more when working on a mobile device how to modify distance between lines in an apex 20 form ?  

apex20form
  • 2
  • 110
  • 0
Answer
Old Questions

Sidebar

Explore

  • Ask Question
  • Write a Tutorial
  • Tools
    • Oracle Table Script Generator
    • PL/SQL Package Generator
  • Users
  • Tags
  • FAQs
  • Badges

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