Order By Order By clause used to retrieve the records in a sorted order. Syntax: Select < Fields Name> from < Table Name > order by < Field Name> Example: Select * from Employee order by EmployeeName; Here * indicate all the Fields if user wants to show only specific fields than in the below query use has to mention the name of the fields Example: Select Address, Age from Employee order by EmployeeName; By Default it shows the records in the Ascending order. Group […]
What should I do if we are facing the issue while installing the oracle and there is one instance is already exist on system ?
•Uninstall all Oracle components using the Oracle Universal Installer (OUI). •Run regedit.exe and delete the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE key. This contains registry entries for all Oracle products. •Delete any references to Oracle services left behind in the following part of the registry: HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Ora* It should be pretty obvious which ones relate to Oracle. •Reboot your machine. •Delete the “C:\Oracle” directory, or whatever directory is your ORACLE_BASE. •Delete the “C:\Program Files\Oracle” directory. •Empty the contents of your “C:\temp” directory. •Empty your recycle bin.
Verification of the Table name Data type, Size ,column name Verification of the Default values fr0m valid value set. Verification of static table data Verification of the date format throughout the database. Verification of the constraints like primary key, foreign key , composite key , NULL Not NULL
First NF: Duplicate columns should be eliminated. Second NF: Should be 1NF. Should remove subsets of data that repeats in multiple rows and place them in separate table. Third NF: Should be in 2NF. Repeat columns that are not dependent upon the primary key. Boyce-Codd NF: Should be in 3NF. A relation is in BCNF if every determinant is a candidate key. Fourth NF: Should be in 3NF and BCNF. A relation is in 4NF if it has no more than one multi-valued or multiple […]
SELECT NAME, COUNT (NAME) FROM TABLE1 GROUP BY NAME HAVING COUNT (NAME) > 1
Subscribe for newsletter
4 Dec 2013
Describe the Key features of JMeter , SOAP UI and LISA Tool ?
4 Dec 2013
What do you mean by User acceptance Testing and when can be start the UAT?
3 Dec 2013
What is Software Quality Assurance?
3 Dec 2013
TIBCO Testing VS Traditional Testing ?
24 Nov 2013
What are the TIBCO Business work methodology ?
1 Nov 2013
Displayed Pallets are Dependent on which factors ?
31 Oct 2013
What are Activity output and Group ?
30 Oct 2013
What is the Critical Section Group ?
29 Oct 2013
What is the Pick First Group ?
28 Oct 2013
- SQL commands