Questions about oracle11g
Read more about oracle11g
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
how to get list of columns of an record type or list of columns for an Object type in Oracle
If we create an object type or recrod type like below
create type t_data as object(
execId varchar2(500),
description varchar2(500)
);
/
then how to get the list of columns for this type at later...
sakeesh
Votes: 0
Answers: 2
How to convert CLOB into NVARCHAR2 chunks as per the size of the CLOB?
We have a procedure that generates an HTML report and stores the entire value into a CLOB field. It is then sent to a different procedure which sends an email using UTL_SMTP. The email size can vary, ...
user3625561
Votes: 0
Answers: 1
Unable to get scn timestamp in oracle 11g
Scn_to_timestamp(ora_rowscn) function gives me unsupported network data type or representation error but ora_rowscn giving change number
Simz
Votes: 0
Answers: 1
parent-child hierarchy with multiple parents in ORACLE
I trying to make a parent-child hierarchy tree in Oracle 11g but with this condition
every CODE is unique(no duplicate) and has main parent in PARENT_ID
but there is an exception when PARENT_ID IS LI...
wrath
Votes: 0
Answers: 1