Thank you :)
what data type does ctx_ddl take? I tried to declare as ctx_ddl varchar2; but is throwing error
I am trying to create a procedure as follows-
CREATE PROCEDURE try_ctx IS
THANKYOU :) :)
I am getting the following error while trying to execute below code
- Error(2,2): PLS-00103: Encountered the symbol " " when...
I am trying to retrieve all views which are using a particular function.
But when I run the statement -
The below code eliminates text between <> angular brackets,
and replces & with &
" with "
< with <
> with >
I have a column, which stores long text description with special characters of html like <> , & ,< , > ,& ," .
Can you please send me appropriate link, where to post this question. I am unable to locate exact forum.
I have a column, which stores long text description with special characters of html like <> , & ,< , > ,& ," ....
I have a requirement to fetch all records from a table, when the passed parameter is "NULL" in oracle query.
Query -select *...
This is the below query, I want to rewrite using CTE. please help.
CREATE OR REPLACE VIEW "Mx"."Dim_abc_v"
("abc", "abc", "pqr",...
can you please suggest on the question. //i have provided sample data nd create stmt.
please find below-
NOPARALLELCREATE TABLE max.ancestor
lcation VARCHAR2(30 CHAR) NOT NULL
, ANCESTOR VARCHAR2(30 CHAR) NOT NULL
I have a table ancestor, which has locations in a parent-child hierarchy. eg; abc1-0001,abc1-0001-ab,abc1-0001-ab-01 etc, where...