Forum Stats

  • 3,722,791 Users
  • 2,244,415 Discussions
  • 7,850,094 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

how to concatenate all the tables of an oracle version 8i database

User_6SHB1
User_6SHB1 Member Posts: 7

Hi everyone, I am new to the oracle community, and I have a problem with an oracle database on version 8i. What I want to do is concatenate all the tables in a database (database name is SYS) and I put the following query:

select table_name from all_tables where rownum < 3


And when I did, I skip the following error:

 SQL execution error, ORA-01427: single-row subquery returns more than one row


Try putting wm_concat ():

select wm_concat (table_name) from SYS.all_tables where rownum < 3


but I get the following error:

 SQL execution error, ORA-00904: invalid column name


Also try concat ():

select concat (table_name) from SYS.all_tables where rownum < 3


but I get this error:

 SQL execution error, ORA-00909: invalid number of arguments


And finally, try LISTAGG:

SELECT LISTAGG (table_name || CHR (58) || CHR (58) || column_name || CHR (60) || CHR (108) || CHR (105) || CHR (62)) within group (ORDER BY table_name ) FROM SYS.all_tab_columns WHERE rownum < 2


But I get this error too:

 SQL execution error, ORA-00923: FROM keyword not found where expected


I don't know what to do to be able to concatenate all the tables in the SYS database.


If someone knows how please help me and tell me how to solve this problem, I would be very grateful.

Answers

Sign In or Register to comment.