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
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo

OrclQA.Com Navigation

  • Oracle
  • Oracle Apex
  • Python
  • Questions
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Ask Question
  • Add Post
  • Oracle
  • Oracle Apex
  • Python
  • Questions
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Comments

Discy Latest Questions

Swarup
Swarup

Swarup

  • India
  • 30 Questions
  • 119 Answers
  • 0 Best Answers
  • 202 Points
View Profile
  • 0
SwarupProfessional
Asked: August 10, 2021

Data Extract in CSV with double quotes

  • 0

Hi, Good Evening, I want to pull data in CSV format and I have written plsql procedure for that and I am able to export the data successfully but there is a concern that if a data contains a double quote then it's getting disappear in CSV export but I need that double to be there in data, Please find the screenshot of plsql procedure for your refernce For eg: i have entered data as "NAME" I need this in CSV format also   Can anyone please help me out? Thanks in Advance    

data extract
  • 4
  • 129
  • 0
Answer
Swarup
Swarup

Swarup

  • India
  • 30 Questions
  • 119 Answers
  • 0 Best Answers
  • 202 Points
View Profile
  • 1
SwarupProfessional
Asked: April 12, 2021

Restrict record entry after one record

  • 1

Dear Sir, Good Evening, Can we restrict data entry after one record is created? Ex:An end-user has created one record but he/she shouldn't be able to enter a second record into the application/DB Thanks in Advance

apex
  • 2
  • 112
  • 0
Answer
Swarup
Swarup

Swarup

  • India
  • 30 Questions
  • 119 Answers
  • 0 Best Answers
  • 202 Points
View Profile
  • 0
SwarupProfessional
Asked: February 9, 2021

RTF Template if else Condition

  • 0

Hello Sir, I want to get the data for example if data is present in the description then data should come else NA should appear. <?if:Description2=' '?> NA <?end if?><?if:Description2='Description2'?> Description2 <?end if?>

rtf
  • 3
  • 1k
  • 0
Answer
Swarup
Swarup

Swarup

  • India
  • 30 Questions
  • 119 Answers
  • 0 Best Answers
  • 202 Points
View Profile
  • 0
SwarupProfessional
Asked: January 10, 2021

Data Exchange within database from Dev to Val

  • 0

Hi Sir, Good Evening, Happy New Year, I have installed Oracle Apex in One Database(Development DB) but i want to get the data from the another Database(Validation DB) where apex is not installed is it possible?   Thanks In Advance

data
  • 1
  • 45
  • 0
Answer
Swarup
Swarup

Swarup

  • India
  • 30 Questions
  • 119 Answers
  • 0 Best Answers
  • 202 Points
View Profile
  • 0
SwarupProfessional
Asked: November 3, 2020

Inserting App user into the data table in Oracle apex

  • 0

Hi Sir, Good Morning,i want to insert the app user in to the data table for eg: i am entering data into table ID: Project: Task: App_user: if i am the user then i have logined to application the application user name should be insert into the app_user

app user
  • 3
  • 1k
  • 0
Answer
Swarup
Swarup

Swarup

  • India
  • 30 Questions
  • 119 Answers
  • 0 Best Answers
  • 202 Points
View Profile
  • 1
SwarupProfessional
Asked: November 2, 2020

Showing information on IR Region

  • 1

Hi Sir, Can we show a sub region on  top of the IR which will show the time(total hour) and the week( from 02-06)

ir
  • 8
  • 299
  • 0
Answer
Swarup
Swarup

Swarup

  • India
  • 30 Questions
  • 119 Answers
  • 0 Best Answers
  • 202 Points
View Profile
  • 0
SwarupProfessional
Asked: November 2, 2020

Approve all dynamically in oracle apex

  • 0

Hi Sir, I have created a lov with Approve All,Reject All. If i select approve all then all the status field should be approved vice versa dynamically

dynamic
  • 16
  • 182
  • 0
Answer
Swarup
Swarup

Swarup

  • India
  • 30 Questions
  • 119 Answers
  • 0 Best Answers
  • 202 Points
View Profile
  • 1
SwarupProfessional
Asked: November 2, 2020

After Approve insert into another table

  • 1

Hi Sir, Good Morning,i have two tables table1 and table2 when field status of table1 is approved then it should insert into table2 i have used this trigger but not firing create or replace TRIGGER TRG_Times_INSERT AFTER INSERT ON Times FOR EACH ROW BEGIN IF :NEW.STATUS = 'APPROVED' then INSERT INTO APPROVE (PID,BILLING_STATUS,TASKS,MONDAY,LOGM,NOTEM,TUESDAY,LOGT,NOTET,WEDNESDAY,LOGW,NOTEW,THRUSDAY,LOGTH,NOTETH,FRIDAY,LOGF,NOTEF,TOTALHOURS,STATUS,COMMENTS) VALUES (:NEW.PID,:NEW.BILLING_STATUS,:NEW.TASKS,:NEW.MONDAY,:NEW.LOGM,:NEW.NOTEM,:NEW.TUESDAY,:NEW.LOGT,:NEW.NOTET,:NEW.WEDNESDAY,:NEW.LOGW,:NEW.NOTEW, :NEW.THRUSDAY,:NEW.LOGTH,:NEW.NOTETH,:NEW.FRIDAY,:NEW.LOGF,:NEW.NOTEF,:NEW.TOTALHOURS,:NEW.STATUS,:NEW.COMMENTS); END IF; END TRG_Times_INSERT;

trigger
  • 8
  • 108
  • 0
Answer
Swarup
Swarup

Swarup

  • India
  • 30 Questions
  • 119 Answers
  • 0 Best Answers
  • 202 Points
View Profile
  • 0
SwarupProfessional
Asked: October 31, 2020

Time Capture in db oracle apex

  • 0

Hi Sir, Good Afternoon,Sir Can you please guide me how to capture only time in apex and what will be the datatype in db and any configuration in frontend.

time capture
  • 7
  • 91
  • 0
Answer
Swarup
Swarup

Swarup

  • India
  • 30 Questions
  • 119 Answers
  • 0 Best Answers
  • 202 Points
View Profile
  • 0
SwarupProfessional
Asked: October 15, 2020

Adding of field in oracle apex

  • 0

Hi Sir, i want to add fields,eg:there are 5 fields where if i enter 3 fields also the value should be calculated,and the number that i am entering is like 2:00,0:30 but i am unable to sum all the fields if i am entering like this    able to do sum:2+3+5 using PLSQL Expression (:P6_LOGM+:P6_LOGT+:P6_LOGW+:P6_LOGTH+:P6_LOGF) unable to do sum 2:00+3:00+5:00

oracle apex
  • 9
  • 210
  • 0
Answer
Old Questions

Sidebar

Explore

  • Ask Question
  • Add Post

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