View Full Version : oracle answers


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

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