OraFAQ Forum: Forms » Rows into Column.

Home » Developer & Programmer » Forms » Rows into Column. (Form 6i, 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rows into Column. [message #673064]

Sun, 04 November 2018 06:43

shahzad-ul-hasan
Messages: 580
Registered: August 2002

Senior Member

Respcted,
Please view the tables below:

Table--Class:
Cid       Number(4) primary key
CName     Varchar2(30)

Table--Sub:
Cid       Number(4)  --Foreign key Class(CID)
Sno       Number(3)
Sub       Varchar2(4) --Subject of Class

The class table has 10 rows and sub has 30 rows: i want to select class and its subject shows as Column using master detail relationship.when i change class its automatically change its subject in columns.
please advised.

Report message to a moderator

Re: Rows into Column. [message #673091 is a reply to message #673064]

Mon, 05 November 2018 08:51

joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA

Senior Member

I don't understand what these mean:

"its subject shows as column"
"when i change class its automatically change its subject in columns"

Do you not know how to make a relation between two tables in Forms?

Report message to a moderator

Previous Topic:	Open OBIEE report from Oracle form 12c
Next Topic:	Pre-insert not firing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 12 03:32:44 CDT 2021