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/Vinish/Answers
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Comments
  • Followers Questions
  • Followers Answers
  • Followers Posts
  • Followers Comments
  1. Asked: February 25, 2021

    ORA-01034 ORACLE not available

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Added an answer on February 25, 2021 at 8:43 am

    It seems your Oracle database instance is not running. You need to shut down Oracle database and then restart it. The following are the steps: Run SQLPLUS: sqlplus / as sysdba Then execute the below command: shutdown immediate Then exit: exit Again open SQLPLUS: sqlplus / as sysdba Execute the folloRead more

    It seems your Oracle database instance is not running. You need to shut down Oracle database and then restart it. The following are the steps:

    Run SQLPLUS:

    sqlplus / as sysdba

    Then execute the below command:

    shutdown immediate

    Then exit:

    exit

    Again open SQLPLUS:

    sqlplus / as sysdba

    Execute the following command:

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

    HOW TO CONVERT STRINGS TO DATE

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Replied to answer on February 23, 2021 at 6:14 pm
    This answer was edited.

    You need to turn off Escape Special Characters setting for the dynamic action you created for the date. Then it will be fine.

    You need to turn off Escape Special Characters setting for the dynamic action you created for the date. Then it will be fine.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  3. Asked: February 23, 2021

    HOW TO CONVERT STRINGS TO DATE

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Added an answer on February 23, 2021 at 2:47 pm

    For the Oracle Apex date item, you need to convert it to date with the date format. I am assuming that you are already displaying the date in the mm/dd/yyyy (05/25/2021) format. Below is the example: declare m_date date; duration number; begin duration := 91; SELECT to_date(:P35_DATE_OF_INVESTMENT,Read more

    For the Oracle Apex date item, you need to convert it to date with the date format. I am assuming that you are already displaying the date in the mm/dd/yyyy (05/25/2021) format. Below is the example:

    declare
    m_date date;
    duration number;
    begin
    duration := 91;
    SELECT to_date(:P35_DATE_OF_INVESTMENT, 'mm/dd/yyyy')  +  duration
     into m_date FROM dual;
    return trunc(m_date);
    end;

     

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  4. Asked: February 16, 2021

    How to Generate Multi-Sheet Excel Export From Oracle APEX with Bi-Publisher

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Replied to answer on February 23, 2021 at 11:26 am

    I have suggested you to install BI publisher to get the add-on for MS Word installed on your computer so that you can create RTF reports. There is no need for MS Word on the server. Also, there is no need for a BI publisher on your local computer because it is already installed on a server or cloud.Read more

    I have suggested you to install BI publisher to get the add-on for MS Word installed on your computer so that you can create RTF reports. There is no need for MS Word on the server.

    Also, there is no need for a BI publisher on your local computer because it is already installed on a server or cloud. But you will have to install it on your local computer to get the add-on.

    After creating RTF files, you would upload them in Apex > Shared Components > Report layout.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  5. Asked: February 22, 2021

    How to use GTT in Oracle Apex?

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Added an answer on February 23, 2021 at 6:02 am

    You can use the Global temporary table in Oracle Apex as you were using in your old system. But between pages, if you experience issues because internal sessions got changed in Apex, you can use the normal table with two more columns to handle Apex user-wise. Below is an example: Add two more columnRead more

    You can use the Global temporary table in Oracle Apex as you were using in your old system. But between pages, if you experience issues because internal sessions got changed in Apex, you can use the normal table with two more columns to handle Apex user-wise. Below is an example:

    Add two more columns apex_user and apex_session, to your normal table. Write a process on the login page (9999) to delete the current user's data. Now, whenever you insert or update, you will update the apex_user and the apex_session with your Oracle Apex session-id (:app_session). And use these criteria to read and write the data in the whole application.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  6. Asked: February 19, 2021

    Subquery in PL/SQL function which returns error text

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Added an answer on February 20, 2021 at 7:06 am

    You can create a function to check if the supplied customer number exists or not. Below is an example: Create or Replace function check_customer(p_customer in number) Return varchar2 is cursor c_cust is select 1 from target_table where customer_id = p_customer; n_exists number; Begin open c_cust; feRead more

    You can create a function to check if the supplied customer number exists or not. Below is an example:

    Create or Replace function check_customer(p_customer in number)
       Return varchar2 
      is
      cursor c_cust
        is
       select 1 from target_table
        where customer_id = p_customer;
      
       n_exists number;
    Begin
        open c_cust;
        fetch c_cust into n_exists;
        close c_cust;
        if nvl(n_exists, 0) = 1 then
           return 'Customer exists.'
        else
           Return null;
        end if;
    End;

    Now you can use the above function as follows:

    Begin
       if check_customer(388383) is not null then
         -- customer exists 
         -- do something here
       else
         -- customer not exists
       end if;
    end;

    In SQL query:

    Select * from sales_orders s
      where check_customer(s.customer_id) is null;

     

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  7. Asked: February 19, 2021

    How to add CSS to navigation bar item in Oracle Apex

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Best Answer
    Vinish Legendary
    Added an answer on February 20, 2021 at 6:57 am

    You will have to inspect the element containing the value. In my case, I found the below CSS classes, and it worked for me. Follow these steps: Create a CSS file name it notification.css and paste the following CSS in it: a.t-Button--navBar .t-Button-label { background-color: red; padding-left: 5px;Read more

    You will have to inspect the element containing the value. In my case, I found the below CSS classes, and it worked for me. Follow these steps:

    Create a CSS file name it notification.css and paste the following CSS in it:

    a.t-Button--navBar .t-Button-label {
    background-color: red;
    padding-left: 5px;
    padding-right: 5px;
    padding-top: 2px;
    padding-bottom: 2px;
    border-radius: 3px;
    }

    Save the CSS file and close.

    In Oracle Apex, click on the Shared components > Application Static Files and upload this notification.css file. After uploading, it will show you the record. Copy the text from the reference column; it should be something like #APP_IMAGES#notification.css.

    Now click on the Shared Components > User Interface Attributes > Cascading Stylesheets, and in the File URLs field, paste the #APP_IMAGES#notification.css in the next line.

    Click on the Apply button and test your application.

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  8. Asked: February 18, 2021

    How to validate Cell Value in interactive Grid Oracle APEX?

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Added an answer on February 19, 2021 at 6:39 am

    You can create a validation on that IG column. Select the validation type as SQL query returning rows and then add the following query in it: Example Select 1 from dual where :order_value between :p1_min and :p1_max;

    You can create a validation on that IG column. Select the validation type as SQL query returning rows and then add the following query in it:

    Example

    Select 1 from dual where :order_value between :p1_min and :p1_max;
    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  9. Asked: February 18, 2021

    APEX 19 or 20, how do I add background color or text color to each tab within the tab container?

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Added an answer on February 19, 2021 at 6:34 am

    To change the background of each tab, go to the Advanced > Customer Attributes and paste the following code: style="background-color: orange;" Change the color according to your needs. To change the foreground color of each tab. Assign a static id to each tab, then adds the following CSS in the pRead more

    To change the background of each tab, go to the Advanced > Customer Attributes and paste the following code:

    style="background-color: orange;"

    Change the color according to your needs.

    To change the foreground color of each tab. Assign a static id to each tab, then adds the following CSS in the page's CSS > inline section. For example, you have assigned the static id as tab1 then the CSS code will be as follows:

    #SR_tab1 .t-Region-body {color: red;}

    Add #SR_ to your static ids to apply foreground color in the CSS.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  10. Asked: February 16, 2021

    How to Generate Multi-Sheet Excel Export From Oracle APEX with Bi-Publisher

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Replied to answer on February 19, 2021 at 6:17 am

    The following are my answers: Yes, you have to create an RTF file in MS Word. Also, install the latest BI publisher version on your Windows, then from the BI publisher windows menu, you will get an option Add-on/Plugin for MS Word. Click on this option to install. After that, open the MS Word, and tRead more

    The following are my answers:

    1. Yes, you have to create an RTF file in MS Word. Also, install the latest BI publisher version on your Windows, then from the BI publisher windows menu, you will get an option Add-on/Plugin for MS Word. Click on this option to install. After that, open the MS Word, and there you will see the BI publisher tab. Use this tab to create reports.
    2. Yes, you will have to create 3 different queries.
    3. Yes, you will have to specify/upload that RTF file in the Report Layout.
    4. No, there no need to make any changes there.

    I will soon write a tutorial on it and then will share it with you.

    See less
    • 2
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
1 2 3 … 47

Sidebar

Ask Question
Write a Post
  • Recent
  • Answers
  • Hussain

    Need to displayed Total in Interactive Report

    • 2 Answers
  • sathishkeethi

    APEX - How to Upload & Download Document in my ...

    • 0 Answers
  • Kanshu

    Can you explain this 15 puzzle code in shell script ...

    • 0 Answers
  • Sanjay

    ORA-01034 ORACLE not available

    • 2 Answers
  • afzal
    afzal added an answer STEP -1 CREATE REPORT LIKE-- select SAL AS "SALARY", NVL(COMM,0)… March 2, 2021 at 10:25 am
  • apex4ebs
    apex4ebs added an answer I have used a union in the sql of the… March 1, 2021 at 1:38 pm
  • Eyad
    Eyad added an answer Thank you. I noticed that The type sequence works only… February 28, 2021 at 3:27 am
  • SupriyaJain
    SupriyaJain added an answer Called color_ig_cells() in Page change event. It is working now.… February 26, 2021 at 4:29 pm
  • SupriyaJain
    SupriyaJain added an answer When I toggle between Page Numbers at the bottom of… February 26, 2021 at 3:10 pm

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