Monday, May 27, 2013

sql and pl-sql difference in Oracle 1) We can execute more than one commands at a time in pl-sql,but not allow to execute more than one      command in SQL. 2) Code re usability available in pl-sql,but not allow in SQL. 3) Pl-sql provide facility of condition checking,branching and looping. 4) PL-SQL will run faster in the version 10g than it did in previous versions.Oracle...

Tuesday, April 30, 2013

Single Row Function in sql Single row function divided into 4 types 1) String Function 2) Math Function 3) Date Function 4) Date Conversion Function String Function of Single Row Function a) Length():  This function used to count number of characters in given string including spaces.      Ex: select length('Maha rashtra') from dual b) initcap(): This function...
What is Difference Between sql and tsql 1) SQL is a Structured Query Language.It is developed by IBM.         TSQL is the Transact SQL.It is implementation of SQL Server. Developed by Microsoft. 2) SQL is a query language to operate on sets.     TSQL is a proprietary procedural language used by Microsoft. 3) SQL is a language for talking to the database,It...
Unlock Table Oracle There have no any command  to unlock database. After applying transaction such as Commit and Rollback table automatically unlocked. Commit Transaction Used To Unlock Table: This command is used to save the transaction explicitly from the movement the user log on to the data to the movement the executing Commit command or the movement to user executing...

Monday, April 29, 2013

Synonyms In Oracle Synonyms is a database object which it is alternate name or a duplicate name for original base table. 1) Once we create synonyms,the synonym will be created on entire table,but it is not possible to create a synonyms based on the partial table or subset of the table. 2) If we perform any operation on synonyms then same operation automatically affected to corresponding...