OraFAQ Forum: Designer » ERD in Dba Studio? Formating SQL output?

Home » Developer & Programmer » Designer » ERD in Dba Studio? Formating SQL output?

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

ERD in Dba Studio? Formating SQL output? [message #115500]

Tue, 12 April 2005 01:25

S. M. Waqas Shabir
Messages: 30
Registered: January 2004

Member

Hi

How to view the ERD in DBA Studio. I m running Oracle Enterprise Manager 2.2.0.0.0

Also i want to format my sql output. Currently the output looks like this

Quote:

SYSTEMUSERIDP DESIGNATIONIDF
----------------------------------- -----------------------------------
TITLEIDF
-----------------------------------
NAME
--------------------------------------------------------------------------------
PASSWORD EMAIL OFFICENO
---------- ----------------------------------- --------------------
FAXNO HOMENO MOBILENO
-------------------- -------------------- --------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
QUALIFICATION
--------------------------------------------------------------------------------
SPECIALIZATION
--------------------------------------------------------------------------------
JOBHISTORY
--------------------------------------------------------------------------------
TRAININGS
--------------------------------------------------------------------------------
SECRETQUESTION
--------------------------------------------------------------------------------
SECRETANSWER
--------------------------------------------------------------------------------
SE
--
1 1

SYSTEMUSERIDP DESIGNATIONIDF
----------------------------------- -----------------------------------
TITLEIDF
-----------------------------------
NAME
--------------------------------------------------------------------------------
PASSWORD EMAIL OFFICENO
---------- ----------------------------------- --------------------
FAXNO HOMENO MOBILENO
-------------------- -------------------- --------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
QUALIFICATION
--------------------------------------------------------------------------------
SPECIALIZATION
--------------------------------------------------------------------------------
JOBHISTORY
--------------------------------------------------------------------------------
TRAININGS
--------------------------------------------------------------------------------
SECRETQUESTION
--------------------------------------------------------------------------------
SECRETANSWER
--------------------------------------------------------------------------------
SE
--
1

SYSTEMUSERIDP DESIGNATIONIDF
----------------------------------- -----------------------------------
TITLEIDF
-----------------------------------
NAME
--------------------------------------------------------------------------------
PASSWORD EMAIL OFFICENO
---------- ----------------------------------- --------------------
FAXNO HOMENO MOBILENO
-------------------- -------------------- --------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
QUALIFICATION
--------------------------------------------------------------------------------
SPECIALIZATION
--------------------------------------------------------------------------------
JOBHISTORY
--------------------------------------------------------------------------------
TRAININGS
--------------------------------------------------------------------------------
SECRETQUESTION
--------------------------------------------------------------------------------
SECRETANSWER
--------------------------------------------------------------------------------
SE
--
S. M. Waqas Shabir

SYSTEMUSERIDP DESIGNATIONIDF
----------------------------------- -----------------------------------
TITLEIDF
-----------------------------------
NAME
--------------------------------------------------------------------------------
PASSWORD EMAIL OFFICENO
---------- ----------------------------------- --------------------
FAXNO HOMENO MOBILENO
-------------------- -------------------- --------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
QUALIFICATION
--------------------------------------------------------------------------------
SPECIALIZATION
--------------------------------------------------------------------------------
JOBHISTORY
--------------------------------------------------------------------------------
TRAININGS
--------------------------------------------------------------------------------
SECRETQUESTION
--------------------------------------------------------------------------------
SECRETANSWER
--------------------------------------------------------------------------------
SE
--
smws1 mail4waqas@yahoo.com 051 9219485

SYSTEMUSERIDP DESIGNATIONIDF
----------------------------------- -----------------------------------
TITLEIDF
-----------------------------------
NAME
--------------------------------------------------------------------------------
PASSWORD EMAIL OFFICENO
---------- ----------------------------------- --------------------
FAXNO HOMENO MOBILENO
-------------------- -------------------- --------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
QUALIFICATION
--------------------------------------------------------------------------------
SPECIALIZATION
--------------------------------------------------------------------------------
JOBHISTORY
--------------------------------------------------------------------------------
TRAININGS
--------------------------------------------------------------------------------
SECRETQUESTION
--------------------------------------------------------------------------------
SECRETANSWER
--------------------------------------------------------------------------------
SE
--
051 5513925 0300 5144721

SYSTEMUSERIDP DESIGNATIONIDF
----------------------------------- -----------------------------------
TITLEIDF
-----------------------------------
NAME
--------------------------------------------------------------------------------
PASSWORD EMAIL OFFICENO
---------- ----------------------------------- --------------------
FAXNO HOMENO MOBILENO
-------------------- -------------------- --------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
QUALIFICATION
--------------------------------------------------------------------------------
SPECIALIZATION
--------------------------------------------------------------------------------
JOBHISTORY
--------------------------------------------------------------------------------
TRAININGS
--------------------------------------------------------------------------------
SECRETQUESTION
--------------------------------------------------------------------------------
SECRETANSWER
--------------------------------------------------------------------------------
SE
--
H. A-33, Street 4, Baith Saida Colony, Misrial Chowk, Rawalpindi Cantt.

SYSTEMUSERIDP DESIGNATIONIDF
----------------------------------- -----------------------------------
TITLEIDF
-----------------------------------
NAME
--------------------------------------------------------------------------------
PASSWORD EMAIL OFFICENO
---------- ----------------------------------- --------------------
FAXNO HOMENO MOBILENO
-------------------- -------------------- --------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
QUALIFICATION
--------------------------------------------------------------------------------
SPECIALIZATION
--------------------------------------------------------------------------------
JOBHISTORY
--------------------------------------------------------------------------------
TRAININGS
--------------------------------------------------------------------------------
SECRETQUESTION
--------------------------------------------------------------------------------
SECRETANSWER
--------------------------------------------------------------------------------
SE
--
Jhang

SYSTEMUSERIDP DESIGNATIONIDF
----------------------------------- -----------------------------------
TITLEIDF
-----------------------------------
NAME
--------------------------------------------------------------------------------
PASSWORD EMAIL OFFICENO
---------- ----------------------------------- --------------------
FAXNO HOMENO MOBILENO
-------------------- -------------------- --------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
QUALIFICATION
--------------------------------------------------------------------------------
SPECIALIZATION
--------------------------------------------------------------------------------
JOBHISTORY
--------------------------------------------------------------------------------
TRAININGS
--------------------------------------------------------------------------------
SECRETQUESTION
--------------------------------------------------------------------------------
SECRETANSWER
--------------------------------------------------------------------------------
SE
--
MCS, BCS, F.Sc. (Pre-Medical)

SYSTEMUSERIDP DESIGNATIONIDF
----------------------------------- -----------------------------------
TITLEIDF
-----------------------------------
NAME
--------------------------------------------------------------------------------
PASSWORD EMAIL OFFICENO
---------- ----------------------------------- --------------------
FAXNO HOMENO MOBILENO
-------------------- -------------------- --------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
QUALIFICATION
--------------------------------------------------------------------------------
SPECIALIZATION
--------------------------------------------------------------------------------
JOBHISTORY
--------------------------------------------------------------------------------
TRAININGS
--------------------------------------------------------------------------------
SECRETQUESTION
--------------------------------------------------------------------------------
SECRETANSWER
--------------------------------------------------------------------------------
SE
--
Software Engineering

SYSTEMUSERIDP DESIGNATIONIDF
----------------------------------- -----------------------------------
TITLEIDF
-----------------------------------
NAME
--------------------------------------------------------------------------------
PASSWORD EMAIL OFFICENO
---------- ----------------------------------- --------------------
FAXNO HOMENO MOBILENO
-------------------- -------------------- --------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
QUALIFICATION
--------------------------------------------------------------------------------
SPECIALIZATION
--------------------------------------------------------------------------------
JOBHISTORY
--------------------------------------------------------------------------------
TRAININGS
--------------------------------------------------------------------------------
SECRETQUESTION
--------------------------------------------------------------------------------
SECRETANSWER
--------------------------------------------------------------------------------
SE
--
EAD,PRAL,agico,Lead Pakistan

SYSTEMUSERIDP DESIGNATIONIDF
----------------------------------- -----------------------------------
TITLEIDF
-----------------------------------
NAME
--------------------------------------------------------------------------------
PASSWORD EMAIL OFFICENO
---------- ----------------------------------- --------------------
FAXNO HOMENO MOBILENO
-------------------- -------------------- --------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
QUALIFICATION
--------------------------------------------------------------------------------
SPECIALIZATION
--------------------------------------------------------------------------------
JOBHISTORY
--------------------------------------------------------------------------------
TRAININGS
--------------------------------------------------------------------------------
SECRETQUESTION
--------------------------------------------------------------------------------
SECRETANSWER
--------------------------------------------------------------------------------
SE
--

SYSTEMUSERIDP DESIGNATIONIDF
----------------------------------- -----------------------------------
TITLEIDF
-----------------------------------
NAME
--------------------------------------------------------------------------------
PASSWORD EMAIL OFFICENO
---------- ----------------------------------- --------------------
FAXNO HOMENO MOBILENO
-------------------- -------------------- --------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
QUALIFICATION
--------------------------------------------------------------------------------
SPECIALIZATION
--------------------------------------------------------------------------------
JOBHISTORY
--------------------------------------------------------------------------------
TRAININGS
--------------------------------------------------------------------------------
SECRETQUESTION
--------------------------------------------------------------------------------
SECRETANSWER
--------------------------------------------------------------------------------
SE
--
What is your favourite Colour?

SYSTEMUSERIDP DESIGNATIONIDF
----------------------------------- -----------------------------------
TITLEIDF
-----------------------------------
NAME
--------------------------------------------------------------------------------
PASSWORD EMAIL OFFICENO
---------- ----------------------------------- --------------------
FAXNO HOMENO MOBILENO
-------------------- -------------------- --------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
QUALIFICATION
--------------------------------------------------------------------------------
SPECIALIZATION
--------------------------------------------------------------------------------
JOBHISTORY
--------------------------------------------------------------------------------
TRAININGS
--------------------------------------------------------------------------------
SECRETQUESTION
--------------------------------------------------------------------------------
SECRETANSWER
--------------------------------------------------------------------------------
SE
--
Horse

SYSTEMUSERIDP DESIGNATIONIDF
----------------------------------- -----------------------------------
TITLEIDF
-----------------------------------
NAME
--------------------------------------------------------------------------------
PASSWORD EMAIL OFFICENO
---------- ----------------------------------- --------------------
FAXNO HOMENO MOBILENO
-------------------- -------------------- --------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
QUALIFICATION
--------------------------------------------------------------------------------
SPECIALIZATION
--------------------------------------------------------------------------------
JOBHISTORY
--------------------------------------------------------------------------------
TRAININGS
--------------------------------------------------------------------------------
SECRETQUESTION
--------------------------------------------------------------------------------
SECRETANSWER
--------------------------------------------------------------------------------
SE
--
99

SYSTEMUSERIDP DESIGNATIONIDF
----------------------------------- -----------------------------------
TITLEIDF
-----------------------------------
NAME
--------------------------------------------------------------------------------
PASSWORD EMAIL OFFICENO
---------- ----------------------------------- --------------------
FAXNO HOMENO MOBILENO
-------------------- -------------------- --------------------
ADDRESS1
--------------------------------------------------------------------------------
ADDRESS2
--------------------------------------------------------------------------------
QUALIFICATION
--------------------------------------------------------------------------------
SPECIALIZATION
--------------------------------------------------------------------------------
JOBHISTORY
--------------------------------------------------------------------------------
TRAININGS
--------------------------------------------------------------------------------
SECRETQUESTION
--------------------------------------------------------------------------------
SECRETANSWER
--------------------------------------------------------------------------------
SE
--

SQL>

I want to show the row in one line depending upon the data that the column contains.

Thanks in anticipation

[Updated on: Tue, 12 April 2005 01:39]

Report message to a moderator

Previous Topic:	Primary tables
Next Topic:	How to prepare technical documentation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 17 22:22:09 CST 2025