View Full Version : answers

Pages : 1 2 3 4 [5] 6 7 8 9 10 11 12 13 14
  1. Oracle9iAS + JBuilder9
  2. materialized view. help...
  3. Re: Oracle Universal Installer does not run on Win2000 install..
  4. confused about ifs
  5. Re: LNK2001: unresolved external symbol
  6. problem in to_date function
  7. ocp developer
  8. DBMS_SQL.define_column ---- why ????
  9. How to call dynamic remote stored procedure in the dynamic sql
  10. OCI Bind for RAW field, Cannot select a record matching a hexadecimal Key (raw type)
  11. Re: help with utl_smtp email headers
  12. Indexing multiple fields with Oracle TEXT (Intermedia)
  13. URGENT PROBLEM: refresh data in Discoverer
  14. Oracle - Commit Before invoking a trigger
  15. exception
  16. Invitation to Join SV_RFID!
  17. db2 runstats
  18. Korean data load from Excel sheet to Oracle table
  19. P4 Bug and 9iR2
  20. JDeveloper 11i
  21. Strange Utl_File Error on NT
  22. Integrating crystal reports with oracle forms
  23. Re: ODBC & Correlation Name (:new and :old)
  24. Oracle password change using the Verify Password function
  25. need a Sample online hot backup script for UNIX..
  26. BLOB and .NET
  27. Un-install Oracle Personal Edition 9i
  28. Re: ODBC & Correlation Name (:new and :old)
  29. full outer join question
  30. Problem installing Oracle 9i on XP
  31. Difficulty inserting due to &
  32. Re: help with utl_smtp email headers
  33. help with update sql
  34. PL/SQL Function Help
  35. comp.databases.oracle
  36. Re: Light Oracle 9i Client install
  37. Compilation unit analysis terminated?
  38. How to handle a long strings in a pl sql stored procedure,
  39. documentation on moving OraHome to different machine
  40. Reserved words with "ROW"
  41. Oracle 9i w2k Client error -Credential retrieval failed.
  42. I have a question with sqlplus...
  43. Re: Oracle 9i software- for DBA exam
  44. .NET OLE DB Connection
  45. Re: Error PLS-00201
  46. ODBC Escape {oj} problem w/ ADO
  47. Oracle ODBC error with ENCRYPTION
  48. Re: Instance question
  49. Downgrading 7.3.4
  50. Re: Instance question
  51. Java/Oracle thin driver SQL statement limit
  52. Help required with OCI
  53. Re: Dummies guide to fast inserts ?
  54. Re: OID configuration for replacing Oracle Names
  55. Statement returing True/False in decode() function
  56. Read Only Transactions
  57. Re: Oracle 8i VS Oracle 9i certificate
  58. Re: Oracle 8i VS Oracle 9i certificate
  59. How to Inactivate the Oracle User?
  60. Backup file format
  61. problem of installing oracle on linux
  62. Reports wont print on Citrix server
  63. How to reference table/view that has "slashes" in its name!
  64. Porting database from Oracle7.0 to Oracle8i
  65. Advanced Enterprise Database Planning/Design Books
  66. Oracle tablespace management
  67. Re: Oracle on Solaris-Intelx86?
  68. Re: 8.1.7 Make file errors on Red Hat AS 2.1
  69. Help needed in SQL Query
  70. Apache installation error
  71. using Autonomous transaction
  72. Re: Help please- Heterogenous services suing General Connectivity agent
  73. Accessing Oracle from VB
  74. Number of elements in "IN operator"
  75. Designer failing to reverse Engineer
  76. Writing binary data to external file
  77. Backup
  78. Re: Problems (with Oracle9) using OCI JDBC driver on AIX 5
  79. Re: Problems (with Oracle9) using OCI JDBC driver on AIX 5
  80. User is not allowed to work in a period of time
  81. Calling Operating system command from Database
  82. executeQuery Can't pass variable to SQL. :-( Why?
  83. Re: starting Oracle service automatically
  84. Unable to compile in TOAD (purchased version)
  85. Groupped count(*) results from a view
  86. ORA-00904
  87. Re: oracle server 9i on window + linux client
  88. newbie question
  89. Re: Problem connection to an Oracle Database ??
  90. Re: Problem connection to an Oracle Database ??
  91. Unknown error in Developer 6i
  92. Re: Backup Script
  93. HELP, conexion Discoverer-Informix
  94. archivelog v/s nonarchivelog
  95. OCI Wrapper libraries ?
  96. Re: svrmgrl management API
  97. Bounce the Application Server
  98. Re: svrmgrl management API
  99. setup for online project.
  100. Oracle JDBC 9.2.0.3 slow?
  101. Collections: Bug? Table()? BULK COLLECT?
  102. Problems querying oracle db from Access 2000
  103. Connect to another DB
  104. Re: Oracle 8.1.7 problems installing
  105. Unicode Doubt in Oracle
  106. sqora.gid and sqora.fts file
  107. Re: PROBLEM WITH DISCOVERER JOINS
  108. Re: PL/SQL Collections
  109. dad
  110. Problem of installing Oracle on Linux
  111. Re: PL/SQL Collections
  112. preventing CONNECT BY from generating an error if cycles exist
  113. Re: Loadjava hangs in RedHat Linux (URGENT)
  114. Re: Loadjava hangs in RedHat Linux (URGENT)
  115. Questions about Oracle 9i Upgrade
  116. Re: Oracle on Solaris-Intelx86?
  117. Re: pro*c install in 9i
  118. Please Help me!
  119. Mysteriously dropped connection and deciphering the trace
  120. Shared Sequencers
  121. exception ORA-32101 creating environment
  122. [newbie] Why does not my installer start?
  123. dynamic table creation
  124. drop table from readonly TS
  125. URGEEEEEENT PROBLEM WITH DISCOVERER
  126. increasing extents because of ORA-01632
  127. Oracle 9i on Red Hat 9
  128. Error installing Oracle 9i
  129. Tuning SQL in Oracle
  130. Oracle client install on AIX 5.1 -- NetAssistant & SQLPLUS do not run
  131. Why is "jdbc:oracle:thin" called a thin driver?
  132. "Grant a Role"-Statement in Triggers
  133. Re: rownum HELP ....
  134. SQL Loader into another user's table
  135. Oracle Discoverer
  136. Re: CTXCAT problem on 9I
  137. oracle terminal 1.0
  138. How to hide ORA-06512 and ORA-04088 error messages?
  139. SQL sequence creation
  140. Need help with SQL statement!
  141. OCI and getting client version
  142. Re: How to create package specification and body for Student registration system
  143. Can i control ORACLE FORMS from external
  144. OWS-05101: Execution failed due to Oracle error -6550
  145. Re: How to create package specification and body for Student registration system
  146. working with dates in oracle
  147. utl_smtp x select statement
  148. Storage Capacity Planning
  149. dbWidget 1.0 - New Heterogeneous Database Development Tool
  150. Developer 2000 v 4.5 in windows 2000
  151. Re: dbms_metadata for Synonym
  152. multi row update in one SQL statment
  153. mutating table error w/trigger
  154. Oracle DBCA java.lang.NullPointerException
  155. Re: Oracle not using Index
  156. Re: Oracle Universal Installer Problem
  157. Oracle Database Applications - platform dependancy??
  158. Commit Status After Failure
  159. Oracle Client9i
  160. Required field for updates
  161. Oracle Collaboration Suite layout
  162. Constraints with several father tables
  163. ORA-00904: invalid column name
  164. another PLS-00201
  165. Please tell me more about packages component
  166. Does OCCI support Unicode?
  167. replace tags in doc files from PLSQL procedure
  168. calling an external java program from a trigger
  169. Tools for debug PL/SQL
  170. DIFFERENTIAL BACKUP QUESTION
  171. Combining 'search' values in DECODE
  172. Re: Oracle Function Ownership Problem
  173. Re: Access violation on setup of Oracle8i Personal Edition
  174. Re: Use of Parallel Query Servers
  175. Dynamic sql query
  176. not able to connect to oracle 8.17 database on win 2000
  177. Re: Use of Parallel Query Servers
  178. Unbale to find sqlcxt reference
  179. What is PL/SQL Packages?
  180. Re: how quick query can be
  181. Re: Oracle Function Ownership Problem
  182. Re: dbms_metadata for Synonym
  183. Insertar de Oracle a Sql Server
  184. Fooling Oracle re: extent allocation
  185. import table between Oracle 9i to MS Access - errors?
  186. Break a table into small finite tables
  187. Cube Viewer Problem
  188. UTL_FILE.put_line limitation under Oracle 7
  189. Re: Oracle JDBC, SQLException, COMMIT is not allowed in a subordinate session
  190. linux-oracle-hyper threading
  191. Problem when using SQLPlus in Oracle 9i
  192. Re: Tunning Indexes
  193. subquery not allowed here
  194. Re: Oracle JDBC, SQLException, COMMIT is not allowed in a subordinate session
  195. Oracle Books For Sale
  196. Re: HASH Function in oracle SQL PL/SQL
  197. Oracle on Linux
  198. Re: SQL construct not supported in informix ?
  199. Fragmented database
  200. Connectstring with SQL*Loader
  201. end-of-file on communication channel while executing a sql query
  202. Re: Package problem
  203. DBMS_METADATA PL/SQL Supplied Package
  204. Which self-test software?
  205. Re: can not delete data from a table which is queried in a stored procedure
  206. Database link and ORA-02041: client database did not begin a transaction
  207. TNS-12560:Protocol adapter error from client side only...
  208. Returning record X-Y from a table
  209. Re: RAID Levels
  210. Re: Can't Open 9i Olap Viewer
  211. Re: Experienced PLSQL, Newbie to Java -- Why would one use java?
  212. Cubegeek.com - Multidimensional Thought for the BI Professional
  213. Experienced PLSQL, Newbie to Java -- Why would one use java?
  214. Performance probs with Connect 4.2 for Oracle Wire
  215. Re: Attach a file in UTL_SMTP
  216. Re: adding to source coutrol
  217. Difference between archive and redlolog?
  218. Re: Query help
  219. Tables with a row size limit?
  220. jacorb and oracle
  221. Single Complex Query Vs Temoprary Table
  222. Oracle newbie
  223. Test
  224. FRM-10095: Assertion failed in iewbdbc_oracle_to_id
  225. Query for Return character?
  226. Sure-fire "kill"
  227. OCP DBA Certs
  228. Eliminate Duplicates Using SQLLDR and/or .ctl file
  229. Re: plsql.jar and JVM
  230. Capacity Planning for Oracle database
  231. How to insert multiple rows with a single INSERT.
  232. Oracle IRC Channels
  233. OCI: How to insert BLOBs with array interface?
  234. export method
  235. Oracle Intelligent Agent Executable
  236. Re: update empty column according to existen data
  237. Help!! Any non-RAC high-availability experiences with Oracle9 ??
  238. Re: Doubt UTF8 database
  239. Re: Database Performance
  240. Oracle to double hiring of Indians
  241. -- how to check if database link is active
  242. dbms_output.putlin show up AFTER completion???
  243. difference between client adn server
  244. Oracle rounding question
  245. Searching in complete DB
  246. Mix and match
  247. SYS_XMLGEN returning blank records, PLEASE HELP, COMPLETE NEWBIE
  248. The dreaded TNS-12500 error.
  249. Re: How to get the list of variables and constants declared in a Oracle Package?
  250. Re: How to get the list of variables and constants declared in a Oracle Package?
  251. Re: How to retrieve latest record when date and time are separate ?
  252. OCI: How to insert BLOBs from OCI ?
  253. Re: How to retrieve latest record when date and time are separate ?
  254. Minimum requirements for ODBC connectivity to Oracle database
  255. Trigger and DML INSERT on separate table
  256. How to Keep selected text items from being highlighted? In forms 6.0
  257. Re: Easiest way to output XML based on SELECT statement or Stored Proc
  258. Re: How to retrieve latest record when date and time are separate ?
  259. Re: How to install SQLPLUS editor on windows for ORACLE isntalled on UNIX
  260. Oracle error log
  261. connection problem
  262. Re: How to retrieve latest record when date and time are separate ?
  263. Re: Select Top ... * from ... command
  264. How to prevent table entry from being deleted but perform statements in the body of a trigger ?
  265. How can I get database SID in stored procedure in Oracle?
  266. Re: Oracle and W32.Bugbear.B@mm
  267. UTL_SMTP x INITJVM.SQL
  268. Info on Oracle Replication
  269. Should developers have DBA role?
  270. Need to dynamically generate a SQL SELECT which excludes NULL columns
  271. Re: ORA-02291: integrity constraint (%%%) violated - parent key not found
  272. Syntax espression
  273. Is text_io part of FORMS or PL/SQL? Can text_io be used with DBMS_OUTPUT in PL/SQL?
  274. Re: problem to connect with Oracle Management Server
  275. returning a multi row select within a single row select
  276. [Quick Question] Programming Jobs on Oracle?
  277. Oracle 9i/9iAS co-existense question
  278. Re: Latest Study Guides for Oracle 8i 9i OCP OCA exam
  279. Re: Visual C++ and Oracle - increase speed and preformance?
  280. Oracle RDB stored procedures and resultsets
  281. Re: Oracle 9i
  282. Tracking users
  283. Inconsistant query results - Please help
  284. Oracle 8.1.7 on Mandrake 9.1 install problems
  285. Strange SQL behaviour when using query short-cuts
  286. undefined reference to `sqlcxt' (Pro C compilation problem)
  287. Re: Help: Oracle Workflow Mailer
  288. JDBC problem in rollback
  289. form not running on 6i
  290. Oracle dba studio
  291. Oracle on NT4 memory use
  292. Re: Newbie question....
  293. Re: Newbie question....
  294. Index on date-fields with NULL values
  295. Two instances of Oracle client on one PC
  296. Which Red Hat Linux version supports Oracle 9 DB?
  297. Strange behavious - inconsistencies between SQL in SQL*PLUS & SQL embedded in PL/SQL
  298. Adonis on Oracle
  299. Closing a data base link
  300. upgrade 8.1.5 to 9i
  301. Oracle install and Java problems
  302. Re: Export from 9i and import to 8i
  303. Re: Export from 9i and import to 8i
  304. ADDRESS_LIST, CONNECT_DATA in OCILogon
  305. Re: Why SAP is doing well when Oracle is not
  306. Oracle certification question
  307. Re: Conditional Constraint?
  308. Re: Conditional Constraint?
  309. Re: ORA-12560:TNS:Protocol Adapter Error on Netware
  310. How can I get Oracle 8i for Windows 2000 on a CD ROM ?
  311. Re: How to duplicate whole database from one machine to another machine in Windows 2000?
  312. Very slow initial connection on Oracle 8i
  313. Re: ORAKnowledge
  314. Oracle OFA, Tablespaces and Redo Logs?
  315. database link
  316. disable O/S file cache??
  317. How To Update A Table From Excel
  318. Help: Problems with ALTER TABLE
  319. PL/SQL: Printing questions
  320. Problem with Distince and Index - Inconsitant output
  321. Re: Rates of change???
  322. Problem with Oracle 9i on laptops -- disk writes every 1-2 seconds!
  323. Orcale 9i -- NOT friendly with laptops -- the probe disk-hit every second!
  324. oracle 9i on a laptop ~~ how do I prevent the ~1 second disk hit on my laptop! This is a MAJOR problem!
  325. -- determine changing time of record
  326. Standby Database Issues
  327. Re: Please help running DBCA
  328. Problem with TOAD 7.5 and 9i DB
  329. Oracle Thin connectio fails from outside the network
  330. Re: Rates of change???
  331. Oracle 8.1.7 Unions with differing datatypes in the selects
  332. Do you have end-users like this?
  333. Re: Forms9i builder not starting on redhat linux 9
  334. Cost based optomizer problem. CBO won't merge view
  335. Re: Running PL/SQL procedure on client side
  336. Oracle Intermedia / Image Import
  337. Sample Data Model for a College - Course Scheduling and student info
  338. Rollback Segment Errors
  339. search on front of compound key
  340. How to improve deletes on a non partitioned table with no indexes
  341. Compiling Oracle Stored Procedure from VC++
  342. Re: Materialized View/Snapshot without Triggers?
  343. Get the user logged on NT with a trigger in Oracle
  344. Decode question
  345. Re: Help needed getting BC4J in Jdeveloper to recognize Rowid and Primary Key info in a MySql database
  346. Where OCIDirPathPrepare is defined?
  347. ORA-12154: TNS: could not resolve service name..when using hsodbc
  348. NT client crashes to blues screen on dual processor board
  349. OCI: generic binds
  350. FULL OUTER JOIN for oracle8(i)
  351. HELP: dbms.job - scheduling job at exact time
  352. Re: Slow client operations
  353. Re: Materialized View/Snapshot without Triggers?
  354. Re: NLS_DATE_FORMAT with SOL Loader
  355. Re: JSP not responding on 11.5.8
  356. User DB with User NT
  357. pre-production environments
  358. Inconsistent Query Results
  359. Re: cannot connect with JDBC THIN driver to ORACLE 8
  360. Re: Changing database server location
  361. Re: ORA-12514: TNS:listener could not resolve SERVICE_NAME
  362. Re: Delete child-parent records???????
  363. changing database location
  364. Re: Installing Oracle 11.5.8 on Mandrake
  365. Cannot connect with OCI driver and Oracle 9i (9.2)
  366. ORA-01004: default username feature not supported; logon denied
  367. External Table Query runs in PL/SQL but fails in perl script
  368. File too large..
  369. question
  370. deleting data
  371. DataBase is not Connected through Application
  372. Oracle Parameter not getting value
  373. help with PL/SQL (ORA-06502 & PLS-00204)
  374. DLOOKUP function
  375. How to execute trigger instead of view while changes are done on a field in the table
  376. copy access tables to oracle
  377. Need to connect oracle database using Unix script
  378. Need a unix script to do match two files
  379. ORACLE10: Rename column that has keyword name
  380. ORA-03113 : end-of-file on communication channel
  381. Need help with append and delete duplicates
  382. How to run & view the out put of procedures in SQL:\>
  383. Oracle 9i Installation problem
  384. Informatica Licence Key-
  385. Oracle Apps
  386. How to bring up Enterprise Manager Oracle 10g
  387. Count(*) and performance
  388. Regarding tablespace issues
  389. how to change the password for sys schema?
  390. TOADS Explain plan
  391. Reg AOL
  392. Single sign-on configuration assistant failed during App Server install
  393. Update the first x of the records returned
  394. Encryption
  395. new feature in oracle 9i
  396. Run sql statement through batch file
  397. Using Collections in PL/SQL
  398. Refreshing or recreating a materialized view
  399. New to Oracle Help me out....
  400. Load Xml in oracle (SQL LOADER)
  401. Query too long
  402. Number Formatting
  403. New to Oracle
  404. Command hangs and doesn't end.
  405. SQL statement to store and retrieve 2byte letters like Japanese characters
  406. Oracle Reports 6i Download link
  407. Convert Oracle to SQL
  408. min function
  409. Timed Out Error in Oracle.
  410. What's the best way to load a PDF file into an oracle table?
  411. Top N results
  412. Prblems with DataSet Fill
  413. Duplicate Records
  414. E-Book
  415. Connection error from em oracle10g
  416. REG Oracle Discoverer
  417. trigger compilation errror
  418. Get Top 10 records
  419. decode question
  420. Assign field value based on date range of another variable in another table
  421. Regarding ORACLE
  422. FTP Batch file
  423. Data cloning in oracle 10g
  424. Retrieving the Nth record from a one-to-many subrelation table
  425. Can I commit portion of transaction in Oracle 9i?
  426. Back up or export Oracle Database Lite 10g syntax
  427. how to returning a recordset
  428. problem with connection
  429. Difference between Having & Where Clause
  430. How to connect to database????/
  431. login details
  432. Dates between the two given dates
  433. Data Dictionary Views
  434. Oracle transparent gateway in z/os
  435. Syntax error
  436. insert time only
  437. Tuning a stored procedure
  438. Regular expression in Oracle
  439. Creating Table in Oracle
  440. Calling Apex from Oracle Forms
  441. primary key
  442. date & time between
  443. Subqueries
  444. procedure and function
  445. countfunction
  446. Stored Procedure returning multiple values
  447. multiple row insert
  448. apps output in excel
  449. how to insert very large text into CLOB datafield?urgent.....
  450. SQL command not properly ended?
  451. Query Help
  452. Oracle 9i driver
  453. OrderBy question
  454. Oracle Reports
  455. Report not running in web layout
  456. flush shared pool
  457. Adding minutes to a date field
  458. The same signature of Stored procedure
  459. Failed to load the following object in oracle forms
  460. urgent help needed regarding arrays insertion
  461. Displaying specific data from the database
  462. Spooling more than one file
  463. count(*)
  464. no data found error in an "execute immediate" statement
  465. Creating Customer Address
  466. inser the row
  467. Concat used by optimizer in where clause
  468. Date conversion problem
  469. sql query tuning
  470. LIKE Operator
  471. It's urgent (Oracle running slow)
  472. PLS-00201 error from PHP
  473. Calling a Stored Procedure via a trigger
  474. Lookups
  475. report error
  476. PL/SQL:PLS-00410 duplicate fields in RECORDTABLE or argument list are not permitted
  477. Cannot avoid duplicate results
  478. size of image file..
  479. Update and Insert trigger definition
  480. Amend and udate data using 10G EM ?
  481. hi amit..newbie oracle help me please!!
  482. In correct date format
  483. ORA-00907-passing blank space inside a parenthisis pair
  484. Tracing users by after logon trigger
  485. Urgent Help Needed
  486. PL/SQL Trigger Restrictions
  487. autonomous trans with EXCEPTION fails - why?
  488. need to know about oracle
  489. Use Duration and booking date to stop bookings during this time
  490. procedure
  491. merge
  492. current user
  493. import a .dmp file
  494. Function..help!
  495. need some docs regarding Sql tunning
  496. How do i Optimize this Query
  497. inserting unixtime in database
  498. Counting Commented lines in code
  499. Listener error
  500. Creating A Text File
  501. How to restore the path variable to get OracleDevSuite working?
  502. How to Connect Forms using VPN / DSL
  503. help! i need a solution pleas..cn i use subquery..
  504. Ora-01092 Errror
  505. Need help on using analytical function
  506. Deduplication in 11g works only in alter/modify?
  507. To update a record using rowid in duplicate row.
  508. correlated subquery in oracle
  509. Problem in wirting data in Excel sheet using owa_util package
  510. Stored Procedure Coding Problem
  511. Rewrite query using bulk collect to improve performance
  512. how to write a query to make its execution time better .And the standards.
  513. latest row inserted
  514. how to see all the inserted rows of a particular date
  515. function
  516. Use Serial Port In Oracle
  517. Problem with inserting dates
  518. Access violation at address 00000364. Read of address 00000364
  519. trigger types
  520. Composite primary key
  521. Table type parameter to a procedure
  522. hetrogenious database connectivity error from oracle to sql server
  523. pl/sql coding problem
  524. Calling a Package
  525. resolve this sql query urgent
  526. hi for all
  527. RMAN Duplicate
  528. which oracle version and forms can install on xp2
  529. Copy all values of a column from one table to another
  530. Isnull Problem
  531. Connecting Oracle Forms and DB using VPN connection
  532. Current Opening Balance from the table AR_PAYMENT_SCHEDULES
  533. sql temt table error
  534. Updating a column based on value in another table
  535. Query to find all transactions for a particular user
  536. database is giving data block corruption
  537. Reliability & Efficiency of Database links for far located remote databases
  538. OWS-05101: Execution failed due to Oracle error -6564
  539. Basic oracle quries
  540. Select query for Ageing Report 30,60,90 days
  541. Data limit of Oracle for DataWarehouse application
  542. what is this exactly FND_CLIENT_INFO
  543. problem regarding retrieving image from database
  544. Dynamic sql generation using oracle 10g stored procedures
  545. select query is taking some time to return values
  546. Procedure Return two values
  547. My Stored proc is not able to fetch output in crystal reports
  548. Issue in invoking procedure
  549. B* tree
  550. Use a specific database & find it's tables.