Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered Report

Chris SaxonStored Procedures for insert statements
Hello, Ask Tom Team.I have like 20 tables using identity column for pk. Right now, I'm using returning clause to retrieve the pk (identity column using Oracle 12c feature) to be used as fk in the child tables. I have been asked to use stored procedures to popu...
Chris SaxonSplit Records into Groups of N Rows
Got a SQL from the table with 100,000 + records , one particular varchar2 field contains strings like '12345', '56789', '1111'. I would like to create a table with split / chunks with appropriate comma seperate example in the live link ::: select listagg(id, '...
Chris Saxonimpdp truncate date imported in timestamp
Hi,I created a table with a date column in an Oracle 18 database and I filled it with some date values: create table test_date (col1 date); insert into test_date values (sysdate); insert into test_date values (sysdate); select * from test_date; COL1 ...
Chris Saxonhow to use profiler (similar to MS SQL Server) in Oracle SQL Developer
how to use profiler (similar to MS SQL Server) in Oracle SQL Developer ...
Chris SaxonWhat are the alternatives for ORA_EXCEL (Oracle Excel) is a PL/SQL package for Oracle® database that produces Excel XLSX documents?
I wish to generate reports from my Oracle 11g database in an MS excel document(multiple tabs).Do we have a solution or a product from Oracle for this task?Thank you, Sunil...

Resources