Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how report can be generated if we have the database designed
in oracle 10g?

Answer Posted / su

By using sql*plus environment.
we can specify the column width , through following
sql> COL empno FORMAT 999999
sql>COL ENAME FORMAT A30

sql>SELECT empno as "Employee Number",
ename as 'Employee Name"
FROM emp;

we can also use TTITLE, BTITLE etc
:)

Is This Answer Correct ?    0 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a user exit program in oracle reports?

1027


Name the different triggers supported by oracle reports and their firing order.

1083


did u received a single file or multiple files

2016


i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1979


hiding item in report how like that properly,thats manually but at runtime i want to do

3232


What do you understand by oracle forms and why are they required?

1018


What is a matrix report and how many minimum groups are required to prepare the same?

1139


What is the difference between bind and lexical parameter?

1078


how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1977


How to create Drill down report?

2127


What is responsibility and how u attach How to create user and how u attach with responsibility.

2038


i am writing a query select EmpNo from Emp how can i call in after parameter form

2124


I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1207


what are bind variables?

1087


If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2327