473,382 Members | 1,749 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Basic Tips Needed

Hi Friends,

I really need help from you people...I am a very new user of Oracle database...so need some basic tips from you...

1.What query do u type in sql*plus to see all the tables in a database?
2.when I run a select statement..it shows many records which are in a hapazard manner...How do u see to it that a complete row comes in one line?
linespace query
Jan 2 '07 #1
2 1574
Hi Friends,

I really need help from you people...I am a very new user of Oracle database...so need some basic tips from you...

1.What query do u type in sql*plus to see all the tables in a database?
2.when I run a select statement..it shows many records which are in a hapazard manner...How do u see to it that a complete row comes in one line?
linespace query
To display all tables we can use

SELECT * from tab;
0r
SELECT * from user_tables;

To get the output of select statements in a ordered mannaer u can use the set command and its various options like linesize , pagesize...etc
Feb 20 '07 #2
vijaydiwakar
579 512MB
Hi Friends,

I really need help from you people...I am a very new user of Oracle database...so need some basic tips from you...

1.What query do u type in sql*plus to see all the tables in a database?
2.when I run a select statement..it shows many records which are in a hapazard manner...How do u see to it that a complete row comes in one line?
linespace query

Answer
1: Select * from tab;
2: set line 1000;
or goto the menu bar there are some settings for Envirment
Feb 22 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Mike Chirico | last post by:
Interesting Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Copyright (GPU Free Documentation License) 2004 Last Updated: Mon Jun 7 10:37:28 EDT 2004 The latest...
4
by: Harris | last post by:
Can anyone please help? I have read the postings on the error "The Visual Basic for Applications Project in the database is corrupt" but none report the particular problem I am experiencing, i.e.,...
5
by: Bob Alston | last post by:
I am looking for any Microsoft Access based software that could be used for a United Way agency that provides basic needs assistance - food, clothing, financial (rent, utilities, Rx, gasoline,...
1
by: nicole bissell | last post by:
Hello, I am working in a new form and still making changes to the visual basic code of the form. Not always, but very often when I try to save my changes in the visual basic window and press the...
5
by: BethInAK | last post by:
Thank you in advance for any possible help you have to offer, before I pull my hair out! I am incredibly frustrated attempting to learn asp.net. Its really pissing me off. Please help. ...
4
by: Mark Linehan | last post by:
Greetings and salutations. I began programming God knows how many years ago in basic on the Commodore 64. I dabbled in a little assembly as well. I moved on to the PC eventually and stuck with...
3
by: Miro | last post by:
Ok im a newbie to VB, and am having some trouble reading msdn help / or how it all links together. My books are either missing a step / or assume everything is set up correctly. I know about...
1
by: Lastknight | last post by:
hi everyone give some basic tips about how to understand oops in perl and how to build a package by using it.............
1
by: Coll | last post by:
I'm working on a database that someone else created. I have a form - frm_main that is based on a query that is based on two tables. The join is such that the first table tbl_JCN has all records...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.