Home » Developer & Programmer » Designer » ERD in Dba Studio? Formating SQL output?
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:
  


Current Time: Thu Mar 28 08:08:08 CDT 2024