SkypeContactsView utility displays the list of all Skype contacts stored in the local database file of Skype

SkypeContactsView is a new tool that displays the list of all Skype contacts stored in the local database file of Skype. For each contact, one or more of the following fields are displayed: Skype Name, Full Name, Display Name, Gender, ID, Birthday, Profile Time, Last Online Time, Last Used Time, Phone, Emails, and more...
SkypeContactsView also allows you to export the contacts list into text/tab-delimited/comma-delimited/xml/html file, or copy them to the clipboard and then paste them into Excel or other spreadsheet application.

Forms Triggers in ORACLE

Trigger is collection of SQL , PL/SQL and Form coding statements executed based on the event.
Triggers are executed automatically at run time based on an event.
Triggers can be created in three levels.
1. Form level triggers
2. Block level triggers
3. Item level triggers

Form Level Triggers

Block Level Triggers

Item Level Triggers

Other Triggers

Loops Examples in PL/SQL in very easy way

LOOPS      = ONE STATEMENT REPEAT MORE TIME

 1. BASIC LOOP  2. WHILE LOOP   3. FOR LOOP

  DECLARE
  A NUMBER:=0;
  BEGIN
  LOOP
  A:=A+1;
  EXIT WHEN A > 10;
  DBMS_OUTPUT.PUT_LINE(A);
  END LOOP;
  END;

 1
 2
 3
--------------------------------------------------------------------
 DECLARE
 A NUMBER:=0;
 BEGIN
 WHILE A < 10 LOOP
 A:=A+1;
 DBMS_OUTPUT.PUT_LINE(A);
 END LOOP;
 END;

1
2
3.....
---------------------------------------------------------------------
 BEGIN
 FOR A IN 1..10 LOOP
 DBMS_OUTPUT.PUT_LINE(A);
 END LOOP;
 END;

1
2
3.........

Newly Released EpiServer CMS

EPiServer CMS is the EPiServer platform for web content management, allowing you to develop flexible solutions providing outstanding customer experiences.

The EPiServer architecture with CMS is open and flexible and built for customization and extension, for instance with Commerce and Find. The platform provides many built-in features, as well as a set of ready-made content types, base classses and properties, to speed up development.

Top performance is an essential driver for increasing conversion rates on websites. EPiServer is designed to be robust and flexible, and to scale easily as business grows. The EPiServer solution simplifies proper configuration of software components. Performance optimization areas include configuration of common caching schemes, along with appropriate hardware and secured data delivery.

Developing Web Application With Oracle ADF

How to build a rich Web application that interacts with a database. You'll be using Oracle JDeveloper 11g Version 11.1.2 and the Oracle ADF framework to build the application, and in the process you'll work with Oracle ADF Business Components, Oracle ADF Faces Rich Client Components and Oracle ADF Task Flows.
When you work in JDeveloper, you organize your work in projects within an application. JDeveloper provides several template applications that you can use when creating an application and projects. The template applications are pre-configured with a basic set of technologies that are needed for developing the various types of applications, and you create your working environment by selecting the template that best fits your needs. You can then configure it to add any other technologies you plan to use.
You are going to create a new Fusion Web application and build reusable business components that will access the database. You'll be using the Oracle ADF Business Components technology to map Java objects to existing tables in your database.

Why Oracle Database 12c ?

Oracle Database 12c introduces a new multitenant architecture that makes it easy to consolidate
many databases quickly and manage them as a cloud service. Oracle Database 12c also includes in-memory data processing capabilities delivering breakthrough analytical performance. Additional database innovations deliver new levels of efficiency, performance, security, and availability.
Oracle Database 12c comes in three editions to fit your business needs and budget: Enterprise Edition, Standard Edition, and Standard Edition One.

CMS CodeIgniter Benifits

CodeIgniter is a powerful PHP framework with a very small footprint, built for PHP coders who need a simple and  elegant toolkit to create full-featured web applications. If you're a developer who lives in the real world of shared  hosting accounts and clients with deadlines, and if you're tired of ponderously large and thoroughly undocumented frameworks, then CodeIgniter might be a good fit.

CodeIgniter is an Application Development Framework - a toolkit - for people who build web sites using PHP. Its goal is to enable you to develop projects much faster than you could if you were writing code from scratch, by providing a rich set of libraries for commonly needed tasks, as well as a simple interface and logical structure to access these libraries. CodeIgniter lets you creatively focus on your project by minimizing the amount of code needed for a given task.

Web CMS Training Available

Content Management System (CMS) Training

Who should attend?
Staff who will be in-putting content for pages on the internet and wish to discover how easily they
can put in content, make alterations and/or additions before publishing the pages.

Objectives
To provide practical training of the most common features of the CMS used by staff authoring
 and/or editing content, including inputting different content types, previewing, checking and
changing content before publishing on the internet without having the knowledge of HTML.

Course content
     By the end of the course participants will understand:
    What a Content Management System (CMS) is:
  
    The benefits of using a CMS and
    How to use a CMS
    How to log on to the CMS
    How to define 'Content Types' and how to add content
    Using Templates to add content to the web site
    Entering Data into a Template
    Rich Text
    Mandatory Data
    Non Mandatory Data e.g. 'What's New
    Expiry Dates
    Incomplete/Complete/Publish
    Preparing Content for the web site
    Previewing
    Categorisation
    Adding Images
    Adding Keywords
    Adding Related Content
    Adding External Links
    Dublin Core
    Finish / Unlock
    Adding attachments to content
    Linking the files to the system
    Adding links within the content
    External
    Internal
    Email
    Understanding Workflow
    Selecting an Editor
    Attaching comments
    Editing content on the system
    Workflow notification
    Search for content
    Edit content
    Publish Content
    Finish/Unlock

Using Tools
    WordPress
    ProcessWire
    Codeigniter
    Bootstrap
    HTML5
    Jquery
    Adobe Dreamweaver CS5

create Business website in CMS/CMF (ProcessWire)

ProcessWire is an award winning Open Source Content Management System(CMS)  and Content Management Framework written in PHP. ProcessWire has been developed by Ryan Cramer since 2003. From 2003 to 2007 it was developed under the name Dictator CMS. From 2007–2010 it was developed as ProcessWire 1.x, and from 2010 to now, it has been developed as ProcessWire 2.x.

Using MYSQL with php is not part of the starters lessons PHP. First its time to understand the basics. What are types, variables, operators, control structures functions etc. etc. This basic knowledge is enough to get start with ProcessWire. For the MYSQL + PHP only way, the second lessons for PHP starts & you have to subscribe to the starters lessons for MYSQL. side note: Take the multi lessons hard way, over the easier step in to ProcessWire. This knowledge will make the difference from 'can make a website' to 'to be a developer'. Comparing only getting 1 field from SQL to ProcessWire is not fair. On the time you get 1 field out of SQL with PHP, ProcessWire has take care of all the stuff thats needed to be a fully functional CMF/CMS and given you back the field data needed. ProcessWire takes care of an awful lot of logic. But on the end it's the developer who decide. There's the framework part of PW.
ProcessWire is build with PHP and done very well. The simplicity to access data with ProcessWire is unique. Never seen this simple way anywhere.

Oracle Launches Oracle Hospitality

Oracle, building on the strong foundation MICROS established serving the hotel and food and beverage industries, has launched Oracle Hospitality Global Business Unit to accelerate development of innovative cloud, mobile, and guest experience technology.With hundreds of thousands of systems already deployed in hotels, restaurants, cruise operations, and other venues on all seven continents, Oracle Hospitality extends MICROS’ commitment to providing fast, reliable service and solutions to customers both large and small.

Oracle Cast Function Use

The Oracle CAST function converts one data type to another.  The CAST function can convert built-in and collection-typed values into other built-in or collection typed values.

 CAST can convert a date or other unnamed operand (or a nested table or other named collection) into a type-compatible datatype or named collection.  For this use of CAST, type_name and/or operand must be of (or evaulate to) a built-in datatype or collection type .

CAST and ANYDATA Type

When using CAST to convert an operand, the expr can also be either a built-in datatype or a collection type; however, it can be an instance of an ANYDATA type as well. When the expr is of an ANYDATA type, CAST attempts an extraction of the value of the ANYDATA expr and returns it if it matches the CAST target type.  If the there is no match to the CAST target type, NULL is returned.

CAST with LOB Datatypes

 LOB datatypes are not directly supported by the CAST function.  Using CAST to convert CLOB values into a character datatypes or BLOB values into the RAW datatype results in the database converting the LOB value implicity to character or raw data.  Once this implicit conversion is done, the resulting value is CAST into the target datatype.  This process will throw an error if the resulting value is larger than the target type.

The Oracle docs note the syntax for Oracle CAST as follows:

CAST({ expr | MULTISET (subquery) } AS type_name)

With the Oracle CAST function a block could be re-written as:

DECLARE
  v NUMBER;
BEGIN
  a(CAST (v AS INTEGER));
END;

On the other hand, the function could be re-written with Oracle CAST as:

DECLARE
  v NUMBER;
BEGIN
  a(v::INTEGER);
END;

Each of these uses of the CAST function will produce the same result.

Make Calendar in Oracle Apps

Followed these Steps which is of no use in Oracle apps.

1. Create a new MODULE in Forms Builder
2. Then open the stndrd20.olb file (this .olb file is located
in the ORACLE_HOME/TOOLS/DEVDEMXX/Forms FOLDER)
3. You will see 'STANDARDS' appear under 'Object Libraries' in the Object
Navigator
4. Double click on the book-like icon next to 'STANDARDS'
5. Expand the object library window that appears
6. Click on the 'COMPONENTS' tab
7. Look for the 'CALENDAR' object library
8. Drag-n-drop the 'CALENDAR' object into your new form
9. Notice all the new items are now in your form marked with a red arrow*
*The red arrow means that the items are subclassed.
10. Attach the PL/SQL library CALENDAR.PLL
(this .pll file is also located in the ORACLE_HOME/TOOLS/DEVDEMXX/Forms
FOLDER)
11. In Forms, Create a new block on a new canvas
12. Create a Key-Listval trigger on the date item for which you
would like to use the Date LOV Window. Add the below code to display the
calendar using the Date_LOV package.

date_lov.get_date(sysdate, -- initial date
'emp.hiredate', -- return block.item
240, -- window x position
60, -- window y position
'Start Date', -- window title
'OK', -- ok button label
'Cancel', -- cancel button label

13. If you want the end user to be able to close the Date List of Values
window by clicking the window close button (the X) in the title bar, create a
form-level When-Window-Closed trigger with the following code:

When-Window-Closed trigger:
GO_BLOCK('EMP');

VIEW-SEQUENCE-INDEX

 VIEW=  THE SUBSET OF THE TABLE. USE FOR COMPLICATED COMPLEX QUERY.

SQL> SELECT ENAME,JOB,SAL FROM EMP
  2  WHERE DEPTNO IN (10,20)
  3  OR JOB = 'SALESMAN' OR
  4  SAL <= 2500;

ENAME      JOB              SAL
---------- --------- ----------
AHMAD      CLERK          40000
MARIA      OFFICER         7000
ALI        CLERK           5000
SAHIR      CLERK           2000
ARIF       CLERK           2500
ASIF       DBA            77788
KIRAN      MANAGER         2000
SANA       MANAGER         2200
KASHIF     OFFICER         1400
IRFAN      CLERK           1200
EMRAN      CLERK           1000

ENAME      JOB              SAL
---------- --------- ----------
SIDRA      ASSISTANT        900
SMITH      CLERK            800
ALLEN      SALESMAN        1600
WARD       SALESMAN        1250
JONES      MANAGER         2975
MARTIN     SALESMAN        1250
CLARK      MANAGER         2450
SCOTT      ANALYST         3000
KING       PRESIDENT       5000
TURNER     SALESMAN        1500
ADAMS      CLERK           1100

ENAME      JOB              SAL
---------- --------- ----------
JAMES      CLERK            950
FORD       ANALYST         3000
MILLER     CLERK           1300

25 rows selected.

SQL> CREATE VIEW ABCVIEW
  2  AS
  3   SELECT ENAME,JOB,SAL FROM EMP
  4   WHERE DEPTNO IN (10,20)
  5   OR JOB = 'SALESMAN' OR
  6   SAL <= 2500;

View created.

SQL> SELECT * FROM ABCVIEW;

ENAME      JOB              SAL
---------- --------- ----------
AHMAD      CLERK          40000
MARIA      OFFICER         7000
ALI        CLERK           5000
SAHIR      CLERK           2000
ARIF       CLERK           2500
ASIF       DBA            77788
KIRAN      MANAGER         2000
SANA       MANAGER         2200
KASHIF     OFFICER         1400
IRFAN      CLERK           1200
EMRAN      CLERK           1000

ENAME      JOB              SAL
---------- --------- ----------
SIDRA      ASSISTANT        900
SMITH      CLERK            800
ALLEN      SALESMAN        1600
WARD       SALESMAN        1250
JONES      MANAGER         2975
MARTIN     SALESMAN        1250
CLARK      MANAGER         2450
SCOTT      ANALYST         3000
KING       PRESIDENT       5000
TURNER     SALESMAN        1500
ADAMS      CLERK           1100

ENAME      JOB              SAL
---------- --------- ----------
JAMES      CLERK            950
FORD       ANALYST         3000
MILLER     CLERK           1300

25 rows selected.

SQL> DROP VIEW ABCVIEW;

 SEQUENCE=  TO GENERATE AUTO NO

SQL> CREATE SEQUENCE ABCSQ
  2  START WITH 10
  3  INCREMENT BY 5;

Sequence created.

SQL> CREATE TABLE ABCDEF
  2  (RNO NUMBER(10),
  3  NAME VARCHAR2(20));

Table created.

SQL> INSERT INTO ABCDEF
  2  (RNO,NAME)
  3  VALUES
  4  (ABCSQ.NEXTVAL,'USAMA');

1 row created.

SQL> ED
Wrote file afiedt.buf

  1  INSERT INTO ABCDEF
  2  (RNO,NAME)
  3  VALUES
  4* (ABCSQ.NEXTVAL,'SAMI')
SQL> /

1 row created.

SQL> ED
Wrote file afiedt.buf

  1  INSERT INTO ABCDEF
  2  (RNO,NAME)
  3  VALUES
  4* (ABCSQ.NEXTVAL,'EJ')
SQL> /

1 row created.

SQL> ED
Wrote file afiedt.buf

  1  INSERT INTO ABCDEF
  2  (RNO,NAME)
  3  VALUES
  4* (ABCSQ.NEXTVAL,'HA')
SQL> /

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SELECT * FROM ABCDEF;

       RNO NAME
---------- --------------------
        10 USAMA
        15 SAMI
        20 EJ
        25 HA

SQL> SELECT * FROM USER_SEQUENCES;

SEQUENCE_NAME                   MIN_VALUE  MAX_VALUE INCREMENT_BY C O CACHE_SIZE
------------------------------ ---------- ---------- ------------ - - ----------
LAST_NUMBER
-----------
EMPSEQ                                  1 1.0000E+27           10 N N         20
       8336

DBOBJECTID_SEQUENCE                     1 1.0000E+24           50 N N         50
          1

ABCSQ                                   1 1.0000E+27            5 N N         20
        110


SQL> SET LINES 300 PAGES 300
SQL> /

SEQUENCE_NAME                   MIN_VALUE  MAX_VALUE INCREMENT_BY C O CACHE_SIZE LAST_NUMBER
------------------------------ ---------- ---------- ------------ - - ---------- -----------
EMPSEQ                                  1 1.0000E+27           10 N N         20        8336
DBOBJECTID_SEQUENCE                     1 1.0000E+24           50 N N         50           1
ABCSQ                                   1 1.0000E+27            5 N N         20         110

SQL> DROP SEQUENCE ABCSEQ;
DROP SEQUENCE ABCSEQ
              *
ERROR at line 1:
ORA-02289: sequence does not exist


SQL> ED
Wrote file afiedt.buf

  1* DROP SEQUENCE ABCSQ
SQL> /

Sequence dropped.

 INDEX= TO IMPROVE THE PERFORMANCE OF THE TABLE.WHEN UR DATA > 200 IN A TABLE THEN U APPLY INDEX.
     PK  UK IN COLUMNS AUTOMATIC CREATE INDEX.

SQL> CREATE INDEX ABCIDX
  2  ON EMP(JOB);
ON EMP(JOB)
       *
ERROR at line 2:
ORA-01408: such column list already indexed


SQL> ED
Wrote file afiedt.buf

  1  CREATE INDEX ABCIDX
  2* ON EMP(SAL)
SQL> /
ON EMP(SAL)
       *
ERROR at line 2:
ORA-01408: such column list already indexed


SQL> ED
Wrote file afiedt.buf

  1  CREATE INDEX ABCIDX
  2* ON ABCDEF(NAME)
SQL> /

Index created.

SQL> SELECT * FROM ABCDEF;

       RNO NAME
---------- --------------------
        10 USAMA
        15 SAMI
        20 EJ
        25 HA

SQL> DROP INDEX ABCIDX;

Index dropped.