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

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
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
vikas sable
vikas sable

vikas sable

  • 1 Question
  • 1 Answer
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
vikas sableContributor
Asked: July 21, 2022

How to pass page item value to use as string in sql query in oracle apex

  • 0

page item is P73_ACTION_OWNER_01 it is a text field i want to use text which is type in this text field to pass  as string in below sql query   select Name from EBA_PROJ_ROLES where ID in (select distinct ROLE_ID from EBA_PROJ_USER_REF where USER_ID in ('select ID from EBA_PROJ_STATUS_USERS where FIRST_NAME like' || : P73_ACTION_OWNER_01));

question
  • 2
  • 43
  • 0
Answer
shashi
shashi

shashi

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

Serial Number in IR Report

  • 0

Hi sir jii, How to show the serial number in IR report if the query is in group by format.

question
  • 1
  • 25
  • 0
Answer
Bansari
Bansari

Bansari

  • 9 Questions
  • 16 Answers
  • 0 Best Answers
  • 69 Points
View Profile
  • 1
BansariProfessional
Asked: June 29, 2022

How to format text field in an Interactive Grid

  • 1

Hello, Please help me figure out how I can format text in an Interactive Grid plain text field. I do have a column fetched from a table in an Interactive Grid column. The column in a table is a varchar2 type and has the text of up to 1000 characters. Now the requirement of an Interactive Grid is, that I want to display it in a bullet format if it has multiple sentences separated by '.' Example: Actual: Suzy provides the monthly financial reporting based on provided figures. The shareholders of the store have changed effective November 2021. How I want: Suzy provides the monthly financial reporting based on figures. The shareholders of the store have changed effective November 2021. Note: I have tried the solution by adding "replace(comments, '.', '<br>') comments" in select query in an interactive grid but it isn't working. Many Thanks, Bansari

question
  • 1
  • 49
  • 0
Answer
shashi
shashi

shashi

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

How to right align aggregate value in IR Report

  • 0

Hi sir jii, How to right align the aggregated column value in oracle apex

question
  • 0
  • 12
  • 0
Answer
shashi
shashi

shashi

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

Custom Aggregation in oracle apex in IR Report

  • 0

Hi Sir jii,            i have the sum of aggregate value for two columns need to calculate the average for these two values can u please suggest.

question
  • 0
  • 9
  • 0
Answer
shashi
shashi

shashi

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

Null value as Zero in IR Report

  • 0

Hi sir jii,        How to display null value as zero in IR report can you please suggest.

question
  • 2
  • 24
  • 0
Answer
naviz
naviz

naviz

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
navizContributor
Asked: June 19, 2022

How to create interactive grid based on multiple tables

  • 0

I have employee master table and using submaster for department and positions. I want to create an Interactive grid on Employee Master Table , but need to get data from Department and Positions  tables based on the department code and position code in employee master table.   Actually, I do not want to update multiple tables in the grid. I want to update only 1 Table Employee Master but just want to display data from other tables too using Employee Number to retrieve data from other table. I believe, it must be very simple, but I do not know how to do it. My requirement is just simple as below: Employee Master Table Employee_No Employee_Name Employee_Hire_Date Employee_NO          Employee_Name           Employee_Hire_Date 1001                 ABC                           01-JAN-2022 1002               DEFGHHFJ               20-JAN-2022 1003              XYZJHJSJ                   25-JAN-2022 Employee Status Table Employee_No Employee_Status Employee_Status_Date Employee_NO                 Employee_Status       Employee_Status_Date 1001                            A        ...

igquestion
  • 0
  • 27
  • 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