| select statement [message #183912] |
Mon, 24 July 2006 06:31  |
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  |
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 |
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 #183933 is a reply to message #183926] |
Mon, 24 July 2006 08:05 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
