• How to call PL/SQL code from APEX SQL scripts?

    I'm building an application in Oracle APEX and need some help implementing program logic and business rules that require more complexity than just declarative SQL.

    Specifically, I have situations where I need to implement things like:

    • Loops to process…
  • Why is it that after successfully installing server components on the server side, using ApexSQL recover to connect to the database on another computer still prompts for the need to install server components?

    Why is it that after successfully installing server components on the server side, using ApexSQL recover to connect to the database on another computer still prompts for the need to install server components?

  • How to execute procedure in APEX SQL script?

    I am trying to understand how to use multiple procedures in APEX SQL script. First I don't really need stored procedure, but not sure how to declare simple procedure in APEX SQL script. So this is my attempt:

    create or replace procedure test1 as
    b…
  • Unable to use the free version of ApexSQL in Visual Studio Code on an AMD laptop

    Hello fellow developers,

     

    I'm facing a bit of a roadblock in my development process and could use some assistance. I recently installed Visual Studio Code on my AMD laptop, and I'm trying to use the free version of ApexSQL, a popular SQL Server development…

  • ApexSQL Search Not searching Body with WildCards

    I'm using a search with a wildcard it will search the Object name but it doesn't search the Object body.  I have Object bodies selected and I know at least on object that should be found but I don't get any results if I check only Object Bodies…

  • ApexSQL Pump Multiple File Import - Can multiple files be imported to multiple tables in one project?

    Is it possible to import multiple files to multiple tables in one project? Or do you need one project per import?

    I have existing tables in SQL Server and every month we truncate the tables and import new data to them.

    I'm using a trial version of ApexSQL…

  • ApexSQL Pump File Import - Can a Primary Key column be "ignored" during mapping before a file import?

    I have a txt file from a client with the structure: Column A, Column B, Column C. The table I want to import this to has an ID column set to primary key. SQL Server generates a new id when a row is added. So my table structure looks like: ID, Column A…

  • Question about AplexSql

    Dear All,

    I'm newbie in ApexSql.

    I have some questions about the Audit.

    1. Can ApexSql audit check the user that select data records more than normal, will be able to audit can show Alert or not
    (sample normal, user Alice select data from table …

  • Running in Connection timeout

    Hi,

    I want to experience if ApexSql Compare is an option for me. So i downloaden the trial-version.

    But very quick I ran into a timeout issue.

    Probably my network is to slow to connect within 15 seconds to the databases

    So I'm getting the error : …