Ask The Oracle Mentors

Recently Answered

	Stored 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...
	Split 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, '...
	impdp 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 ...
	how 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 ...
	What 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...