Getting ORA-00904: : invalid identifier error when run a query
I am running the query in this message, but getting the below error messages. Do you mind taking
…I am running the query in this message, but getting the below error messages. Do you mind taking
…Can someone please help with multiple cursors in a store procedure
create or replace PROCEDURE
…In the following code I get the result as follows:
WITH SplitData AS (
SELECT
RULEID,
…
Hi,
Right now we have a plan to migration SQL 2019/2022 on pre to Azure SQL, please suggest the
…Hi Team,
Iam workign on Oracle 12c and working on the sample hr schema.
Getting the below error
…I have a table and that contains 2 dates column like Live_date and De_install_date. Suppose I have a
…Can someone explain in detail and with a couple of examples what is the purpose of using CONNECT BY
…Hi Team,
Need help on the control file to handle the data for columns spanning multiple lines .
Iam
…I am creating a global temporary table for further processing. It was working as expected.
I then
…I have worked through creating a script to produce a exported csv file that works when executed
…I created a temporary table that will generate between 3000-4000 records each time it is created
…We are looking into using COMPRESSION=ALL on oracle19c datapump export. Does this require advanced
…The name of databases is stored in a table in this format "XXXXXXXX:YYYXXXXX". I want to use substr
…Hi
If I need to take a logical export copy of oracle 19c DB using Data pump before migrating it to
…We've recently upgraded our DB from 18.xx to 19.21 and from APEX 19.xx to 23.2
Now, we're kinda
…Need help to parse a xml. It is stored in Clob datatype. This xml contains a tag
…Hi Experts,
I have a 20-25 oracle tables and want to use it on ms sql.
What is your suggestion for
…Have some procedures written in T-SQL and need to convert it into Oracle PL/SQL language. Looking
…Hi
I am migrating a schema from one DB to another target DB using exp/imp.
The dump will not include
…Hi experts,
i want export a schema from oracle 12 on linux via client 19c on windows
export going ok
…