oracle9i
problem in creating GUI for upload & download file by Oracle forms
I want to create a GUI in Oracle form 10g, the purpose of creating this page is : -user able to upload & see uploaded file(upload into ftp)[详细]
2023-02-12 14:15 分类:问答Insert select continue with error
I have some s开发者_StackOverflow社区ql scripts which use INSERT INTO secondtable (field, field1)[详细]
2023-02-09 07:20 分类:问答SQL Statement - Query a set of records with the most recent date
I\'m writing a View in Oracle 9 database, and I\'m stumped.What I\'m trying to solve is this: A_WPD_ADDRESS_HISTORY contains a FK called WPD_PLAN_CHECK_S, and this view holds multiple addresses for th[详细]
2023-02-08 14:09 分类:问答Updating board in oracle form
Is there anything like thread in Oracle forms for updating one part? I want to create a message box and update that part with the new events, so I need开发者_StackOverflow社区 to have something like t[详细]
2023-02-08 02:40 分类:问答Is view faster than a natural join in Oracle? what about postgresql?
S开发者_如何转开发ELECT cec.* FROM mam.category cec SELECT cec.year, ces.* FROM mam.subcategory ces[详细]
2023-02-05 16:05 分类:问答how using FTP service in Oracle form!
I am using Oracle forms for my application. I would like to copy one directory from my local computer to a ftp address.[详细]
2023-02-05 01:27 分类:问答Ibatis+Oracle: How to update a float value
I\'m trying to update a float value in oracle database, but the saved value is only the integer part of the 开发者_运维百科float value.[详细]
2023-01-21 06:28 分类:问答How do we optimize oracle database?
We have a Oracle 9i Database with 7 tables each with 15+ Million records. There is no relation between the table i.e. no foreign keys.[详细]
2023-01-20 14:20 分类:问答Timezone offsets in oracle
Using Oracle 9.2i I need to get the offset of various dates from one timezones in r开发者_如何转开发elation to another timezone, previously I did this as such[详细]
2023-01-19 23:23 分类:问答How to remove more than one space in Oracle
I have an Oracle table which contains data like \'Shiv------Shukla\' (consider \'-\' as space). Now I need to write a program which leaves just one space and removes all other spaces.[详细]
2023-01-19 11:58 分类:问答