View Full Version : answers

Pages : 1 2 3 4 5 6 7 8 9 [10] 11 12 13 14
  1. Doubt in sql query
  2. Pass large amounts of text to a stored procedure written in java
  3. Developer 9i Reports
  4. init.ora file
  5. Oracle Reports Down/Across Print Direction
  6. How to Rollback between two different DB in ORACLE?
  7. permanent to temporary
  8. data dictionary views
  9. how to mount datafiles in newely installed oracle
  10. Import and Export of data from Excel to oracle
  11. tablespaces
  12. creating forms in oracle
  13. creating forms in oracle
  14. How to save an MS Word/Excel file in database?
  15. triggers
  16. multiple foreign keys on same column
  17. Anyone know any DB2 ?
  18. How to generate osntab.o?
  19. ColdFusion / Oracle 9i Intermedia application errors
  20. updation in object databases
  21. Database fragmentation
  22. Help w/ SQL / Oracle - Building Tables?
  23. New to SQL - Help with Building Tables/Fields!
  24. Upload And Download Pdf Files From Oracle Database Table
  25. new 2 oracle
  26. i want to calculate tax amount
  27. How to write a calendar with pl/sql?
  28. Alignment problem in 10g
  29. clustered and non clustered indexes
  30. can I use a query as a variable?
  31. internet error message (oracle 9i)
  32. Best naming convention in Oracle Development
  33. I want to update a field of a table from other table on Run_time.
  34. time based triggers
  35. Orcle Forms and Reports for a Beginner
  36. write a package in pl/sql that reads a sql query, encrypt each row and write to text
  37. I want to update a field of a table from other table on Run_time.
  38. Database Error
  39. How to select a WHERE condition depending on another cond
  40. want to update records of 2nd table when i insert values in 1st table
  41. How can I list all users using a particular Tablespace
  42. out of memory oracle 9i
  43. migration from Oracle 8i to 9i
  44. Restore DBF files
  45. real challenge!
  46. missing right parenthesis
  47. Oracle installation
  48. got an error message " ORA -12541 :TNS no Listener" while try to log in to Toad
  49. how to find particular char in entire field ?
  50. From Oracle To Word
  51. Change system date with Oracle sql statement
  52. Multi-user Password Database Solutions?
  53. DB2 to Oracle migration
  54. Problem installing Oracle 9i in Windows XP
  55. Transaction Control
  56. Return MIN and Max for a particular subset
  57. Oca
  58. How to update a set of characters from a given number of char ?
  59. problem with 2 not null fileds on one table
  60. Urgent:Problem with Partitioned Tables
  61. bulk collect
  62. bulk collect
  63. Oracle insensitivity
  64. Sql tuning
  65. How to check a grant
  66. Oracle configuration
  67. is oracle a MS Access like software
  68. Help Required in Query
  69. Inserting into Oracle table from MsAccess using VBA
  70. How to pass Collection Types(Table of Object) present in Oracle Procedure.
  71. Install Oracle Discoverer on Web
  72. oracle 8i not functioning on XP
  73. Having problems with printing using triggers
  74. Displyaing Datatypes in SQL query?
  75. Help needed querying data between two dates!!!!
  76. Forum for DB2 related queries
  77. chart wizard (report builder)
  78. Query to eliminate dulicate rows
  79. Query to find the third largest row in a table
  80. Oracle version 9.2 - Discoverer Version ???
  81. List of all views created upon a specific table
  82. help with querying dates
  83. DELETE query in Multi Threads
  84. Graph Problem.
  85. How to connect oracle with php
  86. Help needed Regardig User_constarint tables
  87. getting distinct multipe coloumn list from duplicate row column data
  88. Exporting to Excel
  89. DISTINCT ON function in toad
  90. how to make simple calculation in oracle
  91. Oracle 10g installation problem on SuSE 9.0 linux
  92. Problems in installing Oracle 9i database on Linux
  93. Basics
  94. sqlldr
  95. Purging records
  96. RUN_REPORT_OBJECT_PROC must be declared
  97. Is oracle a platform like a MS Access
  98. SQL SERVER ---- Oracle Migration????/?
  99. Group functions
  100. help regaring the foreign key
  101. how to create new database
  102. Calling scripts in different server from Oracle9i database
  103. send a mail if insert operation fails
  104. Difference between oracle client and oracle server
  105. varchar2
  106. cursors
  107. HELP - SELECT...INTO Variable ---> More than one variable???
  108. worksheet to a table
  109. new user
  110. Oracle: Grouping by all the columns of a table
  111. error when I try to create a type
  112. ora 12541 :no listener
  113. ora:12560
  114. Trigger - Data from Multiple table
  115. HELP!! errors managing. i need help.
  116. regarding sqlplus querry processing
  117. PL/SQL Developer - question about the Editor preferences
  118. How to Initialize Collection Types/Object Types in Oracle
  119. How to determine if the table exist in oracle?
  120. ORA-06531: Reference to uninitialized collection
  121. Win2K and Win XP based POS registers cannot communicate wih server
  122. Help with Date Conversion to Session Timezone
  123. pls help me. i am an new member of this site
  124. ORA-01555: snapshot too old: rollback segment number 24 with name "ROLL24" too small
  125. regarding on delete set null ....
  126. Wrong number or types of arguments
  127. Urgent Requirement For Oracle Crm Consultants
  128. Urgent Requirement For Oracle Crm Consultants
  129. How to change Oracle Port No.
  130. migration of database
  131. query
  132. update from excel file
  133. How to use two tables in view? which is referred in the block of the forms
  134. prompt the user to insert a new customer
  135. Oracle 9i
  136. how to divide a column into two
  137. how manage errors in Unix's scripts for oracle connection and procedure's calls
  138. SQL Update statement for 50,000 entries
  139. How Can implement One to many Relationship With oracle object
  140. Creating Forms List Item
  141. i dont know why it keep coming up missing expression in line 1
  142. Connectivity Problem
  143. 3 Oracle forms developer Questions
  144. Inner Pl/SQL error in Oracle 10Gr FormsBuilder
  145. Sql query help
  146. How Can We Select More Than One Node in a Tree
  147. DIFFERENCE BETWEEN ORACLE 8i & ORACLE 9i
  148. pl/sql(help me please) insert into
  149. problem to call a stored procedure from unix using a script
  150. Recover deleted rows from a table from archive logs?
  151. PL/SQL Developer Editor Preferences
  152. Datbase Level DML Trigger
  153. Need To Create Tablespace,Alter TableSpace,Drop Tablespace
  154. HELP Needed !
  155. Forum enhancement
  156. Oracle Export/Import in XML/ASCII format
  157. TNS-12560: TNS:protocol adapter error
  158. Timezone Conversions - URGENT
  159. unix script ti connect to an oracle database and call a stored procedure
  160. sequence key only be primary key?
  161. Distinct function in TOAD
  162. data block corruption
  163. How can I connect Oracle with C# and OCI!!!
  164. problem in math formula
  165. insert into table
  166. alter table
  167. extract data from dmp file
  168. How do I use count on relationships?
  169. stored procedure
  170. Create a Trigger to retrieve ROWID & pass to a Procedure... Where do I begin ?
  171. IP address of the machine from which INSERT is given
  172. View Creation Syntax Issue?
  173. Install Oracle 8.1.x on P4 Machine
  174. ORA-214 control file mismatch
  175. Migration of Data
  176. Exception in DB2 sql stored procedures.
  177. New line in procedure.
  178. Procedure to load data from XML file to Oracle Table
  179. trnafer date in oracle from text file
  180. display data with Stored procedure
  181. Creating a .bat file
  182. Simple Select Qry
  183. Oracle client software for HPUX 10.20
  184. Reduce the size of tablespace ??????
  185. Costs of databases
  186. Oracle 9i Jobs on Unix Server
  187. Coding for list item in Oracle developer
  188. Machine from which the transaction is initiated???
  189. least currency notes
  190. Errors...Wrong numbers or typed of arguments in call
  191. ERROR :Trigger is mutating, trigger/function may not see it
  192. forms
  193. Error mesage ORA12636
  194. Parameter in a Query???
  195. Cut testing time in half
  196. Error in writing to directory /tmp/Orainstall .....
  197. SELECT from multiple schema's
  198. Creating partioned tables
  199. Calculating age in Oracle sql....
  200. help me to find the Host string for Oracle
  201. Execution time of a Query -- URGENT
  202. Trigger to update System Date after insert
  203. Oracle Http Server
  204. One service missing: OracleHome81TNSListener
  205. Rollback whole procedure
  206. oracle 9i installation on debian linux
  207. Learning to build a natural dynamic cursor in PL/SQL
  208. orapwd file
  209. Substitution variable prob?
  210. Insert statement with related tables.
  211. Open Cursors value in Oracle database running on Windows
  212. Tracking
  213. submitting a job
  214. Vaildating data in PL/SQL
  215. ORA-00600: internal error code
  216. DB2 Isolation level?
  217. Retrive Sys Pwd
  218. starting user and password!
  219. Can any one help me in [displaying the execution time from db2udb CLP]
  220. internal error code: core dump
  221. Sequence Object
  222. a challenging query
  223. checkponit
  224. orapwfile
  225. inserting .xls file into oracle.
  226. deleting from 2 tables in one Query
  227. Oracle 9i on windows 2003 server
  228. Oracle Warehouse Builder
  229. Update Statment - Help wanted
  230. sqlldr
  231. Oracle Installation Problem.
  232. Copy data to another schema
  233. HTMLDB / SQL Question
  234. db2 catalog question
  235. cost of an SQL Query
  236. Error Logging into Oracle
  237. Oracle Reserved Characters
  238. Metalink Id
  239. URGENT help needed!! TNS issue
  240. Compatibility with 8i, VFP 9 and Win XP
  241. OLEDB error with c#
  242. I need to use an Oracle program for administration and book-keeping
  243. Dbms
  244. E Mail Using PL/SQL Procedure
  245. Optimizing the Query
  246. New project
  247. Setting maximu open cursor limit using OCI
  248. Passing String Variable in FOR LOOP
  249. Needed Query for the database
  250. Oracle beta exams - Exam# 1Z1-221:Oracle Inventory Management 11i Fundamentals
  251. connectivity from lotus notes to DB2
  252. how to import data from csv file into oracle9i very very urgent
  253. sqlplus exit statement prematurely terminates unix script
  254. SMS Data base for Tertiary Institutions
  255. Oracle DBA
  256. oracle tables
  257. Loading data into CSV files
  258. PL/SQL How to user "continue" in a FOR LOOP
  259. Problem in Bulk insert over a dblink
  260. Throw out duplicate results.
  261. Concat in a where clause
  262. how to create reports for all the users to see how many user entered dail
  263. plz help me to create username and password for ma oracle software
  264. comp.database.ibm-db2 and comp.databases.oracle
  265. Need to select multiple values from one column
  266. ORA-07445: exception encountered: core dump [] [] [] [] [] []
  267. Insert Select to same table in oracle
  268. Limitting by data type Date
  269. ora-01033 oracle initialization or shutdown in process
  270. ora-01033 oracle initialization or shutdown in process
  271. creation of database manually
  272. QuickTestPro questions related to ORACLE application
  273. Get link
  274. rep-501
  275. unable to access the function of other database
  276. Analytical function with where clause
  277. Stored Procedures and COBOL
  278. Finding all tables with a particular field?
  279. Shell script
  280. need some notes about sql loder
  281. How to access oracle in Nodes for a firewalled XP Server in LAN
  282. Help Scripting?
  283. Exercise... from vb to Oracle
  284. Can Java Store Procedure increase performance?
  285. How to update table in for loop with disturbing existing values
  286. Creating Multiple User
  287. Frm-41213 Unable To Connect Report Server
  288. How to insert null value in date column in oracle using visual basic textbox
  289. error-ora-01304 its very URJENT
  290. How to debug a Store Proc in Oracle using TOAD
  291. Urgent Assistance with SQL Query (Please)
  292. Oracle Portal
  293. Procedure in Oracle10g for Run_Product_Report
  294. reduentency
  295. SQL select help
  296. SQL select help
  297. To get n rows for a given attribute
  298. Transfer database
  299. odbc memory use
  300. Oracle Forms and object relational model
  301. IO Exception
  302. oracle error
  303. scheduling external jobs like shell scripts
  304. Oracle Connection
  305. XML Null Node Updation
  306. URGENT- ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  307. Urgent----------------please Give Some Solution On This
  308. URGENT----------------blank field and non blank field
  309. open form from the other form
  310. Disadvantages of using cache in oracle
  311. Upsert operation
  312. Update
  313. Update Query for Object Table
  314. backwards LIKE matching
  315. backwards LIKE matching
  316. Procedure Vs Function
  317. Views and performance
  318. Oracle DBA Studio help
  319. Mark Burris
  320. Mark Burris
  321. Steps to install oracle9i on suse 10,Mandrake 10,fedoracore 4
  322. Check constraint
  323. oracle ocp exams guide ?
  324. Regarding UTL_FILE Package in PLSQL
  325. Installing on Mac Os
  326. current sql
  327. Oracle Standby databse
  328. reading oracle schema(structure)...
  329. converting date field to timestamp or viceversa....
  330. Difference between Varchar and nvarchar
  331. Oracle Performance on multiple joins
  332. update and insert
  333. oracle 11i installation
  334. Oracle guides for exams
  335. Oracle-triggers
  336. Logon info
  337. HOW ORACLE 9i WORK WITH XP?
  338. domain knowledge
  339. Oracle Not Available
  340. Oracle-update table values
  341. how to get present time and date???please its urgent
  342. How to diagnose inaproppriate Oracle SGA component size?
  343. db link hangs after a while
  344. ORA-12560: TNS: protocol Adapter Error
  345. conversion functions
  346. server configuration
  347. RAC nodes regularly freezes for about 10 seconds
  348. How to create external table with CLOB columns?
  349. How 2 split priority, reports low, transactions fast
  350. 7.3 on 03 server
  351. Determine record number in oracle forms
  352. to find scripts - 'export info party(customer)'
  353. Certification
  354. Missing iamodapp.so ( Oracle 9.20 /Linux)
  355. SELECT ... WHERE column LIKE parameter||'%'
  356. updating a table using other table values
  357. Help for Backup Online
  358. Does Oracle Apllication server is free?
  359. abt mapping table????in migration data
  360. TEMP tablespace
  361. oracle 9i username & password
  362. Oracle PL/SQL question
  363. Oracle lite
  364. Ora-12560
  365. Accpac 5.4 oracle10g connection.
  366. SQL NET Configuration issue
  367. Web Application using Oracle Forms 9i
  368. Trying to write a view using union statement
  369. OBE-15952 Error
  370. Insert
  371. How can i Install Developer6i with Oracle8i?
  372. Oracle dblinks
  373. ENOVIA/ MULTIPLE OPENINGS/ NO RELO REQUIRED
  374. IBYKUS Omega9 - New Oracle SQL Developertool
  375. ora-01031 insufficient priviledge
  376. External Tables w/ non ASCII chars
  377. convert sql mysql to oracle
  378. oracle object relatedquery
  379. history
  380. load from file doc into table
  381. Trigger to reflect changes
  382. How to set the server of oracle automatically shutdown
  383. Handling expired passwords in Forms v.6.0.5
  384. list box
  385. PL/SQL - Can function have OUT, IN OUT parameter ?
  386. OCI.dll not found !
  387. chem draw structure in orcale
  388. Need some guidance on my situation
  389. Performance Related Clarification.
  390. Oracle CBT
  391. rman
  392. Database configuration Error
  393. import testcases from xls document to Oracle DB
  394. Really REALLY simple question (I think)
  395. Which database design tool
  396. .NET using ODP and the 10g Instant Client
  397. Copy Oracle / Apps installations
  398. Oracle Schema
  399. converting comma separated values into rows in oracle
  400. ORA-00937 not a single group group function
  401. Oracle Group Group error
  402. Access to Oracle Insert solutions
  403. Need help with attendance project in oracle9i
  404. Autogenerate partitions on table
  405. SQL 3 or 4 trial key needed
  406. UNIQUE CONSTRAINT ERROR
  407. Basic Questions
  408. Catching "ORU-10027: buffer overflow" exceptions in PL/SQL
  409. OLEDB and Oracle XE ?
  410. Patience for a Oracle Noobie
  411. How to connect to Oracle database from unix prompt
  412. Procedure
  413. Slow query on date field via views
  414. Complex update query
  415. Crystal report db problem
  416. current sql running
  417. .NET Reporting against and Orcale Database
  418. <REQ> oracle lite info
  419. S: Biomega Mark Newson MN03
  420. Obtaining a Column Which has MAX in Another
  421. CPU skyrockets during contention
  422. writing records while doing select.
  423. Oracle credential retrievial failed error
  424. SQL Update Tables
  425. Multi Master Databases
  426. Constraints on the time stamp column or date
  427. Oracle DB Link issues
  428. spool file: saing to non default location
  429. Mercury ITG developer wanted (nashville, tn)
  430. Request for Resume's - Siebel Production Engineer IV
  431. deducing ranges in SQL
  432. Oracle OLEDb
  433. What is it like to work with Oracle?
  434. Loading Data from SQL-SERVER 2000 To ORACLE 9i
  435. Equivalent of Hierarchy SQL in Oracle
  436. Equivalent of Hierarchy SQL in Oracle
  437. Explain Plan returns only one index usage
  438. Great Job Board
  439. A great onestop spot
  440. Best Job Search Site...
  441. ASP - Reading blob from Oracle to ASP
  442. Generating CREATE TABLE statements
  443. Several question about select.
  444. Oracle 9.2 - c precompile undefined _sqlcxt
  445. c/Oracle on windows-undefines sqlcxt
  446. Instantclient 10 on Solaris 10
  447. Suggest books for beginner, and good as a reference for later use
  448. Remove all tables for user with one SQl statement?
  449. validation testing -- use TPC-C? (or what?)
  450. Oracle Forms - chat tool
  451. Need Media recovery Help
  452. US-VA: Sr.Oracle ATS/Testing LoadRunner QuickTest Pro # 1129R1
  453. Type for COUNT() as VAR ?
  454. Using FORALL with associative arrays
  455. Oracle Driver question
  456. INSTR and string length problem
  457. how to connect to an oracle database from a java source
  458. Oracle MERGE Statement Error
  459. Oracle 8i defrag
  460. Oracle Application Server webcached leaking file handles
  461. Connecting mobile application to database
  462. Empty string behaviour...
  463. Upgrade from 10.1 to 10.2
  464. Oracle data unload into DB2
  465. Oracle Rac
  466. Sqlplus (set verify command)
  467. SQL re-parsing on query executed against a remote database usingdatabase links
  468. Questions regarding materialized view logs ...
  469. help!...Call Oracle Store Procedure in a Package
  470. Wanted:Oracle Portal Course Material
  471. BLOB from Oracle
  472. Joins vs nested selects
  473. Oracle and Postgre SQL Help
  474. Virtual Indexes
  475. question about internal
  476. Inpersonate a user
  477. I cannot install emca anymore on oradb10g which runs o.k. after upgrade mac osX 10.4.2
  478. Question about init file
  479. Binding an array to an input variable in OCI
  480. Very basic question
  481. Oracle Vs. Ms Sql: Comparing Date To Variable
  482. Help needed to connect DB2k on PC to v7.3 on VMS
  483. SELECTing multiple rows to a single output line
  484. Oracle 10G RAC stability problems
  485. whether timestamp types are supported in oracle dynamic sql?
  486. oracle designer-timestamp-date
  487. PowerPoint Slides Available for Intro & Advanced DB Course
  488. Mysterious 9.2.0.4 (on HP-UX) problem
  489. PL/SQL Object Question
  490. Help with JDBC
  491. ff
  492. why to migrate from infromix to oracle
  493. How to do UPDATE with GROUP BY
  494. Oracle 7.3 v 9.2 client connection problems
  495. ORA 7.3 v 9.2 client conneection problems
  496. "No size set for variable length data" Oracle update error with empty string in .NET
  497. tnsnames.ora
  498. XML Batch Processing (large files)
  499. with clause for subquery factoring
  500. UTL_FILE(HELP)
  501. DW + Oracle: see tbls w/ recordset but not insert
  502. Rules Engine
  503. Convert timestamp to date
  504. Changing db_block_size
  505. Oracle Reports JDBCPDS
  506. Great News Blog!
  507. Which Operation of the Complex SQL is doing full table scan
  508. Fast bulk load with API?
  509. Is it possible to delete parts of a table without using rollback??
  510. Help needed for Database Replication
  511. Why you don't usually get answers here ...
  512. Why you don't usually get answers here ...
  513. SQL - Select and filtering whereby a date is not null.
  514. Forms Builder speed
  515. Performance difference between Windows and Solaris 10g
  516. Sequence Error ORA-02287
  517. Order By Performance Problem on View
  518. How to build database to support user-specified entities and attributes?
  519. Pivot query in oracle- Please help!!
  520. Pivot query in oracle- Please help!!
  521. Read Text file into Oracle Reports
  522. OCI library for Oracle 8.1.7.4.0 on OpenVMS
  523. Follow up to previous post
  524. SQL Query
  525. AVG and SUM in subquery return wrong values
  526. Invalid attribute/identifier error
  527. XML joining Nested resultsets
  528. How to build database to support user-specified attributes?
  529. port/protocol for sqlplus connectivity
  530. Problems: Oracle 9 Installation and Windows XP SP2
  531. Oracle 9 Installation Problems under Windows XP SP2
  532. install oracle 8.1.7 and developer 6i under same oracle home.
  533. Installing Oracle on Linux Redhat
  534. Converting a bare number to an interval and back
  535. ORA-29531 - And the method is declared both PUBLIC and STATIC
  536. External SQL functions exported by DLLs
  537. How to debug .pc file instead of debug generated .c file?
  538. PL SQL Cursor beginner
  539. Aarrrgh - this is NOT the place to ask!!
  540. Flashback over database link
  541. Pro*c for Windows
  542. how to do dbms_application_info.set_module from JDBC code
  543. Pro*c for Windows
  544. SQL - Date Math question
  545. Sample database with SQL triggers
  546. Open help file through forms 6
  547. Oracle Software Updates fees
  548. PL/SQL Examples
  549. Calling an Oracle stored procedure
  550. Export of data