Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

how to convert column into rows?

user8731258Feb 21 2010 — edited Nov 4 2010
Hi,
I have a table say a.IT has gt columns a_1,a_2,a_3.a_4.I have another table b.It has got only one column b.
Now i want to insert the 4 columns from table a into 4 rows of table b.
Can u please suggest the code.
I am using oracle 10g.

Comments

Howard (... in Training)
I saw that or something similar too. Are you still getting it? I suspect it's a transient system problem that will go away.

Howard
mini
Nearly I tried to create the application more than 5 times, still facing the same issue.

Not sure with this problem??

Brgds,
Mini
TexasApexDeveloper
A table space has run out of room where you are trying to add data to it.. The dba's that support the site should see this and correct the error...

Thank you,

Tony Miller
Ruckersville, VA
Okay. I got the same error but it did create my test 2-page demo application.
mini
where you are trying to add data to it
Just trying to create a blank home page as a db application in apex.oracle.com.

Still Error persist
ORA-01654: unable to extend index APEX_040200.WWV_FLOW_BLD_AUDIT_PK by 1024 in tablespace APEX_REL42 .
Mini
mini
Whether is this tablespace issue will cause any problems, with the app which is created

Mini
TexasApexDeveloper
I would suggest you STOP trying to build pages until the situation is resolved by the DBA supporting the hosted site. You are NOT going to get to far at this point, since you need the tablespace increased to store metadata items you are creating in your application..

May I also suggest SOMEONE post a message with the error message as the title, so the Oracle support folks who monitor the forum know this is going on...


Thank you,

Tony Miller
Ruckersville, VA
Howard (... in Training)
Possibly. I'd try again in an hour. And you could email the Admins. http://apex.oracle.com/pls/otn/f?p=35144:411:0

But I'd think they know by now. And I'd think this problem rarely happens. So since it has, perhaps it will take a bit longer to fix.

Howard
Howard (... in Training)
Mini,

Would you open a new thread with the error? You'll have to remove some words because it's too long for a "subject".

Howard
mini
Thanks Tony, for the Error announcement
;)

Brgds,
Mini
1 - 10
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 29 2010
Added on Feb 21 2010
10 comments
30,927 views