0 - 3 of 3 tags for comparison
Comparing Two Environment

Hi,
I need to write a Stored Procedure to compare two Environment's(eg. Dev1_stg with Dev12_stg) Tables, Stored Procedure, UDF, Especially Views. Can any one suggest how can i approach this concept in Stored Procedure? 
I am able to do this comparison for Tables, using Dbc.ColumnsV. but for Stored Procedures, Views?
Thanks!
 

By mihirdhakan93, 15 Oct 2015 | Tagged: comparison stored procedure environment comparison | 1 comment
Oracle to Teradata 101
If you've worked with Oracle for years and now find yourself the DBA for a Teradata Data Warehouse, you'll want to get productive as soon as possible.
By DebraH, 10 Jun 2015 | Tagged: database architecture migration oracle comparison
substr vs substring

hi
 
have few questions reg substr & substring
 
a. which one is ANSI compliant?
b. whats th difference btween two?
c. which one should be used?
 
Natasha

By natali, 18 Feb 2014 | Tagged: substr substring comparison | 4 comments