-
Number of Updated rows from a Procedure
How to find Number of Updated rows from a procedure which is having a Update Query?
prasads_delight1
- Dec 14th, 2008
Add COUNT keyword to the Update queary by which we can get the number of rows effected by the applied update queary. Else by using the front end code we can call the update queary as string which will run after the loop which will count the rows under the given condition. (by using a perameter)
-
-
What is the different between Stand Alone Procedure and Package?
suresh.adqr
- Feb 18th, 2009
1. Procedure Overloading and Function Overloading Possible in Package. This Overloading Concept Not Possible in Procedure.2. Variables in Package we Can use as a Global Variables. it's Not Possible in Procedure.
amikat
- Jun 3rd, 2008
Procedure is a named PL/SQL block tht is stored in the database.Package is a collection of functions and procedures stored within the database. Pkg consists of 2 parts 1. Specification - declares type...
-
How many bites does varchar2(30) needs ?
prasads_delight1
- Sep 28th, 2007
The varchar2(30) will take 30 bites. Because the size is specified as 30. if you entered a data of only 20 chars the remaining 10 will be transformed to the other field or row. By this the wastage of the disk space can be minimised.
pkjayan
- Apr 29th, 2007
Varchar2 does not pad the unused bytes.it only uses the number of bytes inserted+1(end of charector) of course <30!
-
what is data structure
prasads_delight1
- Sep 28th, 2007
The way the data maintained in the collection of tables can be explained by the data structure. The structure of database will show on which conditions the database will be maintained with out inconsistancy.
-
what is the difference between primary key, unique key, surrogate key?
Read Best Answer
Editorial / Best Answer
Kolta Sam- Member Since Jul-2011 | Jul 10th, 2011
Primary Key:
It is a visible key
It generated by user or application.
It could be changed by the user or application.
It could be queried
It used to form a relation between tables
It shouldn’t contain null value
It resemble table row
It is a unique identifier for a table object.
It contains only one key
It could contain numeric and strings characters.
It is an unique key which each row contain a distinct different key.
Example for it is a customer_Id.
It always starts by number one and second is two and so on but can starts with a different number.
Could created on one or more columns
No duplicate recordsSecondary Key:
It used to form a relation between tables.
It is alternate table key.
It used to search data with primary key
It could contains null value
It could contains more than one secondary key for each table
Created only on one columns
No duplicate records
It creates index clustered by default
Surrogate Key:It is invisible key for the user or the application.
It resembles database entity.
It generated by the system so it is invisible for user and application.
It shouldn’t contain null values
Only one surrogate key for each data entity
Its value is unique system wide.
Its value is never manipulated by the user or the application.
It never reused
It is frequently sequential number
It called synthetic key, an entity identifier, a system-generated key, a database sequence number, a factless key, a technical key, or an arbitrary unique identifier
No duplicate recordsgopi
- May 18th, 2018
Primary key not allow null values where as unique allows but both are alternates.
surrogate key serve as primery key in type 2 dimension tablesSukdya
- Nov 27th, 2017
Primary key doest not allow null values but unique key allows only one null value.
