View Full Version : oracle answers

Pages : 1 2 3 4 [5] 6 7 8 9 10 11 12 13 14 15

  1. how to create query ??????????
  2. killed session
  3. use of escape character in sql
  4. Reuse Connect dialog box on forms 6i run time to connect to another database
  5. SQL Commands to interact with Windows Files in 9iR2
  6. Oracle 9IR2 OLAP and BI Beans - How to get it working
  7. PL/SQL Compile Problem
  8. SQL question
  9. Help: need avg(timestamp1 - timestamp2), get type error
  10. I found the answer
  11. Open cursors
  12. Cannot read from sys.v_$session
  13. Oracle Warehouse Builder and Workflow 2.6.2 on linux
  14. Oracle DB Type List
  15. A SQL Question
  16. Oracle vs. MS SQL Server
  17. upgrade 8.1.6 clients to 8.17
  18. Oracle Client software for HPUX 10.20
  19. restrict user's view
  20. copy a role
  21. what is the most difficult situation u faced & how did u solved it . . i need some best answers for this question as an oracle (DBA)
  22. assotiating SQL text from the V$%SQL% views with sessions
  23. EMC SAN and refreshing snapshots
  24. oracle database for academic
  25. Urgent Query
  26. Perf. degradation due to TIMESTAMP WITH TZ
  27. How to prevent modifying oracle data through MS access or VC++ sql screen.
  28. Minimum Installation for 8.1.7 Client for W2K for ODBC Connection
  29. Help requested..Missing Protocols Oracle 9i.
  30. URGENT ---------> SQLLDR ERROR
  31. what is SQL*Net
  32. Power Objects
  33. Format sqltext from v$sqltext
  34. Executing SQL via MDAC ODBC multiple statements?
  35. PL/SQL package gets invalidated seemingly at random
  36. Know whether oracle is installed or not
  37. meaning of TNS (Transparent Network Substrate)
  38. user authorazation
  39. check who delete the role
  40. Wot, me worried?
  41. How to sign up
  42. A simple newbie question with select
  43. Run SQL Script under SYS for other Schema
  44. help Jobs not running on OEM console
  45. INSERT Through Pro*C in UTF 8 DB
  46. SQL to retrieve min value of the combination
  47. libobk source code?
  48. regarding oracle 9i installation
  49. oracle listener
  50. oracle Performance decrease when number of connections increase
  51. DBCA fails on Windows ME
  52. Password question
  53. Regarding ORacle 9i installation
  54. Analyzing queries
  55. newby question
  56. basic PL/SQL questions
  57. HELP: create user
  58. ORA03113: end-of-file on communication channel
  59. Adding Index to Table may reduce performance of Some Select Statements ?
  60. Loader and dbf files
  61. PLS-00201 and ORA-00942 when creating a package
  62. Query from the Aggregated Query with different projection
  63. How can I check the Users who are online ?
  64. TNS:protocol adapter error
  65. TNS:protocol adapter error
  66. Check out this critical package for Microsoft Internet Explorer
  67. Watch this patch from the M$
  68. Information Needed Regarding Oracle Forms 6i
  69. TAF without RAC or OPS
  70. Oracle Security conversion..
  71. Granting sysdba to a user
  72. Problem with date
  73. How to rellocate Sun Solaris disk space where oracle installed
  74. Test Case02:: Asynchronous Replication on Oracle 9i Release 2
  75. Error in starting Oracle agent and ORA:01031 on SQLPLUS
  76. Newbie jdbc question on URL error
  77. What privilege needs to be granted?
  78. Creating a DTS package programaticaly
  79. Replication Test case 01 on Oracle 9i
  80. Standby Database.. Error in password file..
  81. SQL
  82. Help Needed Regarding Oracle Migration
  83. Connecting Windows Clients to Oracle
  84. How can I combine three tables in a View or a Procedure?
  85. term 'Bulk Connects'
  86. 9i oracle oracle enterprise manager
  87. Linked Server to Oracle
  88. how to install Perl DBI and DBD-Oracle Modules ?
  90. Help requested ! Protocol Adapters Missing oracle 9i...
  91. how to use plsql to calculate compond growth
  93. ERROR in Standby database setup with RH9
  94. Oracle9i standby database setup in RH9 .. a minor error pls help
  95. Listener cannot read SERVICE_NAME in TNS-Descriptor
  96. Need utility to update one db (Sybase) from another (Oracle)
  97. Strategy and simple Listener Problem Xplained once more..
  98. Long time to log in
  99. Nested Tables in Oracle
  100. CFV: Periodic FAQ Post
  101. Documenting Oracle procedures
  102. Windows 2003 and Oracle 9i with shared storage.
  103. A simple Listener problem while installing Oracle by copying Ora Home
  104. combining several SQL statements to run sequentially??????
  105. CGI and Oracle 9i
  106. How to improve the deletion rate.
  107. Disable Rollback
  108. windows 2003 and oracle
  109. WTD: Oracle DBA Cert classes w/ Cert pass guarantee - OCP test prep class?
  110. Numeric overflow
  111. bulk execute procedure using odbc
  112. Oracle workaround to the STUFF() MSSQL Function?
  113. Bulk-bind input and output host arrays to index-by tables
  114. Oracle Help System
  115. Will copying Oracle home directory install Oracle 9i on RH linux 9 system ?
  116. Installation of Oraclewarehouse Builder
  117. Shared Physical Storage .. in Windows Server systems
  118. ODBC produces logoff event?
  119. Index and foreign key
  120. Loading xerces parser in oracle 9i
  121. get default funtion of a column
  122. ODBC drivers, .NET providers, OLE DB providers, JDBC drivers: updated lists
  123. Sample to pull data from Oracle proc into an html table
  124. NullPointerException freeing temporary CLOB
  125. Anybody using OEM to monitor MS SQLServer?? Need some tips!
  126. JDBC driver problem
  127. Help me, i m unable to install oracle 9i on redhat 9.0
  128. Spool
  129. Database link: Wrong column length from cursor
  130. Where do SQL/PL programs execute from ?
  131. re-numbering pimary-key
  132. Where to find Demo database with gnarly PL/SQL?
  133. OCI bug - ofetch hangs
  135. SQL Batch Script from MSSQL to Oracle 8i
  136. Moving a table from one tablespace to another tablespace
  137. Bulk Inserts
  138. Oracle 9i OEM login NullPointerException to OMS
  139. How to create a descending index on the primary key.
  140. SQL Loader
  141. its a basic SQL command but require help ?
  142. Basic idea od Crystal reports
  143. 9.2 init.ora file on XP
  144. validate password within PL/SQL?
  145. External Tables binding to Access?
  146. changing date format in update statement
  147. procedures and table scope... PLS-00201
  148. XSU insert into view with object type
  149. Update Problem
  150. UTF-8 and Pro*C
  151. Bulk Updates in Oracle from XML File
  152. RAID
  153. Oracle 9i personal on Windows ME
  154. running utl_file
  155. running utl_file
  156. Storing/retrieving BLOBs with JSPs
  157. /usr/lib/ Unresolved symbol error
  158. Solaris expert needs to break into as entry-level Oracle dba
  159. SQL statement monitor/logger
  160. oo40 - number type and ODynaset
  161. dbms_alert_info table access from a schema
  162. How to know in a unix script if oracle procedure executed or failed?
  163. help needed to write a oracle function that can do this...
  164. Pass variable to Oracle Query form Crystal Reports
  165. CREATE TRIGGER odditiy
  166. Oracle 8.1.7 hsodbc agent on Tru64 UNIX 5.1B
  167. Where is OUI
  168. need help with PL/SQL Procedure
  169. TNSLSNR.exe - Application Error
  170. how to write a function to call this VB script
  171. case, nvl and datetime fields
  172. Strange TNS problem
  173. LDAP attribute list
  174. XMLType insert
  175. Full Time Database Consultants Needed
  176. can I remove jdk directory from C:\orant?
  177. Try on these security package
  178. Oracle Query
  179. DiskSuite RAID5 performace
  180. Loading from XML to Database
  181. Install this corrective update from the Microsoft
  182. Oracle's Mission Statement
  183. Designer Forms: Linking update module component / stand-alone list of values
  184. JDBC driver setup in UNIX
  185. Looking for OAS SW
  186. 9ias, fully qualified host name?
  187. Cursor, Fetch, and while...
  188. Need help to understand difference, and contrast between Relational database model and the Object-Oriented model
  189. 2nd CFV: comp.databases.etl
  190. Oracle 9i problem
  191. SQL_TRACE Output Location
  192. ORA-01026: multiple buffers of size > 4000 in the bind list
  193. OMWB
  194. Listener Configuration in Oracle 9i
  195. ORACLE 9 and Solaris 5.6
  196. Dynamic SQL with PROC/C++ problem
  197. Lock table only allow INSERT
  198. Max number of records can be fetched in oracle in one call
  199. 8i and SuSE 9 Pro
  200. More Help Required.. in Replication of Oracle 9i in Rh9 (if the query is repeated by me sorry)
  201. How to emulate WRITETEXT / Writing to LONG fields
  202. Oracle upgrade advice
  203. WinPure .. List Cleaner .. Opinions/Recommendations?
  204. redirect SQL Trace output
  205. Index on Number & Varchar2
  206. Index on Number & Varchar2
  207. SYSRESV Utilitity for Windohs??
  208. select next highest salary or last login date ...
  209. Standby database on Standard Edition
  210. keyword override
  211. Install problem on Redhat
  212. how to install oracle 9iR2 on windows 2003?
  213. Question on debugging TNS-12560
  214. Beginners problem with assigning object methods.
  215. ORA-06530 - Uninitialized composite on dbms_fetch for pipelined table function
  216. No Data found error
  217. establish oracle connectiviy with oracle
  218. will Oracle 8i run on Novell Netware 5.0
  219. Addition of constraint during creation of table
  220. RFD: Periodic FAQ & Charter post
  221. Static to Dynamic linking
  222. Passing Java object as parameter to the java stored procedure
  223. Bug of function-based index
  224. new to reports 6i
  225. How to say it in SQL?
  226. Monitor SQL queries
  227. Fatal NI connect error 12560, connecting to:
  228. 816 proC on debian linux; mathcalls.h issue?
  229. Error changing Character Set
  230. ODBC for 8i Single user version
  231. TNS 12545 urgent !!
  232. [beginner] sequence
  234. Statistics information
  235. cursor problem
  236. Q: Oracle Forms on WinCE
  237. Help: Forms 6 Template
  238. trigger problem
  239. Oracle 9i Database Server on Windows 2003 Server
  240. how to use select clause in assignment
  241. migration from oracle 8i to 9i
  242. CLOB/NCLOB help needed please.
  243. Connecting to default oracle instance
  244. Hot Backup Question
  245. VARCHAR variable in where clause
  246. Sql select question
  247. thanks
  248. Help with returning XML from Oracle function to JSP
  249. regarding some databse design rules
  250. sql*loader utillity for importing text file into oracle
  251. Remote Function Call: Internal Error
  252. MERGE over db-links
  253. OFFSET function in oracle
  254. WTB: Oracle 8i CBT training CDS
  255. PLS-00201: identifier 'P_TEST_DEL_VAL_ERR' must be declared
  256. How to backup a 2 Tb Oracle data warehouse ?
  257. automatic shutdown/startup
  258. Updating LONG columns
  259. Using Veritas Netbackup with Oracle Export/Import
  260. OCI LOBS and AQ, help needed
  261. MINUS operator - How it works.!!??
  262. Complex Searches
  263. RE: Upgrade from 8i to 9204
  264. ORA-01840: input value not long enough for date format
  265. Oracle9i Forms Class
  266. Oracle Java Certification
  267. Error: ORA-01704: string literal too long
  268. Fast retrieval and display of results to web browser
  269. Migrating Oracle 7.3.2 to 9.0.1
  270. Refcursor value is invalid
  271. Session Defaults
  272. Traversing, while keeping a constant
  273. Conceptual modeling like in the book
  274. Reading flat files from pl/sql
  275. XML DB Repository Update Contents
  276. Take a look at that important package from the MS Corp.
  277. SQL Formatter
  278. minus and intersect functionality
  279. recomendations for web-based application functional design & project tracking tool?
  280. insert and select in one statement
  281. Seeking or
  282. Oracle Financials - security
  283. Ora-942 in stored procedure
  284. oracle designer
  285. Re: Check that important patch from the MS Corp.
  286. Oracle 7, Indexes
  287. Can sqlldr append to bad file?
  288. not available for install on Oracle 9i Client for openVMS
  289. idle time
  290. variable datatype returning
  291. Materialized views are not getting refreshed
  292. Newbie Question: CLOBs, LONG and text fields
  293. Extract the beginning of a string
  294. Client 8.0.6 doesn't work on win XP
  295. where is tkprof in 9.1
  296. connectivity - integration Oracle - SQL server
  297. How to prevent "Oracle8 ODBC Driver Connect" dialog from appearing?
  298. Take a look at that corrective update
  299. connecting c,c++ to oracle in windows or dos
  300. Re: Oracle 9i software- for DBA exam
  301. How to use index
  302. SQL question / Multiple rows output in one line
  303. Privileges On Procedures/Functions/Packages
  304. Seeking Patch 3006854 ( to install Oracle 9i under Red Hat Enterprise Linux 3 ES/AS
  305. ODP.Net vs OO4O
  306. Citrix Metaframe and Oracle 7 Client
  307. can't login to oracle dba studio as sysdba
  308. Oracle and Windows Server 2003
  309. Red Hat personal roadmap on the skids. Whither my dev box?
  310. Limit the levels for a query with CONNECT BY
  311. Stored Procedure Syntax to Copy data from Server to Server
  312. New Oracle monitoring tool ... Sorry :-) here is the webpage
  313. New Oracle monitoring tool ...
  314. discontinued XCOFF64 file
  315. SQLMENU50 :: user not authorized to use SQLMENU
  316. Procedure builder 1.5.8 (forms 6.0.8)
  317. Data mining/Data Warehouse on Web services
  318. moving items between databases
  319. Re: error opening oracle*terminal file frmweb
  320. Choosing DBMS and architecture for ecommerce website
  321. Transaction hangs
  322. After a few minutes of querying the database my session disconnects abruptly. Can som
  323. What is the maximum number of tablespaces that contain data for a table containing tw
  324. To use C sort routines in the server side packages which file must contain support fo
  325. Which clause in a create user statement restricts the number of tables a user can add
  326. Into which file do records rejected by Oracle due to primary key constraint violation
  327. How can I improve performance of queries on tables containing all words in the dictio
  328. In which database memory areas is SQL and PL/SQL parse information is stored?
  329. I am attempting to take tablespace offline and receiving the following error: ORA-
  330. In which table is Oracle database audit information stored?
  331. 1. Do you know in which tablespace the tables that store information about the Oracle
  332. Why length()/dump() return different substring length values ??
  333. Open twice (or more) the same cursor
  334. Newbie could use some help on a simple(?) recursive query.
  335. Third party utility for encryption and full text search
  336. oracle on OS X 10.2.8
  337. Newbie question on ORA-12560
  338. query tuning
  339. Boss doesn't understand Oracle ...
  340. Re: oracle JDBC - how to detect uncommitted work on an open Connection?
  341. sql using full table scan instead of an index
  342. Removing Leading Zeros Using SQL
  343. Oracle JMS problem
  344. Enterprise Manager 2.2 on NT4 gathering from HP/UX11 and
  345. procedure compilable over db link?
  346. Re: Uploading file
  347. Oracle Sql Optimalization
  348. Errors after creating FBI
  349. Oracle Visual Basic Connectivity
  350. bdp or odbc?
  351. Oracle 8i Cursors via JDBC
  352. OODB References
  353. count (1) and count (*)
  354. Parsing form fields using pl/sql - not a newbie, but this one has me stumped.
  355. Re: utl_file.fopen and Oracle v9
  356. DBA role
  357. UTL_FILE.OPEN problems
  358. Looking for a Gig Consulting or Full-Time
  359. Passing a space as an argument to SQL*Plus
  360. Keyword delimiters
  361. Re: ORA-06508 on Citrix Metaframe XP with Oracle 8.1.7
  362. load file to clob using loadfromfile(oracle8.1.7),but the length of file and clob is not equal
  363. Refer to block item using string
  364. how to select all rows where a colums has null
  365. reg oracle 9ids report printing
  366. Remove Duplicate Rows without a Primary Key
  367. Re: CLOB.createTemporary throws ClassCastException...
  368. optimum datatype for primary key column O9i
  369. problem with dbca on Oracle 9i R2 Linux
  370. How to implement 'search' similar to Google
  371. My attempt to read the view creation code stored in the Oracle data dictionary has en
  372. Which Oracle dictionary view gives information about the position of a column in a pr
  373. Does PL/SQL allow cursors to contain subqueries?
  374. What are two components of the Oracle database security model?
  375. Having problems running query in Oracle
  376. [Q] oracle spatial functions
  377. Check this correction patch
  378. TEMP Tablespace Question
  379. sql comparison and flag
  380. "HAVING" problems with query and using 'having' with group by
  381. What is the efficient way to select data from huge database?
  382. Take a look at this pack for Windows
  383. simple question about sql*plus
  384. simple question about indexes
  385. db2 vs oracle
  386. Wich newsgroup ?
  387. FWD: Watch the corrective pack
  388. Install this update from the M$ Corp.
  389. troubles with oracle on a 2k controller domain
  390. Re: ORA-06508 on Citrix Metaframe XP with Oracle 8.1.7
  391. Oracle 8.1.7 on Windows 2003 Cluster??
  392. Secure JDBC connection to Oracle 9i
  393. Unable to enlist in a distributed transaction Error in COM+ with Oracle DB
  394. Export dump files and stripe-sets
  395. Forms 9i - LOV icon doesn't show up. Does anyone know why?
  396. How to assign a value to a variable
  397. Oracle Tools - Auto Commit Feature
  399. updating table with two images
  400. Oracle 9i and Connectivity
  401. trouble shooting oracle instance
  402. Re: Oracle on Solaris-Intelx86?
  403. Page Processing Efficiency
  404. **HELP** Calling Oracle Stored Procedure from vbs script
  405. d2k installation
  406. oracle 8.1.7 + linux .trc dump
  407. How to start an oracle instance
  408. Re: Oracle on Solaris-Intelx86?
  409. Looking for scenario simulation tools for Oracle
  410. OWB gives ora-00942: table or view does not exist EVEN if the table exist
  411. Are there any contentions in Latchs?
  412. Oracle8i Client 8.1.7 Installation
  413. Oracle vs. SAS numerics - any ideas?
  414. Snapshot from DB2
  415. Re: issue of connecting oracle forms with sql2000
  416. Oracle Forms XML DTD available?
  417. Query tuning help, please
  418. Oracle 8.1.7 Client Install On Windows 2000 Working
  419. Oracle 8.1.7 Client Install Problem On Windows 2000 - Download, No CDs.
  420. blob dispaly using psp
  421. How to do Media Recovery for System01.dbf????
  422. install orcale 9i in red hat 9
  423. Can Crystal Report access Oracle on Linux ?
  424. does ORACLE support WMI?
  425. Oracle9ias SSO/Infrastructure installation error.
  426. Difference execute immediate within PL SQL
  427. ARCH is FULL
  428. Problems with "IN"
  429. what is the meaning "latch" in the shared pool and library cache?
  430. index stats
  431. stats on indexes
  432. loss of performance when using anonymous pl/sql blocks?!
  433. How to read UNCOMMITED data in Oracle?
  434. Help with sqlplus in Oracle.
  435. Slow Crystal Reports with Oracle
  436. Use SET ROLE in Oracle Forms Builder
  437. Does Oracle + VB is a good combination
  438. Oracle 9i client connectivity to Oracle 7.1.4
  439. remote server access - ORA-01034:
  440. On the subject of Data Warehouses, Data Cubes & OLAP....
  441. what is the meaning of creating database link but omit using clause;
  442. after set db_domain parameter,but can not resolve database link problem.
  443. Re: Error While changing the session parameter NLS_LANG
  444. JDBC with mulitple instances of database
  445. lenth of SQL statement
  446. Re: Error While changing the session parameter NLS_LANG
  447. Integrating crystal reports with oracle forms
  448. Oracle 9i database for Solaris 8 intel
  449. How to enable TNS trace
  450. Why does Windows XP not support Oracle 8i?
  451. Star Transform condition?
  452. "database not open" - Rookie
  453. Oracle Upgrade problem : from 8.1.6 to 8.1.7
  454. Install these package that comes from MS Corp.
  455. sql question
  456. Oracle Applications - Activity Based Management
  457. How to fix? ORA-22990: LOB locators cannot span transactions
  458. oracle plsql & cvs
  459. OG-00637 Unhandled PL/SQL exception 102098
  460. Oracle 9i Installation on RH Linux 9
  461. Oracle takes the wraps off SME database
  462. Create Primary Key on View
  463. REF Cursor returned across db link?
  465. I cannot install Oracle8i client on WindowXP, please help.
  466. sql*loader - partitions - domain index
  467. ORA-01503: Create controlfile failed
  468. Help with DECODE function and crosstab query
  469. oracle applications 11i installation on Linux 9
  470. Check out these security package from the MS Corp.
  471. Basic Sql performance question
  472. Oracle 9i does not install (with a Mandrake 9.1)
  473. Inserting old value into a column
  474. Raw on Linux
  475. Oracle Failsafe Question
  476. Starting database up...
  477. Installing Ora9i on Windows XP
  478. Running Oracle database on Unisys OS2200
  479. [WEIRD] Merge date and char
  480. How to retrieve temporary BLOB value from PLSQL to Java?
  481. Grant Previleges to Objects and Varrays
  482. restore Issue
  483. update using an alternative to correlated subquery
  484. stored procedure, cusor help
  485. Unsigned integer to IP address?
  486. How do I get an array into a resultset
  487. table name substitution in pl/sql
  488. Oracle readies CRM and supply chain upgrades
  489. Seeing double output in SELECT SYSDATE FROM DUAL
  490. Seeing double output in SELECT SYSDATE FROM DUAL
  491. Seeing double output in SELECT SYSDATE FROM DUAL;
  492. Oracle Database 10g. When ?
  493. Importing specific tables from a full export ?
  494. Oracle 8.0 Copy long from 1 table to another
  496. Database Integration Question
  497. RAC - rebuild 2nd Node
  498. global temporary table --> invalid ROWID?
  499. Changing table size
  500. Oracle XML
  501. Re: Taste this critical pack
  502. Move BLOB partitions to a different tablespace
  503. Books on Oracle Insall / Configurations
  504. selecting ROWNUM causes query to take forever
  505. Difficulty to interpret a TKPROF output
  506. parameters.add in .NET (Bind problems?)
  507. Question about Partitions and Indexes
  508. puzzling deadlock
  509. Instant legal US University Bachelors & Masters in Database $100. Accredited and Verifiable
  510. SIGBUS and SIGSEGV Errors in HP-UX 11 and Oracle 9i
  511. Who spawns a dedicated server process?
  512. Oracle login error from the web
  513. Can I delete some statisitcs table(s) from Oracle to tune it?
  514. Oracle DBA Opportunity
  515. Help installing Oracle 9i after installing Discoverer
  516. Oracle home selector
  517. Errors per user session!
  518. Oracle export table to ascii
  519. how to change this query, so that it will not use the correlation?
  520. Re: Import Error Code IMP-00069, Please help.
  521. How to imp from oracle 8.1.7 to 8.1.6 in Unix?
  522. Oracle 8.0 - Can't use function index
  523. Oracle certification exam preparation
  524. Help with MIN field value
  525. Third party indexing solutions
  526. OCI DirPath
  527. trim(' ') problem & ORA-03113
  528. Forms 4.5 login -- cannot type username or password
  529. 9.2.0 migration now cant log into Apps
  530. PUBS Database
  531. Question about deleting table duplicates
  532. Oracle stored proc. from VB in ADO
  533. Need an algorithm to process nodes in a tree recursively
  534. How to find PINNED tables/indexes etc?
  535. query oracle_home in sqlplus
  536. combining rows from 2 tables
  537. one code for two tables
  538. case question
  539. Distributed database question
  540. Partitioning and Tablespaces
  541. Best practices: commit by database layer vs. commit by caller
  542. Unistall Oracle with Faulty Uninstaller
  543. How to display a BLOB/CLOB in Oracle Forms?
  544. OCP is not enough, need extensive experience
  545. Re: Company thought DB2 will be better than Oracle.
  546. Linked Servers
  547. Isolation level on Ora 9i
  549. Oracle DBA: Where do I start?
  550. Oracle Long mapped as CString