See stange data in your table? Use rawtohex to make it visible
Update table based on rownum with where clause
We used this query to assign batch id's to records based on rownum. A normal update wouldn't work because we needed a where clause.
Datatype from powercenter repository
Select The correct datatype for a field in a table.
Find Oracle objects in all schemas
Find Oracle objects in all schemas to find out where an object exists in case of ora-00955 error.
Querying with different aggregation levels
Use oracle Analytic functions to report data from different aggregate levels.
Basic email validation in SQL.