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...
Monday, May 27, 2013
Tuesday, April 30, 2013
10:41 PM
by
Unknown
No comments
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...
9:42 PM
by
Unknown
No comments
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...
7:50 PM
by
Unknown
No comments
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
6:31 AM
by
Unknown
No comments
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...
Subscribe to:
Posts
(
Atom
)