- 浏览: 25721 次
- 性别:
- 来自: 北京
最新评论
1.SQLPLUS : a tool that execute sql ,sqlplus ,sqlplus command.
1.sqlplus command-line cmd-sqlplus /nolog
2.sqlplus GUI sqlplusw /nolog
3.sqlplus web http://127.0.0.1:5560/isqlplus/
isqlplusctl start
how to start sqlplus dba login
[oracle@Toshiba ~]$ JAVA_HOME=$ORACLE_HOME/jdk
[oracle@Toshiba ~]$ export JAVA_HOME
[oracle@Toshiba ~]$ cd $ORACLE_HOME/oc4j/j2ee/isqlplus/application-deployments/isqlplus
[oracle@Toshiba isqlplus]$ $ORACLE_HOME/jdk/bin/java -Djava.security.properties=$ORACLE_HOME/sqlplus/admin/iplus/provider -jar $ORACLE_HOME/oc4j/j2ee/home/jazn.jar -shell
RealmLoginModule username: admin
RealmLoginModule password:******** welcome
JAZN:> adduser "iSQL*Plus DBA" oracle oracle
JAZN:> grantrole webDba "iSQL*Plus DBA" oracle
JAZN:> listusers
iSQL*Plus DBA/admin
iSQL*Plus DBA/oracle
JAZN:> exit
2.sqlplus -h -v -s
3.sqlplus /log ;login sqlplus
4.sqlplus / as sysdba (oracle 10g) sqlplus "/ as sysdba" (oracle 9i)
sqlplus /
sqlplus hr
5.run / start @
start mysql.sql p1 p2
@mysql p1 p2
6.accep
7.list :display the contents of SQL buffer ,the last line is the current line.
l2: the current line is number 2line.
c: changeor replace the current line character. c /t/emp
a: appent the text to the end of the current line. a where id='1'
i: insert a line after the current line.
0 /*hhhhhhhhhhhhhhhhhh*/ inser a line before the first line.
del: del n m
del * last
del *
del * n
del 2
list *
list n m
list m
remark: add comments rem this is comments
/* this is comment */
--thjisssdsds
8.save/get filename
9.SQL buffer:store recent sql and pl/sql command.
10.?=$ORACLE_HOME
11.$ORACLE_HOME/sqlplus/admin/help/hlpbld.sql helpus.sql create sqlplus help command
$ORACLE_HOME/sqlplus/admin/help/helpdrop.sql
12.help save: get help infor about sqlplus command
help index : display all sqlplus command
13.quit,exit,ctrl+d,ctrl+z
14.desc :display defination about table,procedure,function
15.; / run sql command
16. . :terminate pl/sql / : run pl/sql
17.show display the content about sqlplus command
18.set serveroutput on/off
19.col id format $99.999 -
heading "your ID"
20.ctrl+c: stop a command while it is running
21.! or $or host:use os command in the sqlplus
22. set linesize
set pagesize
23.set pause on/off :pause display
set pau '////////////'
25.set autocommit on :save change to database automatic
26.@ or @@ or start : run script
27.define _editor=vi in sqlplus ,edit script
ed lab1
28.set echo on/off
set verify on/off suppress the display of each line before and after substitution:
29.run script as you start sqlplus
1.sqlplus hr/hr @con.sql
2.vi con.sql
hr/hr
select * from dept;
sqlplus @con.sql
30.spool query.sql
select * from dept
select 'drop table ' || object_name || ';' from user_objects where object_type='TABLE'
spool off
31. substitution variables
define d_loc=CHICAGO
define d_dname=&dname
define d_deptno=&1
select * from dept where loc=&d_loc and dname=&d_name and deptno=&d_deptno;
select * from emp where deptno=&d_deptno
32. Using Bind Variables
var val number
begin
:val :=1;
end;
print val
var emp_infor refcursor
begin
open :emp_infor for select * from emp;
end;
create or replace package myemppkg as
type empinforcur is ref cursor;
procedure pmyempkg(res in out empinforcur);
end;
create or replace package body myemppkg as
procedure pmyempkg(res in out empinforcur) as
begin
open res for select * from emp;
end;
end;
var emps refcursor;
exec myemppkg.pmyempkg(emps);
create or replace function femp
return restype is reset restype;
begin
open reset for select * from emp;
return(reset);
end;
33.column
column empno heading '--empno--'
column empno format a30
column empno format $999,999,999
发表评论
-
from string get number data using pl/sql or sql
2012-02-16 17:32 845declare @aa varchar(80),--- ... -
SQL
2012-02-15 18:01 6731.select sal salary from emp; ... -
modify ip
2012-02-10 17:45 7411.netconfig 2./etc/sysconfig/n ... -
MULTI dbwr or io slaves
2012-02-10 15:21 840thanks dukope of itpub. ... -
FAQS
2012-02-09 15:59 7021.How can I get the largest amo ... -
HOW TO STUDY ORACLE FROM Yong Huang
2012-01-18 14:48 758Assuming you want to study orac ... -
RMAN
2012-01-14 17:07 6491.components of the rman ... -
INSTANCE and CRASH RECOVERY
2012-01-12 10:12 7041.type of checkpoint full c ... -
STARTUP PFILE=
2011-12-31 14:11 11121.vi initdbs.ora spfile=&quo ... -
MANAGE TABLE
2011-12-26 16:50 5301.heap table IOT PARTI ... -
MONITOR redo size
2011-12-21 17:48 6101.set autot on stat 2.unsin ... -
What do rollback and commit
2011-12-21 11:21 699When we COMMIT, all that is lef ... -
What is the schema ?
2011-12-20 15:18 554A schema is a collection of dat ... -
MANAGE UNDOTABS
2011-12-19 17:15 6501.manual undo_management=ma ... -
DBA SQL
2011-12-19 15:21 4071.select a.name,b.status from v ... -
SEGMENT EXTENTS ORACLEBLOCK
2011-12-15 16:11 7531.SEGMENT: allocated fo ... -
MANAGE TABLESPACE AND DATAFILES
2011-12-13 15:28 5331. tablespace,segment,extent,bl ... -
ORACLE NET
2011-12-12 09:49 6501.net_service_name: servive ... -
ORACLE ENVIRONMENT VARIABLES
2011-12-09 17:15 623ORACLE_HOME ORACLE_SID : or ... -
Exam Test1
2011-12-09 16:18 6071.utl_file_dir: indicate the di ...
相关推荐
Oracle SQLPLUS基础及sqlplus命令详解,详细阐述了oracle sqlplus基本命令和相关用法
Sqlplus常用的命令,数据库管理员的学习笔记。
sqlplus 常用命令行参数,Oracle 中 sqlplus 初学者用的 常用命令行参数
SQLPLUS命令使用大全SQLPLUS命令使用大全SQLPLUS命令使用大全SQLPLUS命令使用大全
SQLPlus命令,SQLPlus命令SQLPlus命令SQLPlus命令SQLPlus命令SQLPlus命令SQLPlus命令SQLPlus命令SQLPlus命令SQLPlus命令
ORACLE SQLPLUS 命令大全ORACLE SQLPLUS 命令大全ORACLE SQLPLUS 命令大全ORACLE SQLPLUS 命令大全ORACLE SQLPLUS 命令大全
详细介绍ORACLE sqlplus命令,详细介绍ORACLE sqlplus命令
sqlplus11.2 rpm安装包
实现sqlplus上下翻页
sqlplus常用命令.txt
oracle sqlplus 工具的使用
sqlplus常用命令大全,可供参考!!
Sqlplus_登录数据库
sqlplus命令(DOC),很全的sqlplus命令。
sqlplus developer中文版,金融开发必备软件。
oracle数据库sqlplus语句大全
Oracle_SQLPLUS常用命令.doc Oracle_SQLPLUS常用命令.doc
SQLPLUS安装(安装说明)
介绍了在sqlplus的常见语法,set linesize,set pagesize等,设置数据库时间格式,设置字符集