|
|
Browse by Tags
- 10g
- 11g
- Access
- exams
- http://www.edens-gate.com
- Internet Explorer 6
- na
- ORA-06512: at line 1
- oracel regular expression regexp_replace
- oracle
- oracle 10g
- oracle 9i
- PL SQL
- Row 1: ORA-04098: trigger 'KITS.UPDATE_NAMES' is invalid and failed re-validation
- Speeding up a simple UPDATE in Oracle SQL
- sql
-
Speeding up a simple UPDATE in Oracle SQL
Hi I am using the following ORACLE SQL Code to update one row in a database UPDATE MARKET_VOLATILITY_SURFACE SET C = 12.875, P = 18.775, CB=11.5, CA= 14.25, PB= 18.15, PA = 19.4 WHERE TRUNC(MDATE) = trunc(TO_Date( '06/06/2010 12:00:40 AM', 'MM/DD/YYYY HH:MI:SS AM')) AND BS=6 AND CT =... -
Using LIKE operator in BETWEEN <> and <>
Hello All, I have to display the list of areas between whose area codes are in between. Say, area code is like '%HYD%' for all Hyderabad related codes and another is like '%SEC%' for all Secunderabad related codes. How do I write the condition in where clause using between. Say, AND ffv... -
Select min date in criteria
Hello experts! I have a problem here, which is like the following: I have a main table holding ifno about an area. Another table contains dates. Both tables have a 1 to n relationship. The dates may range from 2009 - 2015. In my application I have a combobox in order to select the start date for some... -
Oracle parallel not working, why ?
I have a parallel hint but it seems to be ignored. here's the statement: delete /*+ parallel(cc,4) */ ODS.CLM_DETAIL cc where CLAIM_SEQNO between 190000000000000 and 190999999999999 In (Pl*Sql Developer) sessions window, I don't see the "parallel" sessions like I see for other parallel... -
Oracle query syntax update multiple records with subquery
Hi I have the following table x and want to update each record in table x with the results of a query from table y. Is this possible without an external script? Table x timestamp, order_id, item_code, max_sale, ext_sale 2009-08-25 09:45:50.223, sdfjn232, sox, , 2009-08-23 09:50:00.225, sdggy4g, shoes... -
How to check for duplicate records in a table?
I have a table S with the columns a, b, c, d, e and counter which are all part of the primary key. However, I believe that the counter column is redundant and does not need to belong in the primary key because columns a, b, c, d, and e should be sufficient to avoid duplicate records. How do I write a... -
invaild month or date format end before converting entire input string
Hi all , i have to convert following char data into date format in *DD-MON-RRRR HH24:MI*. The data is *(mm/dd/rrrr hh:mi:ss PM)* 8/11/2009 12:12:39 PM 8/8/2009 12:12:39 PM 11/8/2009 6:12:39 PM 11/8/2009 6:8:4 PM etc when i apply to_date on these types of data then it gaves following errors invaild month... -
Is there any function in oracle sql which works similar to occurs in foxpro ?
Is there any function in oracle sql which works similar to occurs in foxpro ? Code Snippet: 1: Is there any function in oracle sql which works similar to occurs in foxpro ? Open in New Window Select All -
1Z0-047 vs. 1Z0-051 vs. 1Z0-007 - Which One is Good?
1Z0-007 and 1Z0-051 exam topics are easier than 1Z0-047. However, 1Z0-051 is a new one Oracle Database 11g: SQL Fundamentals I. Source: http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=155 Any help will be appreciated -
Addinf new column in table with primary Key as constraints.
How do i add new column into the table.new column will be primary key.