Solved

is there an oracle equivalent of sybase utility isql

Posted on 2009-05-05
5
878 Views
Last Modified: 2013-12-18
i need to login to oracle databases and query the data and DB table structur eetc. i am working on linux using x-windows. i need a command-line tool to get there
0
Comment
Question by:jothi85
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 4

Expert Comment

by:dkaisla
ID: 24311762
use sqlplus
0
 
LVL 4

Assisted Solution

by:dkaisla
dkaisla earned 150 total points
ID: 24311769
in command line: sqlplus username/password@db_name
0
 
LVL 28

Accepted Solution

by:
Naveen Kumar earned 350 total points
ID: 24311842
you can even use toad which is GUI layer which works good for oracle databases.
0
 

Author Closing Comment

by:jothi85
ID: 31578125
i was looking for a replacement for sybase central, and this serves the purpose. but when i could not find one, i was willing to settle for isql. i already was using sqlplus, but my question was not properly posed, and dkaisla was right on the money. nav kum v helped out by giving the info on Toad, which i had never seen or used. i like the product now, and i have already download and installed. I thank both the experts.
0
 
LVL 4

Expert Comment

by:dkaisla
ID: 24332600
oh i thought you were looking for the command line tool. oracle has a freeware, SQL Developer, which you can use. it can be found on OTN
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

635 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question