Home » RDBMS Server » Server Administration » How To make Queries In Sql
How To make Queries In Sql [message #56219] Thu, 13 March 2003 03:10 Go to next message
kausar
Messages: 3
Registered: July 2002
Junior Member
Hi Dear,

I am Biggner in oracle. I want know how to make quieres in esyway. any one can suggest me

Regards,

Kausar Ali
Re: How To make Queries In Sql [message #56248 is a reply to message #56219] Thu, 13 March 2003 11:48 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
1. Connect to SQL*Plus

c:> sqlplus username/password@tnsname

2. Issue your query

SQL> SELECT columnname1, columnname2 FROM tablename;

or

SQL> SELECT columnname1, columnname2 FROM tablename WHERE columnname3 = 'SOME TEXT CRITERIA';

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Previous Topic: Archive Log Problem
Next Topic: end-of-file on communication channel
Goto Forum:
  


Current Time: Sun Dec 29 00:04:29 CST 2024