Example of Data Template <?xml version="1.0" encoding="UTF-8"?> <dataTemplate name="PER" description="EMPLOYEE_DESCRIPTION" defaultPackage="employee" version="1.0"> <parameters> </parameters> <dataQuery> <sqlStatement name="PER"> <![CDATA[Select PERSON_ID, EMPLOYEE_NUMBER,FULL_NAME,NATIONALITY,SEX,PARTY_ID from PER_ALL_PEOPLE_F where 1=1 AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE AND PERSON_ID IN (156, 461 ) AND ROWNUM<16]]> </sqlStatement> </dataQuery> <dataStructure>  <group name="PER" source="PER">  <element name="PERSON_ID" value="PERSON_ID"/>  <element name="EMPLOYEE_NUMBER" value="EMPLOYEE_NUMBER"/>  <element name="FULL_NAME" value="FULL_NAME"/>  <element name="NATIONALITY" value="NATIONALITY"/>

Hello Friends , Lots of My dear friends and viewers have requested to know about ROWID and its Its details . This Post I try to give more details about Rowid and How best can we use it to locate the unique Record Rowid is also called as Pseudo Column . For each row in the database, the ROWID pseudo ccolumn returns the address of the row. Oracle Database rowid values contain information necessary to locate a row: •      The data object number of the object •      The data block in the datafile in which the row resides •      The position of the row in the data block (first row is 0) •      The datafile in which the row resides (first file is 1). The file number is relative to the tablespace. Usually, a rowid value uniquely identifies a row in the database. However, rows in different tables that are stored together in the same cluster can have the same rowid. Values of the ROWID pseudocolumn have the datatype ROWID or UROWID. Please refer to "ROWID Dat

                             Data Base Security Hi Friends Lets Understand about Oracle Database Security It provides the security to the Oracle database or schema objects. It is the concept in oracle which provides high security and accessibility to the database objects It has been provided interns of different privileges and rights. Types of Privileges 1 System Privilege 2 Others Privilege System Privilege :- This is the Privilege provided by the database administrator for system upgrade, patching etc within the database. Other Privilege:- This the Privilege provided by the database administrator for accessing the objects (table ,view ,synonym ,Index etc) across the database. Types of Privileges 1> Grant 2> Revoke 1>what is Grant> It is the type of Privilege which is provided by the owner of the objects to be shared across the database. Syntax of Grants:- Grant  < Privilege _name> ON <Table name> To USER1,USER2, …;

Hi Friends Lets Understand What is Synonym It is the Schema object which is the alternate name for the database object. It avoids the Schema name entry to the database. Syntax:- Create Synonym <Synonym_name > For SCHEMA.OBJECT; Example:- CREATE SYNONYM GHAN for SCOTT.GHAN; NOTE :- Assuming GHAN is Database Table .

Dear Friends   Let's experience the Power of SQL Function.   Oracle Functions are built into ORACLE and are available for use in Various Appropriate SQL Statement. ·         The SQL Function Can is used to                       i.        Perform Calculation on Data                      ii.        Modify Individual Data item                     iii.        Manipulate output for Groups of Rows.                    iv.        Format dates and Number for Display                     v.        Convert Column Data Type   ·         SQL Function May Accept Argument and always Return a value and can be Nested. ·         If an SQL Function is called with a NULL Argument, Then a Null is returned. SQL Function Types ·         SQL identifies two types of Function 1.    Single Row Function 2.    Multiple Row Function Single Row Function These Function Returns for every row of a queried table or view. Multiple Row Function These Function Mani