background preloader

Software Downloads

Software Downloads
Developers: All software downloads are free, and most come with a Developer License that allows you to use full versions of the products at no charge while developing and prototyping your applications, or for strictly self-educational purposes. (Unless otherwise specified, our technical support organization will not provide technical support, phone support, or updates to you for the programs licensed under this agreement.) You can buy products with full-use licenses at any time from the online Store or from your sales representative. Want to take a virtualized test drive?

Toad World Oracle DBA and Apps DBA blog Top 10 Secret Agent Security Tips and Tricks When dealing with computer security, an often overlooked security risk is so-called "deleted files". When files are deleted, nothing is actually done to them aside from marking them as "free-space". The OS may get around to overwriting them sometime when it needs the space, but a deleted file could sit on a drive completely intact for weeks of usage (the bigger it is the bigger the chance it will be at least partially overwrited). Encryption applications that do not involve real-time decoding (a special driver decrypting files on-the-go vs an application decrypting and re-encrypting files), often do not have secure methods of wiping files (or the user is unaware of them), and hence the files are left in an unencrypted state on the drive when deleted. The only way to assure deleted files remain that way (or at least make their recovery very difficult and time-consuming) is to have an application overwrite the drives free-space with random 0s/1s, ideally multiple times.

DB2 9.7: Исполнение Oracle-приложений на DB2 9.7 для Linux, UNIX и Windows Преследуемые цели В марте, во время посвященной DB2 9.7 презентации на выставке Cebit, я сжег компьютерный динамик на 110 В, который неосмотрительно подключил без трансформатора к немецкой сети 230 В. В той же командировке я точно так же испортил зарядное устройство своей электрической зубной щетки и машинки для стрижки бороды. Оставляя в стороне мою очевидную неспособность учиться на собственных ошибках, неудивительно, что одно из моих любимых высказываний (происхождение неизвестно): "Проблема стандартов в том, что их слишком много". В мире реляционных систем управления базами данных (СУБД) мы облагодетельствованы по крайней мере тремя основными стандартами и бесчисленным количеством их вариаций: ANSI SQL и ANSI SQL/PSMOracle SQL и PL/SQLSybase и Microsoft TSQL На рисунке 1 приведена диаграмма Венна, иллюстрирующая перекрытие диалектов SQL. Рисунок 1. Всякий раз при написании приложения приходится выбирать, СУБД какого поставщика использовать. В начало Все эти шаги были предприняты в DB2.

Fusion Middleware 11g Software Downloads The Quick Installer offers full Java EE 7 development, and includes Oracle WebLogic Server and Oracle Coherence. The generic installer also includes Oracle WebLogic Server and Oracle Coherence and adds examples and console help files. The Fusion Middleware Infrastructure installer adds Fusion Middleware Control and Java Required Files (JRF) for managing Multitenant domains with multiple partitions. (Note: Licensed customers should obtain their Oracle WebLogic Server 12cR2 software here.) For other Oracle WebLogic Server releases subject to this free license, including 12.2.1.2, 12.2.1.1, 12.2.1, 12.1.3, and 10.3.6 for Oracle Fusion Middleware 11g products: Oracle JDeveloper is a free integrated development environment that simplifies the development of Java-based SOA and Java EE applications. For Oracle Fusion Middleware 11g and 12c downloads please see the product specific download pages. Oracle WebLogic Server Installers.

Jaffar Oracle blog Free Customized Business Plans for Small Business and Entrepreneurs at Enloop.com Tuning PGA Memory by Sreeram Surapaneni Oracle is becoming one of the most flexible and sophisticated database management systems. Its ability to provide performance views for memory management components of the database is an invaluable tool especially for managing DSS systems. When an Oracle process requires an operation, such as a sort , hash join or group by it goes to the shared tunable memory area within pga_aggregate_target region and attempts to obtain enough contiguous memory structures to perform the operation. To illustrate this consider the following queries column name format a40 column value format 999,999,999 select name, value from v$pgastat; The result of the query might look like the following: Important parameter to look at in the above output is the value of aggregate PGA auto target, which represents shared tunable part of PGA memory and it should not be small compared to the value of PGA_AGGREGATE_TARGET. Notes: To substantiate this consider the following query: Output:

Oracle Scratchpad How to Get Started With Google+, Your Complete Guide By now, you have all probably heard about the Google+ project , Google’s next attempt at making their network more social. Its goal is to make sharing online more like sharing in real life. If you haven’t gotten your invite just yet, you can in the following quick-look video, and by visiting the Google+ project overview , searchable details and discussion pages. You can also take a demo tour so you can once you are able to join the project. Limited Field Trial Invites If you’re one of the lucky ones, you received an invite for Google+ during their limited field trial. Here is an example email invite to Google+. Whenever you click on the button, you’re taken to the invite screen for Google+. Join Google+ when someone sends you an invite. Two things to note when joining “Things may not always work as intended. There is also a checkbox that says “Google may use my information to personalize content and ads on non-Google websites.” The Welcome Screen Creating Your Profile Adding Connections

MapInfo connecting to an Oracle Spatial dissemination database — NTLIS Collaboration Forum Outlines how to connect to an Oracle Spatial databases with MapInfo. Important for NT Government staff due to the fact that a large number of NTG spatial datasets are now available in Oracle dissemination databases. Note this document is relevant to NT Goverment users, direct connection to the databases is not available outside of the NTG network. Introduction NTLIS encourages all government users of MapInfo to connect directly to our Spatial Dissemination Databases for read-only layers such as cadastre, roads, boundaries, bores etc. Note this document is only relevant to NT Goverment users, as direct connection to the dissemination databases is not available outside of the NTG network. Configuring your machine for Oracle connectivity Before you connect to oracle using any application (FME, MapInfo etc) you will need to: install the Oracle Client, preferably the Oracle Instant Client (eg. 10.x., 11g)setup the client by building your TNSNAMES.ORA file. To make a new DBMS connection: 1. 2. 3.

Kevin Closson’s Oracle Blog: Platform, Storage & Clustering Topi The Very Best Web Designs Of 2010 Subscribe D-Lists Design + Developer Resource Facebook Fan Page CategoriesArchives The Very Best Web Designs Of 2010 This is a little bit later than some other year reviews but I just had to compile this list for you. I have been through every single Weekly Web Inspiration from 2010 and picked my favourite from each. What are you expecting from 2011? Fitbit The Croquis Cog’aoke Blissfully Aware Gingerbread Construction Company Acosmin Creanto Black Harbor Urban Airship Bingo Reviewer Shaun Inman United Pixelworkers dConstruct 2010 Simon Corry Digitallabs Yanis Markin A Modern Eden Mealeo Awesome Simone Maranzana fflick Brand New Conference Amazee Labs Courier Dropr Old Pulteney Threadbird Glitch Firefox Tweet Machine Lewro Damn Good WP Bundle Mark Hobbs DrupalCon If you like this post you may also want to look at: The Very Best Web Designs Of 2009

Том Кайт: об удалении дубликатов и порядке срабатывания триггеров 2007 г. Источник: журнал Oracle Magazine, March-April 2006 ( Том Кайт удаляет дубликаты, задает порядок срабатывания триггеров и объясняет, почему объектная привилегия SELECT разрешает блокирование. Вопрос. Ответ. А пока для удаления из таблицы дубликатов я могу использовать некоторые встроенные функции и аналитику. Используя аналитику, я буду разделять, разбивать, данные с помощью функций LEAST(SA,SB) и GREATEST(SA,SB). Этот SQL-код похож на показанный в листинге 1. SQL> delete from t 2 where rowid in 3 ( select rid 4 from ( 5 select rowid rid, sa, sb, 6 row_number() over 7 (partition by least(sa,sb), 8 greatest(sa,sb) order by sa, sb) rn 9 from t 10 ) 11 where rn <> 1 12 ) 13 / 3 rows deleted. Листинг 1. На будущее я рекомендую вам изначально предотвращать в системе ввод дубликатов. SQL> alter table t 2 add constraint sa_less_than_equal_sb 3 check (sa <= sb); Table altered. Порядок срабатывания триггеров Вопрос. Ответ.

Related: