|
|
Browse by Tags
- 10
- 10g
- 216
- 7.3.0.0
- 7.6.0.11
- 9.0.1.8
- another
- application
- area
- backspace
- body
- bounds
- browser
- change
- check
- client
- clob
- close
- commands
- comment
- commit
- connect
- connection
- connections
- conversion
- could
- count
- create
- currently
- cursor
- data
- database
- day
- db2
- dbartisan
- dbms_output
- dbvisualizer
- debug
- declare
- declared
- developer
- diagram
- discoverer
- displays
- does
- end
- engineer
- er
- erd
- error
- escape
- execute
- explain
- export
- express
- failure
- first_rows
- font
- from
- front
- function
- grant
- grid
- gui
- host
- how
- identifier
- import
- index
- insert
- instant
- integer
- Internet Explorer 7.0
- isnumeric
- job
- multiple
- oracle
- Oracle 10g
- output
- package
- plan
- procedure
- query
- Quest
- Quest Software
- resolve
- run
- schema
- sourcesafe
- spool
- sql
- SQL for Oracle
- stored
- sybase
- table
- tns
- trigger
- using
- view
- window
-
Import/Export using Toad from ORACLE
Q1: first thing i am not sure what is the difference between the "*.sql" file and the "*.dmp" file Q2: Second what is the difference between Export Table data vs Export Table Script vs Export TABLE AS FLAT FILE Q3. Third diff btwn IMPORT SOURCE FILE vs IMPORT TABLE DATA Q4. I want... -
Execute a simple store procedure in TOAD ORACLE
Hi, I am new to TOAD Oracle. I wrote a simple sp and don't know exactly how to execute, although I have tried right click on my sp name in Object window, and set up an input value. Basically, I want to pass one parameter(MY_F1) to retrieve several fields (F2 for now, I have many fields in output... -
Executing a Stored Proc in Toad
How do I execute a stored proc in Toad similar to the way it executes in SQL Server Query Analyzer where I would just say Exec procMyTest '01','CID' I have a package and a proc and I want to execute the same above hardcoding the parameters to return a result -
How to install toad for oracle?
Hi i have oracle 10g in my system, and i want to install toad editor for this oracle 10g, i am having toad commercial version. but i don't know how to install this, because it shows different check boxes, but i don't know that much details. so will u please u provide the required procedure for... -
oracle discoverer: failed to connect to database-ora-12154:TNS could not resolve service name
I have just installed discoverer 4.1 and get the error.. Unable to connect to: Bob@HUMANRES failed to connect to database-ora-12154:TNS could not resolve service name Running Oracle 10g and use Toad 8.6,I can connect to the database using Toad no problems. Tried http://www.virginia.edu/integratedsystem... -
How to reconnect to a previous session in Oracle?
Hi, after I used sqlplus to execute an update on an table, my network was disconnected before I commit. After that, I can't delete from the table now (I need to delete all data). I'm a developer so I don't have the right to terminate the process, so I'm thinking is there any way that... -
ORA-01019: unable to allocate memory in the user
I'm running win2000 w/ oracle 8i client. server is running 8i. Toad logs in fine, sql plus works fine... but DBArtisan refuses to login to any db in my tns file. Any suggestions pls? TIA Steve -
Debug Triggers? TOAD?
Is there any easy way to debug a trigger? I am using TOAD professional or SQL PLUS... The Toad professional let you debug procedured/functions very nicely with breakpoints, stepping, ect.. Is there anyway to do this with a trigger?? -
Instant client
Anybody get instant client to run with TOAD? I'm getting can't find oci.dll. I've got the tns_admin and path set to proper directories. -
Errors in Toad
Hi I have one problem. Pls answer this. I'm using Toad 9.0. when i disconnect the session and close the Toad window ,i get two errors like 1)The Instruction at "0xod50385a" referenced memory at "0x04330064".The memory couldn't read. 2)when i click the ok button on the first...