View Full Version : answers

Pages : 1 2 3 4 5 [6] 7 8 9 10 11 12 13 14
  1. REG PO- INTERFACE in apps
  2. PL/SQL Trying to update a table through trigger on the same table
  3. change in sysdate
  4. how to run this coding
  5. converting Date to Date or Char
  6. Dependent CASE function of another CASE function in a SELECT statement
  7. Trapping system exceptions
  8. how to manipulate indexes?
  9. Oracle 10g r2 setup required
  10. ORA-00922 Missing or Invalid Option
  11. Inserting a record for every value from a query
  12. PL/SQL to Dynamic Method 2 conversion of 3 files (Convert.zip) Pro*COBOL Oracle 10g
  13. Loading unloading data oracle 10g tables
  14. Sizing Of Table
  15. join
  16. REG Conversions
  17. Dynamic Report parameter
  18. Unknown Query Engine error
  19. Oracle Dba
  20. Creating a TAPI Dial button in Oracle
  21. help optimizing transpose query
  22. problem with mutiple row insert in a table using pl/sql
  23. Proecdure/Function with conditional inputs
  24. how to insert data into tables from flat files.
  25. Looping over broken range
  26. Writing data to file using UTL_FILE package
  27. comparing string values
  28. Newbie Question about dynamic table name references
  29. Bulk Data insert excluding the duplicates
  30. Oracle 10g error
  31. Query required to display a row from table
  32. How to update column with data from other tables?
  33. Indexes not being used when using bind variables
  34. importing .dmp oracle 9i file in the database using Forms Developer
  35. basic doubt
  36. I need help below this Query Urgent Please help me..
  37. DBMS.OUTPUT Group Functions from a Cursor?
  38. project consultation
  39. oracle
  40. oracle jsp connectivity
  41. Oracle Report In Word ?
  42. replication: fails to replicate automatically have to manually refresh
  43. ORA:00933 sql command not properly ended
  44. ODBC to Oracle Question
  45. Create a flat file from a repeating table
  46. oracle payables
  47. account payables
  48. oracle financials
  49. Query to return single record from multiple like records
  50. Setting up Oracle ODBC Link
  51. Help
  52. non-duplicate data from 2 seperate tables help
  53. query
  54. in report formula trigger how we use the nvl function with date
  55. time conversion
  56. pro*c information
  57. how to connect vb and orcle database
  58. ASP.NET and Oracle
  59. Running asynchronous processes in Oracle
  60. Urgent Help Needed!
  61. problem with string concatenation in auto-incremented field
  62. Create database error.
  63. ORA-01843: not a valid month
  64. using clob
  65. Help with Complex Query
  66. Mutuation Trigger
  67. Can't Edit inithsodbc.ora in Notepad
  68. Stored procedure input...
  69. bulk collect and for all..........
  70. Creating trigger
  71. Why people recommend oracle rather access?
  72. Oracle Update Statement using Concatenate
  73. Oracle 10g and ASP under Encryption mode
  74. SQL query not using index and explain plan gives very high cost
  75. Difference in Time in SQL
  76. Report Error
  77. Data Import
  78. IN condition and variable
  79. specifying storage parameters
  80. How to transfer data from oracle dump file to Excel Sheet
  81. ORA-02068: severe error from ORAMVS
  82. a doubt in sql please help me
  83. port in linux
  84. problem regarding database and jsp
  85. Number of Weekends in a month
  86. Query to get number of saturdays in any month
  87. retieve the data
  88. Execution plan
  89. Regarding Forms Parameters
  90. CSV to Oracle table
  91. Oracle reports 6i blank lines in output
  92. [C#] Import data from one server to another
  93. Stroing xls in oracle
  94. Range by Partition
  95. DBlink to DBLink
  96. reg apps
  97. How to handle "select a,b where c=' 1 & 2' in a 'hard coded' odbc query
  98. SQL command not properly ended?
  99. Help Needed
  100. selecting records with "%"
  101. ORA-03113: end-of-file on communication channel
  102. Trigger with insert
  103. ORA-12560: TNS:protocol adapter error
  104. Query to Get Primary and Foreing Key.
  105. Query to get Primary and Foreing Key
  106. How to extract data from oracle using C??
  107. how to specify package body in toad
  108. SQL Query with Self Join
  109. Isnull Problem
  110. How to remove primary key from table ?
  111. Result set is forward array.but iwant reverse array
  112. Oracle Application Server
  113. Select a random time
  114. Logical and physical Structure
  115. Microsot Linked Server & Oracle10 Performance Issues
  116. Database Instance
  117. How to retrive value for 12 hours
  118. PLS-00306 .Getting Problems with OUT parameter
  119. Explanation needed
  120. Query in teradata taking long time
  121. materializd view
  122. How to retrinve the first top salary hoder
  123. script by last analyzed database
  124. Sub : Query to be tuned which uses a table hint /*+ USE_CONCAT */ in Oracle 10g.
  125. Frm-10095
  126. Selecting the Same Coloumn Twice
  127. how can select
  128. Using Oracle 10g with Oracle 8 drivers
  129. Difference
  130. Show in one line
  131. I Want Know How I Can Attach Bar Code Device With Oracle Form Bulider Using Developer
  132. Tuning SQL statements
  133. how to use join query
  134. How to insert an image into DataBase? and also retrieving
  135. Change Number
  136. Space constant
  137. send report by email
  138. Help with Trigger Updating same row?
  139. Problem with INT when creating a table.
  140. how to create running clock in oracle forms 6i
  141. Get weired table row reflections. How do I get rid of it?
  142. How to retrive odd number of rows in my table
  143. I want to learn Oracle
  144. Modification of the length of a field in a database
  145. oracle upgradation
  146. selecting duplicate record with one different field
  147. How to get business days between two dates?
  148. how to create control files
  149. let i am using varray in procedure .then how to call it.
  150. oracle reports
  151. Getting the table name which is using a sequence
  152. exceptional handling
  153. procedure????????
  154. how to display the retrieved data from database in a dropdown menu
  155. convert number to float
  156. Stored Procedure processing
  157. GUI tool for Oracle
  158. Connection Problem Oracle7.3 to Oracle8i
  159. convert from 0 to 1
  160. Illegal datatype equivalencing operation using Pro C compiler
  161. problem in writing a Query
  162. Need Help for the error "SQL command not properly ended"
  163. Top 10 salaries
  164. How to add $ sign to number data type?
  165. how do you display the name of a SQLPLUS script that is running
  166. connection with .net
  167. Import
  168. Credentially retrieval failed
  169. is it possible
  170. ORA-12500: error
  171. ORACLE FORMS 9i WITH MDI
  172. collection as out prameter
  173. help with pl/sql
  174. i am not getting correct return values :cp_4,plz help me
  175. data transfer
  176. connecting to oracle
  177. finding Difference in pl/sql
  178. upload text file to a database
  179. Plzzz help regarding this......
  180. SQLPlus SELECT Headers
  181. problem installing WITH ORACLE
  182. Read-only DBLink !
  183. Python and calling Oracle Procedures
  184. cursor error1
  185. ORA-00933:SQL command not properly ended
  186. SQL Math Function Help
  187. Heterogeneous Database connections - Oracle to SQL Server
  188. connect Oracle9i on Unix to MS Sql Server
  189. Updating Multile rows in a table
  190. Getting wrong error message when running a command
  191. Clarify Me
  192. error while creating database
  193. A trigger to output to a text file
  194. Concat variable to form Table name inside Select statement
  195. need explainantion about sql quries..
  196. Ora-01795
  197. recently inserted rows
  198. Looking for DBA who knows DATABASE XML
  199. Need help to start learning oracle
  200. ORA-07445: exception encountered: core dump
  201. Pipe delimitating function
  202. configuration for *isql
  203. calling Java from Oracle
  204. Oracle DBA
  205. Utl file
  206. Difference between PL/SQL table and Record Type
  207. problem installation
  208. can't install Oracle 8i Client
  209. Insert email into Oracle
  210. FRM-92100 on refresh data in a screen
  211. How to understand this query??
  212. How VB script will retrive the data from Oracle Database
  213. Getting Invalid user ID and Password before the applications starts
  214. Oracle Translation Hub - Using the Trados Glossary
  215. update two columns at time
  216. How to call oracle tables from MSDOS?
  217. How to move backwards
  218. oracle download
  219. otn for oracle 9i...
  220. server problem
  221. PS/SQL script needed to update and prompt user to commit or rollback
  222. Insert into a table with sequence and a value from other table
  223. help with dates
  224. Count of table column
  225. Finding the database culture
  226. Needed DB Query optomized?
  227. How can I use variable value as a table name?
  228. performance tuning in 10g
  229. Random Number Based on another Cell in Row
  230. import to oracle 9i
  231. Reference a package in a script
  232. schema designing
  233. finding a day that had maximum total amount..using sql
  234. regarding dynamic SQL
  235. regarding sql query
  236. reg Oracle Apps
  237. I want formatted output
  238. problem in importing a .dmp file
  239. Storing images in Oracle
  240. REG Layout In Report
  241. help with Perl code to insert a long string (> 32512 chars) via stored procedure
  242. Augmenting a table sorted grouped by month to one grouped by day
  243. reg Reports
  244. Desing and Implement a Data warehouse in Oracle
  245. Frm-10095
  246. Query
  247. ORACLE 9i DATABASE
  248. Anyone has Oracle 7.3 client for Window XP
  249. Currency field with 2 decimal
  250. Pl/sql
  251. Triggers
  252. distinct BEHAVIOR
  253. problem with UTIL_FILE
  254. null data from bind variable on table insert
  255. ecryption of user-id/password to pass to sql loader
  256. how to insert data into different views through oracle forms
  257. Oracle possible to share schema between users
  258. Migrating From Access to Oracle
  259. Storing scanned documents in 10g
  260. how to view schedular by using oracle enterprise manager in 9i
  261. Performing fast search in huge oracle database
  262. Between operator
  263. instalation of dev 6i and oracle 9i: database connection problem
  264. Pl/sql
  265. Pl/sql
  266. Oracle Apps
  267. plz solve my query i have my exam on monday.
  268. First Function In Plsql
  269. oracle auto incerement
  270. Multiple rows insertion in single insert query.
  271. not null constraint
  272. How To See The Procedure Script In Sql Plus
  273. trigger error
  274. Unique Constraint Violation
  275. How to pass a variable from one form to another in Form 6i
  276. How to copy data from one table to another table with where condition
  277. one server with two different database
  278. ORA-01578: ORACLE data block corrupted
  279. Query Performance
  280. deletion issue
  281. Oracle Connect Error - Please Help - Urgent...
  282. Executing multiple scripts using UNIX command
  283. executing Process-flows manually from SQLPLUS
  284. Converting Rows into Columns without affecting the data in the table.
  285. disable system given name constraint
  286. Oracle is installed or not.... Urgent
  287. execute immediate problum
  288. plz solve this query as soon as possible
  289. Execution details in email notification
  290. Major differences between oracle 9iand 10g.
  291. Decimal data creation Number datatype
  292. ORA-29902 - ODCIndexstart() error for the word "about"
  293. how to use decode?case function in where clause
  294. Plz solve this query
  295. Partition Creation Automation -- Best Methods
  296. ' not in ' function syntax.
  297. Oracle Error -either eof or bof is true-connecting with vb thru adoddb
  298. Please solve this query
  299. Convert MSSQL syntax to Oracle - variable declaration
  300. Basic Oracle Connection Question
  301. views & indexs
  302. data base error
  303. analytical functions
  304. Missing right parenthesis
  305. fetchin limited number of records from resultset
  306. Ref Curser
  307. how to handle data beneath the tabular report in rep 6.0 when rep expand vertically
  308. Need to modify stored proc for crystal report. Important.
  309. Showing Database in Oracle
  310. indexing
  311. external table into Oracle8i
  312. Primary Key Constraint
  313. Jft
  314. bind variable
  315. query problum
  316. address query
  317. how to get the last row inserted into a table.
  318. INSTEAD OF trigger (FOR EACH ROW)
  319. bad bind variable trigger
  320. ALL and ANY
  321. Migrate oracle 8.0.6 hp ux database on oracle 9i linux
  322. inserting into table - object view
  323. how retrive table values from two oracle databases
  324. Connecting to oracle DB through UNIX
  325. Want to call oracle statement in client connection
  326. Please provide me a SQL script for the problem described below:
  327. IMP-00028: partial import of previous table rolled back
  328. How to retrive my data...
  329. oracle
  330. Oracle 9i Startup and Shutdown
  331. Adding parameters to a filter for a report
  332. oracle form
  333. Oracle(tm)client and networking components were not found
  334. Having a problem with the TO_DATE function in Oracle.
  335. inner join outer join query
  336. Create a new instance wif of a database
  337. ocp oracle developer
  338. Query Tuning...
  339. Creating Discoverer ELU's
  340. question
  341. Access to Oracle 9i
  342. Test script to test functions in a package
  343. varchar to_num catching exception as zero
  344. Need to know what are all the alerts enabled in my database.
  345. Working out 6 month prior to the first day of the month
  346. Data migration from SQL Server to Oracle + Identity Column
  347. oracle
  348. stored procedures out parameter
  349. Materialize View
  350. error PLS-00201:
  351. count
  352. Materialized Views in Oracle
  353. Join the result of two different queries
  354. Join the resul of two different queries
  355. Function contained in an Oracle Package
  356. Oracle 8i does not supports Common features
  357. ODBC vs Oracle PreCompiler
  358. Cerating Table In Procedure
  359. Help with COUNT Query :)
  360. Real time Data warehousing- Example
  361. 3 queries into 1
  362. query to convert column into rows in oracle9i
  363. Loop problem, Cursor could not read the next record
  364. problem with Spool ..
  365. How to Create a Table Name from a value in an Existing Table?
  366. Oracle Error-TNS no Listner in TOAD
  367. Multiple Pages
  368. Regarding Forms in D2k..
  369. Tally 7.2 with Oracle Databse
  370. need to compile a file
  371. oracle stored procedure
  372. Problem trying to write a PL/SQL routine that will generate a CREATE TABLE statement
  373. Equivalent of MS Access Sql (first or last function) in oracle9i
  374. SQL...duplicate data identification
  375. TNS Protocol Adapter Error
  376. Oracle 10 g Installation Problem
  377. Opening a Web Page Inside a 10g Form
  378. How to Insert the Special Copyright © Character in an Oracle Table
  379. problem in Order By
  380. How to continue processing if an error occur into plsql block
  381. SQL PRoblem with GROUP BY
  382. Oracle 9i forms developer
  383. integrity constraints problem
  384. what are wild cards incase of sql
  385. frm-92100:your connection to the server was interrupted.
  386. no output for to_date function
  387. ORA-06502: PL/SQL: numeric or value error
  388. copy data from fielld_1 (long ) to field_2(varchar
  389. Where V1 In (select Fun(1)
  390. Working of ROWNUM in Oracle
  391. Help -- Oracle Forms does not support multi-page TIFF.
  392. reg temp table
  393. Most preferred database
  394. Oracle database
  395. execute query for every month of beginning
  396. Adding a barcode field
  397. Aggregate query problem
  398. ORA-29740 in a RAC databases
  399. DBA in Linux and Windows
  400. Sub-Query returns more than one row
  401. nested tables
  402. SQL Case statement
  403. Cursor Error
  404. Why Oracle Counting is so slow?
  405. To change number format from floating point format
  406. connection between windows CE and oracle
  407. Connectivity
  408. Updating and Deleting data with one statement
  409. Oracle 8i and Developer 2000 on Win XP
  410. example of procedures.
  411. Sqlloder
  412. Fetching max in "Page 1 of max" in minimum Time
  413. forall operator
  414. My statment takes too long to run.
  415. reg apps
  416. how to combine multiple sql query into one
  417. Querying data between two datetimes from previous day
  418. isqlplus service randomly goes down
  419. DSN ERROR: ORA -1857 not a valid time zone
  420. utl_file
  421. Bulk copy in Oracle
  422. connecting developer 2000 to existing database
  423. spool data
  424. Oracle Reprots
  425. Please give your scripts
  426. Inserting Clobs In Java
  427. REPORTS 6i
  428. Oracle with window registry
  429. Recursion in PL/SQL
  430. exe plan
  431. C# Web Service in IIS Stops Connecting to Oracle (via ADO.NET) Over Time
  432. creating physical standby database
  433. message only
  434. specific user login
  435. there is a problem with oracle connectivity
  436. Assertion in SQL
  437. oracle
  438. Return ref cursor from oracle procedure
  439. Equivalent of Oracle's "TYPE" in PHP or PostgreSQL.
  440. exchange partition across databases
  441. Oracle database connectionstring problem
  442. reports 6i
  443. Difference between %type and %rowid
  444. Edit Record in DataBase Control Oracle 10g
  445. import .dmp file into oracle
  446. Storing the bill into tables
  447. Storing text fields with imbedded punctuation
  448. [07/11] Ora-7445 [kssadf_stage:1003[kss.c]] From Create Table As Select ...
  449. Creating global temporary table on join condition
  450. Queries in Oracle & SQl server.
  451. Auto load SQL on HTML
  452. Able to connect to oracle even with the old expired password
  453. What is @@ means
  454. must a foreign key be a primary key
  455. reg oracle reports
  456. cursor for loop returns o/p as cursor
  457. Lpad and Rpad?
  458. Rollback segment is full
  459. FRM-40922 An Ole error encountered:0x80040154
  460. Virtual Private Database
  461. Retrieve the table names and column names in perticuler schema
  462. problem in join statement
  463. oracle apps
  464. Help in oracle procedure
  465. MSSQL to Oracle Migration Performance issues
  466. Backup in Oracle10g
  467. Stored Procedures - Help
  468. Oracle 11g New Features
  469. Converting SQL to Relational Algebra
  470. trigger
  471. Facing problem in Oracle Report
  472. Inserting 8 lakh records using sqlloader
  473. Please let me know the query for this!
  474. Provide table name dynamically in query
  475. Identity Type in Oracle 10g
  476. SQLPlus substitute?
  477. Good Oracle tutorials - free
  478. How to store and retrieve an image in oracle using java
  479. difference between oracle 9i and 10g
  480. Copying Columns Between Tables
  481. Oracle Problems
  482. UTL_FILE inalid directory path
  483. For Oracle Sql plus
  484. how to tread the primary key and foreign key in fragmentation
  485. Creating Views on base of cursors in Oracle pl/sql
  486. Difference
  487. Bulk copy to text file in Oracle
  488. Rtrim cannot trim certain character
  489. Materialized views log are not getting purged after the completion of related fast re
  490. Oracle basic commands
  491. How can I include Xerces C++ 2.7.0 parser code to Oracle 10g R2 Pro*C's .pc
  492. Converting ip address in decimal to dot notation
  493. oracle connection string in vb.net 2003
  494. Simple Join Statement Help
  495. Urgent - 2147467259: [Microsoft] [ODBC driver for Oracle] [Oracle]
  496. Install Oracle 8i on Vista - Processor :Intel Core2 Duo
  497. Duplicate data
  498. Form Builder Error -ORA - 12154 TNS could not resolve service name.
  499. How to read Harddisk number
  500. Oracle Query - column group
  501. SQL query...decimals
  502. Oracle Error - ORA-04021
  503. spooling data to csv file
  504. init.ora file location.
  505. Difficult in database link
  506. Question on hotbackup for oracle
  507. Error using form designer (Developer 2000)
  508. Urgent : Help to convert string to date
  509. Create another instance from cold backup
  510. Viewing available databases with password and username
  511. Export and purge table
  512. stored procedure in oracle9i
  513. Executing a function declared in Oracle Package from Unix shell script:-
  514. Numbers and Nulls
  515. Count multiple items from the same column
  516. Materialized View in Oracle apps
  517. sql date format problem
  518. Help Needed in formatting output data !!
  519. reg data transfer
  520. stored procedures
  521. How to give privileges of one user to another
  522. schedular prob
  523. Oracle XMLTYPE datatype
  524. TAB delimited data and SQL*LOADER
  525. how to start a distributed database
  526. Cannot able to connect the oracle database
  527. Database Listener Problem
  528. Dblink
  529. Difference Between Oracle 9i And Oracle 10g
  530. Database link
  531. blockig error
  532. Why we used ROWNUM in group by clause
  533. Which one is used to better performance
  534. Export Oracle table data to text file !!
  535. Ora-00907...
  536. Oracle Developer Suite 10.1.2.0.2 installation on Fedora 5
  537. difference between installing oracle 10g R2 software on linux & solaris
  538. Connecting to the DB >> Assertion failed:
  539. backup of one table's data before deleteing its all data
  540. Error occured while saving connectiodefinition
  541. Error occured while saving connectiodefinition
  542. calling a stored procedure from a unix script
  543. user scripts
  544. 'DD-MON-YY' v. 'DD-MON-YYYY' question
  545. Convert LONG format to DATE or CHAR
  546. pl/sql using cursors.
  547. triggers
  548. How to retrieve single column values from table
  549. overview on installicatio oracle database stup
  550. Help urgent Oracle