|
|
Browse by Tags
- 10.2.0.4
- 10g
- 9i
- all
- all_tables
- bat
- batch
- between
- bind
- C#
- call
- calling
- Calling sqlplus from batch file
- characters
- code
- column
- columns
- command
- connect
- connected
- connecting
- connection
- convert
- crash
- csv
- database
- dates
- declare
- denied
- does
- dos
- echo
- emrep
- environment
- errbuf
- error
- euro
- examples
- execute
- execute commands in sqlplus using perl
- exit
- export
- extension
- fedora
- file
- firewall
- first
- format
- formatting
- from
- function
- hide
- host
- how
- How to declare bind variables so that they persist across sqlplus sessions?
- IE
- index
- jdeveloper
- join
- key
- kill
- line
- login
- multiple
- oracle
- output
- parameter
- parameters
- perl
- permission
- procedure
- prompt
- query
- running
- script
- shell
- show
- space
- special
- spool
- Spool problem in sqlplus
- sql
- SQL PLUS
- sql server 2005
- SQL*PLUS
- statement
- stop
- stored
- string
- su
- substr
- subtract
- svrmgrl
- sybase
- symbol
- tnsping
- unix
- variable
- view
- works
-
How to declare bind variables so that they persist across sqlplus sessions?
I'm trying to use bind variables in some stored procedures I'm writing in Oracle 10g (sqlplus version 9.2.0.1.0). For example: sqlplus>variable v NUMBER; sqlplus>begin 2 :v=10; 3 end; 4 / print v; /* result is correct: 10 */ However, when I end my sqlplus session and restart it, the variable... -
execute commands in sqlplus using perl
I would like to a write a simple perl script to login to Oracle sqlplus, execute certain commands and exit. I am new to Perl .. Can any one suggest easier way to do that.. $login = 'sqlplus user/password'; system($login); logs me in to sqlplus But i dont know how to execute commands in sqlplus... -
Spool problem in sqlplus
Hello wizards! I am experimenting with sqlplus and am trying to create a csv based on a query. I have three problems though: First of all, the query is always contained in the csv although I set the header option to off. Secondly, the column separator option is not working at all and I don't want... -
Calling sqlplus from batch file
Hi, I need a very quick help.. Iam having a DOS batch file from which I am connecting to oracle to execute a sql script. I connect using sqlplus. Now I want to limit the number of attempts the user can make. By default oracle will allow 3 attempts. I dont want that. I want to quit sqlplus in one invalid... -
sqlplus show all tables command
I want to make sure i created a table in the oracle 8i DB I need the simple command to show me all the tables in the DB. I use the system/manager to create the table and it should be there I think. My DB is on solaris but I think it should be the same in NT I tried echo "select * from all_tables"... -
how to run a sql command using a bat file?
To load data into my oracle db, I use a bat file named load.bat including: C:\oracle\ora90\BIN\sqlldr xxx/xxx@xxx,control=anotherfile.ctl,log=c:\logfile.log ... in which xxx are username,password and database name and anotherfile.ctl is to contain commands to load data to the database so what do I do... -
Select Values and Count From Multiple Tables
Hello, I need to retrieve some database status information. This is more of a SQL question than a database (Oracle) question. This works returning standard values of an Oracle database: SELECT d.dbid,i.instance_name,i.host_name,d.open_mode,d.database_role,i.status,i.database_status, to_char(i.startup_time... -
Oracle 10.2 database not responding
Hi, I have a 10.2 oracle database. The startup of this database works fine. Starting the listener works fine too (no errors). When i run a Sqlplus session in local way (setting the ORACLE_SID env var before launching sqlplus) it works fine too. But when i try "sqlplus system/password@SID" the... -
URGENT: Login to instance knowing only the ORACLE account information
I just inherited an Oracle RAC instance. I've only have the RHEL oracle credentials. Is there any way to recover the sys / system passwords? Also, knowing only the oracle credentials, do I have any way to connect to the instance via SQLPlus? This is on 11gR2 -
show database, show all_tables ?
hi guys, please view my screenshot : http://img143.imageshack.us/img143/2308/sqldatamh8.jpg this is capture from sql 2000, we can see the databases, tables easily in one view. But what if I am using oracle 8i and oracle 10g ? how do I view it in sqlplus ? what is the command? when i do a show database...