Home » SQL & PL/SQL » SQL & PL/SQL » select statement
select statement [message #183912] Mon, 24 July 2006 06:31 Go to next message
sahan
Messages: 2
Registered: July 2006
Junior Member
Dear All,
Can anybody tell me "How select statement works in sql?"

e.g "select * from employee"

any help is appreciated

thanks
Re: select statement [message #183915 is a reply to message #183912] Mon, 24 July 2006 06:40 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
It works like this

Read, understand, practice.

Feel free to get back to us if you've got any more specific questions.

Out of curiosity, if the not understanding the SELECT statement is an Expert level SQL problem, what would a Newbie problem look like?
Re: select statement [message #183926 is a reply to message #183915] Mon, 24 July 2006 07:28 Go to previous messageGo to next message
sahan
Messages: 2
Registered: July 2006
Junior Member
Thanks for the reply
I went through it before posting the message
But what I want is How does select do in "select * from employee" to write in a 1 page assignment report

Any help is appreciated
Thanks
Re: select statement [message #183930 is a reply to message #183926] Mon, 24 July 2006 07:49 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Should also read over Formatting SQL*Plus Reports.
Re: select statement [message #183933 is a reply to message #183926] Mon, 24 July 2006 08:05 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Ok, you need Part V => Chapter 14 => SQL Statements => SQL Overview in the Concepts Manual
It goes through everything Oracle does to process a SQL statement, although you probably want to read Part I => Chapter 1 => Data Concurrency and consistency overview to get a good explanation of multiversioning
Re: select statement [message #184029 is a reply to message #183933] Mon, 24 July 2006 23:21 Go to previous message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
try reading the oracle book 1 on sql,then may be you can write an assignment of 3 pages.
Previous Topic: sub sub queries
Next Topic: Decode with multiple values
Goto Forum:
  


Current Time: Sun Dec 04 04:33:19 CST 2016

Total time taken to generate the page: 0.12645 seconds