To register for an Internet.com membership to receive newsletters and white papers, use the Register button ABOVE.
To participate in the message forums BELOW, click here

HOME 11g Central 10g Central 9i Central 8i Central Oracle News Scripts FAQ OCP Zone Resources Database Journal

Go Back   DBAsupport.com Forums > Oracle Forums > Oracle Development

Reply Post New Thread
 
Thread Tools Rate Thread Display Modes
  #1  
Old 07-10-2009, 01:27 AM
lucky10101 lucky10101 is offline
Junior Member
 
Join Date: Jul 2009
Posts: 10
SQL commandline commands,SQL help,practise paper, edit previous queries

1>SQL command line commands:
Friends while practising in lab i have come across some SQL commands like save ,clr scr, sho user from my friends can anybody tell me or give the list of this commands


2>Help in SQL like Unix:
Dont we have anything like $man command in unix for SQL also.

3>Practise paper:
I have completed my SQL basic course and i want to be thorough with queries, so i want some practise paper suggest me a website or mail me some practise paper to luckyrathod.Forum@gmail.Com i will b thankfull for it.

4>Trace previously entered query:
In unix we use up arrow key to track previously entered command the same we cannot do in SQL, is there any way to edit previously entered few queries
Reply With Quote
  #2  
Old 07-10-2009, 09:21 AM
ales ales is offline
Advisor
 
Join Date: Apr 2001
Location: Czechia
Posts: 712
Please don't confuse SQL (a query language) and SQL*Plus (a tool).

1> See the SQL*Plus manual: http://download.oracle.com/docs/cd/B...b14357/toc.htm

2> No, we don't. See http://download.oracle.com/docs/cd/B...b14200/toc.htm

3> Tons of stuff on the net, just try to search it.

4> Install rlwrap: http://www.oracle-base.com/articles/linux/rlwrap.php
__________________
Ales
The whole difference between a little boy and an adult man is the price of toys
Reply With Quote
Reply Post New Thread

Bookmarks

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump


All times are GMT -4. The time now is 10:36 AM.


DBAsupport.com Recent Articles


 » Configuring Oracle as a Data Source for SQL Server

 » When tuning Oracle is not an option

 » Leveraging Logical Standby Databases in Data Guard

 » Building an Oracle Server Environment

 » Oracle 11g Security – Guidelines for Auditing

Search DBAsupport:
 


Click Here to Expand Forum to Full Width











Acceptable Use Policy


The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.