English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

2006-07-26 04:24:33 · 4 answers · asked by Caesar Alejandro B 1 in Computers & Internet Programming & Design

4 answers

SELECT * FROM tableName

2006-07-26 04:36:44 · answer #1 · answered by John J 6 · 0 1

Select * from tablename; This will displays all the contents in the table.
Select empname, emp_id, salary from Employee;
This will display the employeename, identity, salary from the table named Employee.U will get the result only if if you have created the table named Employee.
Create table Employee
Empname Varchar2(15), Empid varchar2(10);
This will create a table named Employee with the fields Empname, empid.
for inserting values into that table u need to use insert table values statement.This is enough for time being.

2006-07-26 04:58:04 · answer #2 · answered by Anonymous · 0 0

SQL> select 'Hello World' from dual;
'HELLOWORLD
-----------
Hello World

SQL> select 2+2 from dual;

2+2
----------
4
select * from users;

would retrieve all the information from every row of the users table.
SQL> select count(*) from users;
figure out what columns are available in the users table
describe users
The data dictionary is simply a set of built-in tables that Oracle uses to store information about the objects (tables, triggers, etc.) that have been defined.
http://cas.sdss.org/dr4/sp/help/docs/realquery.asp
http://philip.greenspun.com/sql/queries.html

2006-07-26 05:07:51 · answer #3 · answered by Friend 2 · 0 0

Download the documentation for MySQL and you will get plemty of examples + explanations.

The perfect starting point:
http://dev.mysql.com/doc/

2006-07-26 04:28:41 · answer #4 · answered by sheeple_rancher 5 · 0 0

fedest.com, questions and answers