Home : Bytes IT Community / View Full Version : Oracle Forum


Pages : [1] 2 3 4 5 6

  1. Problem in Materialized view
  2. mutating
  3. Error (C++ does not support `long long' ) while compiling ORATYPES.H
  4. problem to disable a perticular item in oracle forms
  5. open form with parameters
  6. Hanging of select statements/Forms & Procedures
  7. Archiving the data
  8. SQL : nth highest salary from emp table
  9. 10 g Installation problem
  10. Normalization
  11. connection string
  12. Selecting Max Daterecord from Many Records
  13. Sshr-ame
  14. oracle10g production license
  15. important sites
  16. Adding primary constraint on a table if you have duplicated records already .
  17. Running two applications at the same time , having common components
  18. Maximum number of Columns
  19. SWITCH error
  20. DeCode in Column List
  21. Siebel Calendar Issue.
  22. Oracle Installation
  23. where to use ref cursor ?
  24. knowing jusT the lasT row
  25. how to do a realtimeproject
  26. how to connect 9i to 10g forms
  27. Display a field in margin of Oracle Report only on page 1
  28. Hi friends........
  29. simple SQL ELSE IF statement help
  30. insert into primary froeigon key relationship
  31. Connection String for Remote Server
  32. reg hyperlink in oracle report built by oracle reports builder
  33. Sql Plus Utility
  34. Parameter in Discoverer
  35. How to specify person type in table creation
  36. how to create a txt file from PL/SQL procedure
  37. using a join and field concatenation
  38. Exporting whole database from oracle 9.0 to 9.2 (windows)
  39. network adapter
  40. connect database
  41. Update statment with Exists and inner join, need tuning or alternative
  42. TNS Writter Failure
  43. How to increment more than one or to some othe rnumber with Oracle for loop
  44. Export Database tables to a dump file under windows
  45. Use variables in several different places in a big SELECT query
  46. long sql query
  47. Comma seperated column
  48. To check space in varchar2 column
  49. Pro*C vs Oracle Java Stored Procedure
  50. Query Tuning for a single select statement
  51. Restore the database backup in Oracle9i
  52. how to update columns in oracle forms
  53. Improper result from query
  54. Loading Multiple CSV Files into Oracle DB
  55. FRM -41039: Invalid alert ID 0
  56. error 00214
  57. oracle error
  58. oracle 9i reports
  59. how to declare a global variable in report builder?
  60. Call Javacode from Pl/SQL
  61. case when gone wrong
  62. Workflow
  63. how to change search conditions dynamically in where clause using pl/sql
  64. SELECT WHERE SettingKey = N'Logon' FAILS
  65. insert into a table with selected columns.
  66. Oracle does not exist and shared memory realm does not exist error
  67. VBA Oracle DB Connection String
  68. can anyone pls help me to join tis 2 query statement
  69. How to add a sum up column to a table
  70. ORA-27101 problem
  71. Loading Excel File into Oracle Table
  72. How to drop and then create a table during runtime in oracle9i
  73. Nested Cursor
  74. Sequence.nextval incrementing itself over time
  75. Not able to open test.fmx in oracle application server 10gR2
  76. oracle report 6i
  77. Bulk Import of Data into an Oracle Database
  78. Loading XML data to Oracle Database
  79. Joining of 2 SQL queries
  80. how to compare two columns and return the value which is not matched
  81. Mutation of triggers
  82. Traversing a tree - using a little recursion in SQL
  83. how to get colunms displacement for a table in Oracle?
  84. i'm trying to load data from uploaded file in php by using sql loader
  85. error questions
  86. How to connect oracle 9i database & developer suite ?
  87. how to use a list item in oracle forums
  88. rowid
  89. how to enter only time in the field of table and sum the time
  90. Query
  91. Equivalent to SQL Server Integration Services
  92. Drop by to ask for help
  93. how to execute query without having to declare schema all the time
  94. File Dis51usr.ini Of Oracle Discoverer 10g
  95. i'm having trouble in defining primary key... HELP ME guySSSS
  96. Arbitrary order in SQL query
  97. load data
  98. oracle sql
  99. How i can use "IN CLUASE" with block fields.
  100. Add Field To parameter form
  101. Best practice for inserting many to many records
  102. dynamic :NEW
  103. How to recreate Foreign Key constraint
  104. Multiple Counts in 1 query
  105. RecordSet inside procedure
  106. What is a dblink ?
  107. orace 6.0 designer
  108. like %
  109. Connection pooling
  110. import .lst files
  111. I got a error when i am establish the connection between oracle and sql server
  112. SQL Select statement as a keyword search
  113. Iterative function in sql
  114. Table Output
  115. Oracle XML and XPath
  116. REFCURSORS over dblinks
  117. oracle error 10034
  118. Sql
  119. Oracle reports 6i and asp.net
  120. Report 10g Vs Discoveror
  121. Query Takes time to execute
  122. Generate DDL of Schema
  123. Easy question from MS SQL to ORACLE
  124. Integration of two databases into one Database
  125. Maximum size of Linesize
  126. grant access to remote user
  127. ORA-01004: default username feature not supported; logon denied
  128. External Table Query runs in PL/SQL but fails in perl script
  129. File too large..
  130. question
  131. deleting data
  132. DataBase is not Connected through Application
  133. Oracle Parameter not getting value
  134. help with PL/SQL (ORA-06502 & PLS-00204)
  135. DLOOKUP function
  136. How to execute trigger instead of view while changes are done on a field in the table
  137. copy access tables to oracle
  138. Need to connect oracle database using Unix script
  139. Need a unix script to do match two files
  140. ORACLE10: Rename column that has keyword name
  141. ORA-03113 : end-of-file on communication channel
  142. Need help with append and delete duplicates
  143. How to run & view the out put of procedures in SQL:\>
  144. Oracle 9i Installation problem
  145. Informatica Licence Key-
  146. Oracle Apps
  147. How to bring up Enterprise Manager Oracle 10g
  148. Count(*) and performance
  149. Regarding tablespace issues
  150. how to change the password for sys schema?
  151. TOADS Explain plan
  152. Reg AOL
  153. Single sign-on configuration assistant failed during App Server install
  154. Update the first x of the records returned
  155. Encryption
  156. new feature in oracle 9i
  157. Run sql statement through batch file
  158. Using Collections in PL/SQL
  159. Refreshing or recreating a materialized view
  160. New to Oracle Help me out....
  161. Load Xml in oracle (SQL LOADER)
  162. Query too long
  163. Number Formatting
  164. New to Oracle
  165. Command hangs and doesn't end.
  166. SQL statement to store and retrieve 2byte letters like Japanese characters
  167. Oracle Reports 6i Download link
  168. Convert Oracle to SQL
  169. min function
  170. Timed Out Error in Oracle.
  171. What's the best way to load a PDF file into an oracle table?
  172. Top N results
  173. Prblems with DataSet Fill
  174. Duplicate Records
  175. E-Book
  176. Connection error from em oracle10g
  177. REG Oracle Discoverer
  178. trigger compilation errror
  179. Get Top 10 records
  180. decode question
  181. Assign field value based on date range of another variable in another table
  182. Regarding ORACLE
  183. FTP Batch file
  184. Data cloning in oracle 10g
  185. Retrieving the Nth record from a one-to-many subrelation table
  186. Can I commit portion of transaction in Oracle 9i?
  187. Back up or export Oracle Database Lite 10g syntax
  188. how to returning a recordset
  189. problem with connection
  190. Difference between Having & Where Clause
  191. How to connect to database????/
  192. login details
  193. Dates between the two given dates
  194. Data Dictionary Views
  195. Oracle transparent gateway in z/os
  196. Syntax error
  197. insert time only
  198. Tuning a stored procedure
  199. Regular expression in Oracle
  200. Creating Table in Oracle
  201. Calling Apex from Oracle Forms
  202. primary key
  203. date & time between
  204. Subqueries
  205. procedure and function
  206. countfunction
  207. Stored Procedure returning multiple values
  208. multiple row insert
  209. apps output in excel
  210. how to insert very large text into CLOB datafield?urgent.....
  211. SQL command not properly ended?
  212. Query Help
  213. Oracle 9i driver
  214. OrderBy question
  215. Oracle Reports
  216. Report not running in web layout
  217. flush shared pool
  218. Adding minutes to a date field
  219. The same signature of Stored procedure
  220. Failed to load the following object in oracle forms
  221. urgent help needed regarding arrays insertion
  222. Displaying specific data from the database
  223. Spooling more than one file
  224. count(*)
  225. no data found error in an "execute immediate" statement
  226. Creating Customer Address
  227. inser the row
  228. Concat used by optimizer in where clause
  229. Date conversion problem
  230. sql query tuning
  231. LIKE Operator
  232. It's urgent (Oracle running slow)
  233. PLS-00201 error from PHP
  234. Calling a Stored Procedure via a trigger
  235. Lookups
  236. report error
  237. PL/SQL:PLS-00410 duplicate fields in RECORDTABLE or argument list are not permitted
  238. Cannot avoid duplicate results
  239. size of image file..
  240. Update and Insert trigger definition
  241. hi amit..newbie oracle help me please!!
  242. In correct date format
  243. ORA-00907-passing blank space inside a parenthisis pair
  244. Tracing users by after logon trigger
  245. Urgent Help Needed
  246. PL/SQL Trigger Restrictions
  247. autonomous trans with EXCEPTION fails - why?
  248. need to know about oracle
  249. Use Duration and booking date to stop bookings during this time
  250. procedure
  251. merge
  252. current user
  253. import a .dmp file
  254. Function..help!
  255. need some docs regarding Sql tunning
  256. How do i Optimize this Query
  257. inserting unixtime in database
  258. Counting Commented lines in code
  259. Listener error
  260. Creating A Text File
  261. How to restore the path variable to get OracleDevSuite working?
  262. How to Connect Forms using VPN / DSL
  263. help! i need a solution pleas..cn i use subquery..
  264. Ora-01092 Errror
  265. Need help on using analytical function
  266. Deduplication in 11g works only in alter/modify?
  267. To update a record using rowid in duplicate row.
  268. correlated subquery in oracle
  269. Problem in wirting data in Excel sheet using owa_util package
  270. Stored Procedure Coding Problem
  271. Rewrite query using bulk collect to improve performance
  272. how to write a query to make its execution time better .And the standards.
  273. latest row inserted
  274. how to see all the inserted rows of a particular date
  275. function
  276. Use Serial Port In Oracle
  277. Problem with inserting dates
  278. Access violation at address 00000364. Read of address 00000364
  279. trigger types
  280. Composite primary key
  281. Table type parameter to a procedure
  282. hetrogenious database connectivity error from oracle to sql server
  283. pl/sql coding problem
  284. Calling a Package
  285. resolve this sql query urgent
  286. hi for all
  287. RMAN Duplicate
  288. which oracle version and forms can install on xp2
  289. Copy all values of a column from one table to another
  290. Isnull Problem
  291. Connecting Oracle Forms and DB using VPN connection
  292. Current Opening Balance from the table AR_PAYMENT_SCHEDULES
  293. sql temt table error
  294. Updating a column based on value in another table
  295. Query to find all transactions for a particular user
  296. database is giving data block corruption
  297. Reliability & Efficiency of Database links for far located remote databases
  298. OWS-05101: Execution failed due to Oracle error -6564
  299. Basic oracle quries
  300. Select query for Ageing Report 30,60,90 days
  301. Data limit of Oracle for DataWarehouse application
  302. what is this exactly FND_CLIENT_INFO
  303. problem regarding retrieving image from database
  304. Dynamic sql generation using oracle 10g stored procedures
  305. select query is taking some time to return values
  306. Procedure Return two values
  307. My Stored proc is not able to fetch output in crystal reports
  308. Issue in invoking procedure
  309. B* tree
  310. Use a specific database & find it's tables.
  311. REG PO- INTERFACE in apps
  312. PL/SQL Trying to update a table through trigger on the same table
  313. change in sysdate
  314. how to run this coding
  315. converting Date to Date or Char
  316. Dependent CASE function of another CASE function in a SELECT statement
  317. Trapping system exceptions
  318. how to manipulate indexes?
  319. Oracle 10g r2 setup required
  320. ORA-00922 Missing or Invalid Option
  321. Inserting a record for every value from a query
  322. PL/SQL to Dynamic Method 2 conversion of 3 files (Convert.zip) Pro*COBOL Oracle 10g
  323. Loading unloading data oracle 10g tables
  324. Sizing Of Table
  325. join
  326. REG Conversions
  327. Dynamic Report parameter
  328. Unknown Query Engine error
  329. Oracle Dba
  330. Creating a TAPI Dial button in Oracle
  331. help optimizing transpose query
  332. problem with mutiple row insert in a table using pl/sql
  333. Proecdure/Function with conditional inputs
  334. how to insert data into tables from flat files.
  335. Looping over broken range
  336. Writing data to file using UTL_FILE package
  337. comparing string values
  338. Newbie Question about dynamic table name references
  339. Bulk Data insert excluding the duplicates
  340. Oracle 10g error
  341. Query required to display a row from table
  342. How to update column with data from other tables?
  343. Indexes not being used when using bind variables
  344. importing .dmp oracle 9i file in the database using Forms Developer
  345. basic doubt
  346. I need help below this Query Urgent Please help me..
  347. DBMS.OUTPUT Group Functions from a Cursor?
  348. project consultation
  349. oracle
  350. oracle jsp connectivity
  351. Oracle Report In Word ?
  352. replication: fails to replicate automatically have to manually refresh
  353. ORA:00933 sql command not properly ended
  354. ODBC to Oracle Question
  355. Create a flat file from a repeating table
  356. oracle payables
  357. account payables
  358. oracle financials
  359. Query to return single record from multiple like records
  360. Setting up Oracle ODBC Link
  361. Help
  362. non-duplicate data from 2 seperate tables help
  363. query
  364. in report formula trigger how we use the nvl function with date
  365. time conversion
  366. pro*c information
  367. how to connect vb and orcle database
  368. ASP.NET and Oracle
  369. Running asynchronous processes in Oracle
  370. Urgent Help Needed!
  371. problem with string concatenation in auto-incremented field
  372. Create database error.
  373. ORA-01843: not a valid month
  374. using clob
  375. Help with Complex Query
  376. Mutuation Trigger
  377. Can't Edit inithsodbc.ora in Notepad
  378. Stored procedure input...
  379. bulk collect and for all..........
  380. Creating trigger
  381. Why people recommend oracle rather access?
  382. Oracle Update Statement using Concatenate
  383. Oracle 10g and ASP under Encryption mode
  384. SQL query not using index and explain plan gives very high cost
  385. Difference in Time in SQL
  386. Report Error
  387. Data Import
  388. IN condition and variable
  389. specifying storage parameters
  390. How to transfer data from oracle dump file to Excel Sheet
  391. ORA-02068: severe error from ORAMVS
  392. a doubt in sql please help me
  393. port in linux
  394. problem regarding database and jsp
  395. Number of Weekends in a month
  396. Query to get number of saturdays in any month
  397. retieve the data
  398. Execution plan
  399. Regarding Forms Parameters
  400. CSV to Oracle table
  401. Oracle reports 6i blank lines in output
  402. [C#] Import data from one server to another
  403. Stroing xls in oracle
  404. Range by Partition
  405. DBlink to DBLink
  406. reg apps
  407. How to handle "select a,b where c=' 1 & 2' in a 'hard coded' odbc query
  408. SQL command not properly ended?
  409. Help Needed
  410. selecting records with "%"
  411. ORA-03113: end-of-file on communication channel
  412. Trigger with insert
  413. ORA-12560: TNS:protocol adapter error
  414. Query to get Primary and Foreing Key
  415. How to extract data from oracle using C??
  416. how to specify package body in toad
  417. SQL Query with Self Join
  418. Isnull Problem
  419. How to remove primary key from table ?
  420. Result set is forward array.but iwant reverse array
  421. Oracle Application Server
  422. Select a random time
  423. Logical and physical Structure
  424. Microsot Linked Server & Oracle10 Performance Issues
  425. Database Instance
  426. How to retrive value for 12 hours
  427. PLS-00306 .Getting Problems with OUT parameter
  428. Explanation needed
  429. Query in teradata taking long time
  430. materializd view
  431. How to retrinve the first top salary hoder
  432. script by last analyzed database
  433. Sub : Query to be tuned which uses a table hint /*+ USE_CONCAT */ in Oracle 10g.
  434. Frm-10095
  435. Selecting the Same Coloumn Twice
  436. how can select
  437. Using Oracle 10g with Oracle 8 drivers
  438. Difference
  439. Show in one line
  440. I Want Know How I Can Attach Bar Code Device With Oracle Form Bulider Using Developer
  441. Tuning SQL statements
  442. how to use join query
  443. How to insert an image into DataBase? and also retrieving
  444. Change Number
  445. Space constant
  446. send report by email
  447. Help with Trigger Updating same row?
  448. Problem with INT when creating a table.
  449. how to create running clock in oracle forms 6i
  450. Get weired table row reflections. How do I get rid of it?
  451. How to retrive odd number of rows in my table
  452. I want to learn Oracle
  453. Modification of the length of a field in a database
  454. oracle upgradation
  455. selecting duplicate record with one different field
  456. How to get business days between two dates?
  457. how to create control files
  458. let i am using varray in procedure .then how to call it.
  459. oracle reports
  460. Getting the table name which is using a sequence
  461. exceptional handling
  462. procedure????????
  463. how to display the retrieved data from database in a dropdown menu
  464. convert number to float
  465. Stored Procedure processing
  466. GUI tool for Oracle
  467. Connection Problem Oracle7.3 to Oracle8i
  468. convert from 0 to 1
  469. Illegal datatype equivalencing operation using Pro C compiler
  470. problem in writing a Query
  471. Need Help for the error "SQL command not properly ended"
  472. Top 10 salaries
  473. How to add $ sign to number data type?
  474. how do you display the name of a SQLPLUS script that is running
  475. connection with .net
  476. Import
  477. Credentially retrieval failed
  478. is it possible
  479. ORA-12500: error
  480. ORACLE FORMS 9i WITH MDI
  481. collection as out prameter
  482. help with pl/sql
  483. i am not getting correct return values :cp_4,plz help me
  484. data transfer
  485. connecting to oracle
  486. finding Difference in pl/sql
  487. upload text file to a database
  488. Plzzz help regarding this......
  489. SQLPlus SELECT Headers
  490. problem installing WITH ORACLE
  491. Read-only DBLink !
  492. Python and calling Oracle Procedures
  493. cursor error1
  494. ORA-00933:SQL command not properly ended
  495. SQL Math Function Help
  496. Heterogeneous Database connections - Oracle to SQL Server
  497. connect Oracle9i on Unix to MS Sql Server
  498. Updating Multile rows in a table
  499. Getting wrong error message when running a command
  500. Clarify Me
  501. error while creating database
  502. A trigger to output to a text file
  503. Concat variable to form Table name inside Select statement
  504. need explainantion about sql quries..
  505. Ora-01795
  506. recently inserted rows
  507. Looking for DBA who knows DATABASE XML
  508. Need help to start learning oracle
  509. ORA-07445: exception encountered: core dump
  510. Pipe delimitating function
  511. configuration for *isql
  512. calling Java from Oracle
  513. Oracle DBA
  514. Utl file
  515. Difference between PL/SQL table and Record Type
  516. problem installation
  517. can't install Oracle 8i Client
  518. Insert email into Oracle
  519. FRM-92100 on refresh data in a screen
  520. How to understand this query??
  521. How VB script will retrive the data from Oracle Database
  522. Getting Invalid user ID and Password before the applications starts
  523. Oracle Translation Hub - Using the Trados Glossary
  524. update two columns at time
  525. How to call oracle tables from MSDOS?
  526. How to move backwards
  527. oracle download
  528. otn for oracle 9i...
  529. server problem
  530. PS/SQL script needed to update and prompt user to commit or rollback
  531. Insert into a table with sequence and a value from other table
  532. help with dates
  533. Count of table column
  534. Finding the database culture
  535. Needed DB Query optomized?
  536. How can I use variable value as a table name?
  537. performance tuning in 10g
  538. Random Number Based on another Cell in Row
  539. import to oracle 9i
  540. Reference a package in a script
  541. schema designing
  542. finding a day that had maximum total amount..using sql
  543. regarding dynamic SQL
  544. regarding sql query
  545. reg Oracle Apps
  546. I want formatted output
  547. problem in importing a .dmp file
  548. Storing images in Oracle
  549. REG Layout In Report
  550. help with Perl code to insert a long string (> 32512 chars) via stored procedure