View Full Version : oracle answers

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

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