TechKnowLogic

Requirement is simple; you want to retrieve/recover the Version Information of your currently installed Oracle Database. Let us discuss most of the ways of doing so in Oracle & SQL Server. Here are some of the ways to get it: 1)  DBA_REGISTRY (Table)       S ELECT * FROM DBA_REGISTRY ; SELECT comp_id, comp_name, version, status, namespace, control FROM DBA_REGISTRY WHERE comp_name LIKE '%Oracle%' ORDER BY comp_name; This will give you the db version along with all the other oracle components installed. Here is the result: COMP_ID COMP_NAME VERSION STATUS NAMESPACE CONTROL CATALOG Oracle Database Catalog Views 9.1.0.3.0 VALID SERVER SYS CATPROC Oracle Database Packages and Types 9.1.0.3.0 INVALID SERVER SYS 2 )       V$VERSION ( View ) SELECT * FROM V$VERSION This is the result: BANNER Oracle Database 9G Enterprise Edition Release 9.1.0.3.0 - 64b...

The issue is simple. You want a migration of your database from Oracle to SQL Server. Hierarchical queries with parent child relationship inside the same table can be a pretty interesting area. In SQL Server 2000, we do not have any straightaway method to do so (unlike in Oracle 10g), along with customized output, but the pain is reduced in higher versions of SQL Server (SQL Server 2005 & 2008). Let us look at the basics quiet SIMPLY . Oracle 10g I will create the FAMILY table to explain this. However, there is a couple of assumption. a)       The data in the FAMILY table does not belong to a person having fallen in love multiple times , resulting in multiple marriages, further resulting in multiple families . So, Sukhendu’s father and Rajkumar’s father is not the same person. b)       Here null as parent_id means simply I am using it for this example. Definitely the Greater Grand Father also had his father. Howev...