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 you have 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 […]
•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
5 Jan 2021
27 Jan 2020
4 Dec 2013
4 Dec 2013
3 Dec 2013
3 Dec 2013
24 Nov 2013
1 Nov 2013
31 Oct 2013
30 Oct 2013
