View Full Version : oracle answers

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

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