Monthly Archives: settembre 2013

Oracle glossary: in, not in
  • 30
    Set

Oracle glossary: in, not in

In and not in are conditions. Useful for tests one or more values for membership(or not) in a list of values or subquery Some example: select * from table where col1 in (23, 45, 342) -- where values of col1 match with 23, 45, 342 select * from table where col1 not in (23, 45, 342) -- where...

Read More
IIS 7.5  How to backup the metabase
  • 24
    Set

IIS 7.5 How to backup the metabase

Compared to version 6 of the Microsoft web server, in the new version  md(x) (Where x was a progressive number)  file is no longer generated during  backup.The file that is the metadata containing the structure of the web server (it can still be generated but it is not used as a backup/restore The backup on IIS 7.5 is...

Read More
Oracle glossary: Subquery
  • 23
    Set

Oracle glossary: Subquery

Oracle subquery is a sql query within another sql query. Some example: select tab.name, tab.surname from (select name, surname from customer where surname like ‘S%’) tab select id from myusers where (name, surname) in (select name, surname from customer where surname like ‘S%’) tab select (select ‘1’ from dual) from table.

Read More
Oracle 12c
  • 17
    Set

Oracle 12c

Talking about Cloud means talking about consolidation. This process started with Oracle release 11g   virtualization that  allowed to share  servers and their resources. When the company will shift their mind from a traditional management  concept  to the Cloud, Oracle 12c with the new multitenant architecture will supply this requirement based on  reliability and scalability. The multitenant architecture simplifies ...

Read More