View Full Version : oracle answers


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

  1. Restore the database backup in Oracle9i
  2. how to update columns in oracle forms
  3. Improper result from query
  4. Loading Multiple CSV Files into Oracle DB
  5. FRM -41039: Invalid alert ID 0
  6. error 00214
  7. oracle error
  8. oracle 9i reports
  9. how to declare a global variable in report builder?
  10. Call Javacode from Pl/SQL
  11. case when gone wrong
  12. Workflow
  13. how to change search conditions dynamically in where clause using pl/sql
  14. SELECT WHERE SettingKey = N'Logon' FAILS
  15. insert into a table with selected columns.
  16. Oracle does not exist and shared memory realm does not exist error
  17. VBA Oracle DB Connection String
  18. can anyone pls help me to join tis 2 query statement
  19. How to add a sum up column to a table
  20. ORA-27101 problem
  21. Loading Excel File into Oracle Table
  22. How to drop and then create a table during runtime in oracle9i
  23. Nested Cursor
  24. Sequence.nextval incrementing itself over time
  25. Not able to open test.fmx in oracle application server 10gR2
  26. oracle report 6i
  27. Bulk Import of Data into an Oracle Database
  28. Loading XML data to Oracle Database
  29. Joining of 2 SQL queries
  30. how to compare two columns and return the value which is not matched
  31. Mutation of triggers
  32. Traversing a tree - using a little recursion in SQL
  33. how to get colunms displacement for a table in Oracle?
  34. i'm trying to load data from uploaded file in php by using sql loader
  35. error questions
  36. How to connect oracle 9i database & developer suite ?
  37. how to use a list item in oracle forums
  38. rowid
  39. how to enter only time in the field of table and sum the time
  40. Query
  41. Equivalent to SQL Server Integration Services
  42. Drop by to ask for help
  43. how to execute query without having to declare schema all the time
  44. File Dis51usr.ini Of Oracle Discoverer 10g
  45. i'm having trouble in defining primary key... HELP ME guySSSS
  46. Arbitrary order in SQL query
  47. load data
  48. oracle sql
  49. How i can use "IN CLUASE" with block fields.
  50. Add Field To parameter form
  51. Best practice for inserting many to many records
  52. dynamic :NEW
  53. How to recreate Foreign Key constraint
  54. Multiple Counts in 1 query
  55. RecordSet inside procedure
  56. What is a dblink ?
  57. orace 6.0 designer
  58. like %
  59. Connection pooling
  60. import .lst files
  61. I got a error when i am establish the connection between oracle and sql server
  62. SQL Select statement as a keyword search
  63. Iterative function in sql
  64. Table Output
  65. Oracle XML and XPath
  66. REFCURSORS over dblinks
  67. oracle error 10034
  68. Sql
  69. Oracle reports 6i and asp.net
  70. Report 10g Vs Discoveror
  71. Query Takes time to execute
  72. Generate DDL of Schema
  73. Easy question from MS SQL to ORACLE
  74. Integration of two databases into one Database
  75. Maximum size of Linesize
  76. grant access to remote user
  77. Recover deleted rows from a table from archive logs?
  78. Error in writing to directory /tmp/Orainstall .....
  79. Finding all tables with a particular field?
  80. Views and performance
  81. Installing on Mac Os
  82. How to diagnose inaproppriate Oracle SGA component size?
  83. server configuration
  84. RAC nodes regularly freezes for about 10 seconds
  85. How 2 split priority, reports low, transactions fast
  86. 7.3 on 03 server
  87. SELECT ... WHERE column LIKE parameter||'%'
  88. Re: Installing Oracle 11.5.8 on Mandrake
  89. history
  90. Oracle CBT
  91. Which database design tool
  92. Oracle Schema
  93. SQL 3 or 4 trial key needed
  94. UNIQUE CONSTRAINT ERROR
  95. Basic Questions
  96. Catching "ORU-10027: buffer overflow" exceptions in PL/SQL
  97. OLEDB and Oracle XE ?
  98. Patience for a Oracle Noobie
  99. Slow query on date field via views
  100. Crystal report db problem
  101. current sql running
  102. .NET Reporting against and Orcale Database
  103. <REQ> oracle lite info
  104. S: Biomega Mark Newson MN03
  105. Obtaining a Column Which has MAX in Another
  106. writing records while doing select.
  107. Multi Master Databases
  108. spool file: saing to non default location
  109. Request for Resume's - Siebel Production Engineer IV
  110. deducing ranges in SQL
  111. Oracle OLEDb
  112. What is it like to work with Oracle?
  113. Great Job Board
  114. A great onestop spot
  115. Generating CREATE TABLE statements
  116. Instantclient 10 on Solaris 10
  117. Suggest books for beginner, and good as a reference for later use
  118. Remove all tables for user with one SQl statement?
  119. validation testing -- use TPC-C? (or what?)
  120. US-VA: Sr.Oracle ATS/Testing LoadRunner QuickTest Pro # 1129R1
  121. Re: Does any one know where i can get oracle 8i
  122. Type for COUNT() as VAR ?
  123. Using FORALL with associative arrays
  124. Oracle Driver question
  125. INSTR and string length problem
  126. Oracle Application Server webcached leaking file handles
  127. Connecting mobile application to database
  128. Empty string behaviour...
  129. Upgrade from 10.1 to 10.2
  130. Sqlplus (set verify command)
  131. Oracle Rac
  132. SQL re-parsing on query executed against a remote database usingdatabase links
  133. Questions regarding materialized view logs ...
  134. Wanted:Oracle Portal Course Material
  135. Joins vs nested selects
  136. Virtual Indexes
  137. question about internal
  138. Inpersonate a user
  139. I cannot install emca anymore on oradb10g which runs o.k. after upgrade mac osX 10.4.2
  140. Question about init file
  141. Binding an array to an input variable in OCI
  142. Very basic question
  143. Help needed to connect DB2k on PC to v7.3 on VMS
  144. SELECTing multiple rows to a single output line
  145. Oracle 10G RAC stability problems
  146. oracle designer-timestamp-date
  147. PowerPoint Slides Available for Intro & Advanced DB Course
  148. ORACLE 10G R1 on SLES 9SP1
  149. JDeveloper and Oracle 7.3.4
  150. Captaris RightFax and Oracle 11i help needed
  151. partitioning advice?
  152. Oracle and DB2
  153. Row values changing back to old values randomly???
  154. Unload data
  155. install oracle client on Debian
  156. 8.1.7 on Redhat Enterprise 3
  157. Oracle Text: Indexing UTF8 or UTF16
  158. ORA-12170 Connect Timeout
  159. Erdish programing language
  160. does oracle support more than one CPU for SuSE Linux 9.1 or 9.2 or 9.3 Professional Linux
  161. Not a group by expression
  162. Speed up Select distinct
  163. Migrating Oracle from AIX to W2K3
  164. Multi-statements SQL and stored_procedure calls
  165. grant SYSDBA to user With remote_login_passwordfile=NONE?
  166. PL/SQL developer Oracle9i
  167. Convert between Charsets in a plsql stored procedure (ora10g)
  168. Connectivity for XP
  169. Re: How can I show the values from column 1 in "Select ??? from tabel" ?
  170. PL/SQL newbie question
  171. PL/SQL newbie question
  172. PL/SQL newbie question
  173. Mysterious 9.2.0.4 (on HP-UX) problem
  174. PL/SQL Object Question
  175. Help with JDBC
  176. PL/SQL newbie question
  177. ff
  178. why to migrate from infromix to oracle
  179. How to do UPDATE with GROUP BY
  180. "No size set for variable length data" Oracle update error with empty string in .NET
  181. tnsnames.ora
  182. with clause for subquery factoring
  183. UTL_FILE(HELP)
  184. DW + Oracle: see tbls w/ recordset but not insert
  185. Rules Engine
  186. Convert timestamp to date
  187. Oracle Reports JDBCPDS
  188. Changing db_block_size
  189. The Greatest News Ever!
  190. The Greatest News Ever!
  191. The Greatest News Ever!
  192. Great News Blog!
  193. (",) Do You Want To Know For Sure You Are Going To Heaven?
  194. (",) Do You Want To Know For Sure You Are Going To Heaven?
  195. Fast bulk load with API?
  196. Is it possible to delete parts of a table without using rollback??
  197. Help needed for Database Replication
  198. (",) Do You Want To Know For Sure You Are Going To Heaven?
  199. Why you don't usually get answers here ...
  200. Why you don't usually get answers here ...
  201. SQL - Select and filtering whereby a date is not null.
  202. Forms Builder speed
  203. Performance difference between Windows and Solaris 10g
  204. (",) Do You Want To Know For Sure You Are Going To Heaven?
  205. Sequence Error ORA-02287
  206. How to build database to support user-specified entities and attributes?
  207. Pivot query in oracle- Please help!!
  208. Pivot query in oracle- Please help!!
  209. Read Text file into Oracle Reports
  210. OCI library for Oracle 8.1.7.4.0 on OpenVMS
  211. Follow up to previous post
  212. SQL Query
  213. AVG and SUM in subquery return wrong values
  214. Invalid attribute/identifier error
  215. XML joining Nested resultsets
  216. How to build database to support user-specified attributes?
  217. port/protocol for sqlplus connectivity
  218. Problems: Oracle 9 Installation and Windows XP SP2
  219. Oracle 9 Installation Problems under Windows XP SP2
  220. install oracle 8.1.7 and developer 6i under same oracle home.
  221. Installing Oracle on Linux Redhat
  222. Converting a bare number to an interval and back
  223. ORA-29531 - And the method is declared both PUBLIC and STATIC
  224. External SQL functions exported by DLLs
  225. Oracle Discoverer Newbie...
  226. How to debug .pc file instead of debug generated .c file?
  227. Aarrrgh - this is NOT the place to ask!!
  228. Flashback over database link
  229. Pro*c for Windows
  230. how to do dbms_application_info.set_module from JDBC code
  231. Pro*c for Windows
  232. Open help file through forms 6
  233. Oracle Software Updates fees
  234. PL/SQL Examples
  235. Export of data
  236. Calling an Oracle stored procedure
  237. how can I connect to oracle in C language?
  238. How to pass an Integer Array to a Stored Procedure?
  239. Version control of Oracle Stored Objects.
  240. Oracle Text for searchengine across multiple columns/tables with different datastore
  241. UTL_SMTP Stripping MIME-Version header information
  242. UTL_SMTP Stripping MIME-Version header information
  243. UTL_SMTP Stripping MIME-Version header information
  244. Pro*COBOL and (possible) NULL host variabe in WHERE condition
  245. object_id vs data_object_id in user_objects
  246. DB2 User Group Italy - next meetings March 2005
  247. Oracle to SQL Server using JDBC
  248. format date with Oracle Dynamic SQL
  249. Oracl Lite 10g and ADO.NET problem :(
  250. Need latest patch for 6i Tools
  251. Printing Bitmap instead of Character
  252. Does Oracle JDBC driver support data compression
  253. What is the best (freeware) SQL GUI CLient?
  254. Pls help,oracle error
  255. How to put traditional Chinese text into Unicode Oracle 9i database via Internet Explorer
  256. iSQLPlusTimeOutInterval in 10g
  257. sqlplus 10g and OS X
  258. Alternatives to SQL *Plus
  259. Converting a type (e.g. Decimal) BEFORE writing to ResultSet ?
  260. Comparing DATE with TIMESTAMP fields possible ?
  261. serious problem in advanced replication
  262. Inner join with where
  263. Trigger insert on parent table question
  264. moving oracle DBs & 9ias from system A to system B
  265. OBE error
  266. Spotlight For Oracle
  267. Can you help me with JDBC getDate() error?
  268. Retrieving database record with the lowest value in field aaa?
  269. Converting NUMBER, DATE and VARCHAR2 database fields from Resultset to variables?
  270. Getting MetaData for JDBC tables with getTables() does not work?
  271. Detecting the INSERT format for DATE database fields?
  272. Training in Oracle Interconnect/BPEL
  273. DB2 Crushes Oracle RAC on TPC-C benchmark
  274. CLOB: Why are they so slow (compared with VARCHAR2)
  275. Instant Client 10g
  276. replication and primary key
  277. Looking for authoritative reference on PL/SQL grammar
  278. acceptable way to program
  279. Re: Working with U.S. Zip Codes
  280. Ocp Certificate Question
  281. Minimal Install Config?
  282. What (dev) tools does Oracle use (internally) to create applications of the E-Business suite 11i or older version?
  283. A possible breakthrough in analyzing 500GB+ data bases
  284. design of application / schema / multiple development schemas
  285. configuration management
  286. table API
  287. DLookup uses twice the SEQUENCE numbers
  288. Which oracle server ?
  289. ora-04021 - how to analyze
  290. Breaking News: MySQL beats Oracle in Benchmark
  291. Unhandled Exception on Oracle Form Builder
  292. website hosting
  293. Trip to Disney
  294. common UPDATE syntax for SqlServer and Oracle
  295. to oracle or to ms sql server 03
  296. Avoiding automatically starting Oracle
  297. MOLAP info
  298. Inserting a value for a BLOB field using an SQL script
  299. Debugging "Table Mutating" errors... 8.1.6
  300. I found this great little site
  301. Function called for row not in query result
  302. [q] Designers
  303. DBA Needed
  304. Cross: Molio bih preporuku...
  305. Oracle DST Setting in OpenVMS Version.
  306. Native Delphi driver
  307. Oracle Download Fails (Disk Full)
  308. HELP: ORA-12571: Packet writer failure
  309. Linked Server (Oracle 9i)
  310. barcode function
  311. Dynamically execute PL/SQL statement
  312. insert into returns 0 rows
  313. 9i DBA Fundamentals I CDROM
  314. Why would explicit system privileges work and inherited through a role fail?
  315. Unique constraint and NULL values
  316. Oracle Forms Developer error on Oracle9i Developer Suite
  317. membership operator with pattern matching
  318. selecting a column according to a minimum
  319. RMAN
  320. Comparison of DB2 and Oracle?
  321. how to sql query this?
  322. How to Fail at Software Development
  323. Uninstalling Oracle9i Personal Edition
  324. How to specify column header titles in a SQL CREATE TABLE statement?
  325. MSAccess and Oracle
  326. Oracle Frontend / Backend Protocol
  327. Server Data on Insert property
  328. Oracle 10g & EM
  329. Number of Quarters
  330. Good tutorial or book on Oracle db?
  331. How many pre-decimal positions/integer digits has a DECimal (5,3) defined field ?
  332. Distributed transactions and Oracle RAC load balancing problems - advice needed!
  333. ADO Addnew and identity columns
  334. cursor select/delete where current of not working
  335. Missing from one table
  336. Data not importing correctly
  337. Oracle programs - no source, only executable?
  338. Using the NEW_TIME function
  339. Newbie question
  340. Calling COM or DLL's from triggers ?
  341. Implementing complicated constraints
  342. Service Temporarily Unavailable (Help)
  343. Failing to connect to Oracle Server in ASP Session_OnEnd
  344. hi
  345. Selecting a column twice
  346. 10g timestamp
  347. GLOBAL TEMPORARY table - serious join performance problem
  348. Desperation Post JDev/Applets
  349. REF CURSOR returned from Java -- How to use?
  350. Oracle ODBC connection problem
  351. problems with export
  352. Retrieve the DBMS_OUTPUT buffer from ASP/ADO
  353. Question about commit
  354. Optimization advice
  355. Anybody used the Universal Table Browser?
  356. Can we delete files from cdump folder
  357. Oracle9i: very big problem with precition of SYSTIMESTAMP !
  358. Granting privileges on table owned by different owner
  359. Granting the privileges of existing objects within a schema to a new role
  360. Oracle 9i: Problems with SQL parameters
  361. dead.letter in my RMAN backuppiece
  362. accessing a view from another user
  363. Oracle Data Server
  364. Oracle 11i position/Ottawa/Canada
  365. test
  366. Caompaq fire wire usb 2.0 PCI cards and Redhat Linux / Oracle RAC10g
  367. Administration script to check DB
  368. Schema changes on on large tables
  369. Creating an EUL Gateway for Discoverer
  370. Creating a table in Oracle DB if it does not exist, using SQL
  371. user_tab_columns
  372. Migrating tablespace from dictionary managed to locally managed
  373. Index Organize Tables
  374. [q] How To Create Rpository
  375. how to identify 2 different session on same machine
  376. can I audit a truncate on a specific table in Oracle8?
  377. when to merge two databases
  378. Configuring 10g OEM for USER DEFINED ALERTS
  379. Configuring 10g OEM for USER DEFINED ALERTS
  380. Bring over Oracle 9i db to Oracle 10g
  381. SQL Loader
  382. Oracle_sid
  383. Easy end user reporting and graphing tool for Oracle standard edition.
  384. New install of 10g
  385. SELECTION CRITERIA
  386. Openning/Shutting down Oracle database from the Client's SQL*Plus
  387. Tables without primary key
  388. 10g job scheduler errors
  389. Red Hat Professional Workstation
  390. Poor performance after oracle 8i upgrade
  391. Bakbone Software
  392. Help with Import ORACLE
  393. Installing 9i or 10G on Linux RedHat x86 - errors.
  394. test
  395. database structure problem - advice please?
  396. Start 10g Infrastructure and AS
  397. Again about Oracle 8i on Win XP Pro
  398. Create trigger on view with long raw column
  399. Java Tree In Oracle Forms
  400. Regarding query
  401. error linking oci7 with oracle9i on AIX 4.3
  402. Reorder Primary Key - any problem?
  403. Oracle Database performance on Windows 2003 with IIS 6
  404. Oracle error
  405. Create ResultSet "from scratch" in Oracle Java Stored Procedure?
  406. $85/hour - Oracle Advanced Benefits Analyst / Lead
  407. can you intergrate oracl REPORTS with version constrol software LIKE.....
  408. oracle
  409. PLS-00306: wrong number or types of arguments in call to '||'
  410. Migrating from HP-UX to AIX
  411. Installing Oracle 9.2 without using OUI (Alpha OpenVMS 7.3-1)
  412. Subject: Oracle Analysts, Designers, Developers needed. Oracle 9i, 11i, PL/SQL, tools knowledge etc
  413. AIX CIO with Oracle
  414. For Billy Verreynne
  415. import dmp into SQL Server
  416. ORACLE/ PORTAL/ CONTRACT/ IMMEDIATE
  417. ORACLE/ PORTAL/ CONTRACT/ IMMEDIATE
  418. ORACLE/ PORTAL/ CONTRACT/ IMMEDIATE
  419. basic plsql question
  420. SQL optimizations in Oracle
  421. Killing oracle sessions
  422. Oracle (6i) application crashes in Citrix farm with error ORA-06508.
  423. Oracle (6i) application crashes in Citrix farm with error ORA-06508.
  424. Application Development Framwork for 10g and BC4J for 9i
  425. send a table of records from pro C to Oracle pl/sql stored procedure
  426. DBFlash for Oracle - looking for beta testers (modified post)
  427. DBFlash for Oracle - looking for beta testers
  428. db2 vs oracle
  429. O8 reorganization or O9 upgrade - which first?
  430. Show/Hide column name
  431. Oracle administration and Performance - Linux Cluster vs Windows Cluster
  432. ORA-06502 PL/SQL character string buffer too small
  433. JDEVELOPER/ CONTRACT/ FL
  434. JDEVELOPER/ CONTRACT/ FL
  435. dbms_job polling interval
  436. table relationships
  437. Oracle Forms Reference
  438. PROC Problem : Select for update
  439. [9i] Not enough large pool during export
  440. Oracle 11i with AIX 5.2
  441. TNSPING works SQLPLUS fails whsn connecting to remote server
  442. connections differences between 8i and 9i
  443. Large Table Update/Merge problem
  444. FETCH arbitrary columns from a ref_cursor
  445. ORA-12154: TNS:could not resolve service name
  446. Understanding "lsnrctl status"
  447. [q] IMAGE
  448. Question on select count()
  449. RMAN resynchonize question
  450. How to call a private package level function
  451. Convert Long to Varchar
  452. direct path insert
  453. Oracle Training Question
  454. how to increase processes?
  455. How to return a status from sqlplus to .ksh unix script ?
  456. change port number
  457. PL/SQL error !
  458. Resizing the SGA
  459. How to bulk insert an array to Binary data using OCI.
  460. question about Oracle certification
  461. problem w/ creating view to show previous year's data...
  462. ingres odbc driver
  463. Select query for sum of hours
  464. Unable to install Oracle 9i on IBM R51 notebook
  465. Oracle 9i: Keep multiple servers in sync
  466. Insert multiple rows via XML?
  467. Transactions on remote databases
  468. SQL Update with a Join Syntax
  469. HOW to USE 'LONG RAW' in Bulk Insertion using OCI
  470. SQL 9i OUTER JOIN QUERY
  471. PL/SQL problem with Updates that specify varchar
  472. ORA-00054: resource busy... - what on Earth?
  473. Calculating Average on columns with zeros.
  474. Report Generator for Oracle and other RDBMS - beta testers needed
  475. Oracle Forms
  476. How to insert an Array to Oracle?
  477. Conversion UTF-8 -> CL8MSWIN1251
  478. encapsulate/embed pl/sql in DAO
  479. sql - statement: building differences between data-sets
  480. View-Concept Data Mining Oracle
  481. Enterprise OpenSource Project using Java Stored Procedures of Oracle
  482. tablespace
  483. Dynamic SGA and pinned
  484. Error message on ODBC Connection
  485. Problem with Oracle
  486. Corrupt Primary Key index on table causing ORA-600 internal error
  487. Java Stored Procedure extraction from Oracle database.
  488. [newbie] select records, update with procedure
  489. Fastest for Inserting into Oracle?
  490. Invalid attribute in connection string. Nuby needs HELP!
  491. low cardinality and highly concurrent db
  492. Oracle SQL query by date
  493. dynamic sql substr length strange value (aix/hp differences?)
  494. Law for ORACLE administrators
  495. Database design
  496. [NEWBIE] Help with a simple query
  497. Report Generator for Oracle and other RDBMS - beta testers needed
  498. Oracle JDBC connection string : how to hide password ?
  499. rowid ?
  500. Oracle Noob need help with function
  501. Conference Announcement
  502. How to lock a row over a SELECT followed by an UPDATE
  503. SQL*Plus Parameters
  504. Query Performance
  505. is Oracle technically better than Ingres ?
  506. PL/SQL - ref cursor
  507. Oracle10g on Solaris10
  508. query help
  509. Report Generator for Oracle and other RDBMS - beta testers needed
  510. Oracle Data Warehousing Consultant - Toronto - urgent contract
  511. PL/SQL online programming courses
  512. getting server name and db name
  513. Recovery From Loss Of Control File
  514. DB Logoff vs. Schema Logoff
  515. Cisco Access Control Server and Oracle Internet Directory
  516. Couple of Days Oracle Work Available in Surrey
  517. Ahhhhhhhh
  518. INFORMIX equivalent of DBSERVERNAME in ORACLE
  519. Load Balancing in Oracle 9i Forms Application
  520. CBO bug?
  521. Output parameter and dynamic sql
  522. Oracle Slowing Down Each turn - Newbie
  523. PL/SQL code
  524. Ordinal Function
  525. Good Looking? Want to Make Cash Fast? 9041
  526. Oracle 10G Net Config fails to start - installation issue on Windows in a domain
  527. Misterious Error in Pro*C
  528. Pass variable into View?
  529. optimizing sql joins?
  530. Oracel database consolidation criteria
  531. Manually convert data from ZHS16GBK to UTF8 on ORACLE 8(Character Set US7ASCII)
  532. accessing multiple instances
  533. sql corrector
  534. My Silicon Tits 5957
  535. Optimizing Sql - unable to use index
  536. Wrapping up of Views in Oracle DB
  537. Return multiple queries from stored procedures
  538. Return multiple queries from stored procedures
  539. archived active redo logfile group corrupted
  540. Transform Cursor to Bulk
  541. Oracle DB with Pro/5
  542. Oracle ETL consultant (discoverer & warehouse builder exp.) - canada
  543. SQL Problem
  544. update table a.fkid from table b.pkid
  545. Pro*COBOL Precompiler - Generic Make File
  546. Oracle column default value
  547. Oracle column default value
  548. Optimising Oracle 9i for million-record JDBC read-only access
  549. Rollback segs,
  550. Re: help!ORA-01445: cannot select ROWID from a join view without a key-preserved table