Results 1 to 1 of 1

Thread: T-SQL functions in ORACLE

  1. #1
    Join Date
    Nov 2009
    Posts
    2

    Thumbs up T-SQL functions in ORACLE

    Use T-SQL functions in ORACLE too, so you can write one script version that works in SYBASE, SQLSERVER and ORACLE when need to use the following functions:
    ceiling, charindex, dateadd, datediff, datename, datepart, day, db_id, db_name, getdate, host_id, host_name, left, len, month, replicate, right, space, str, str_replace, stuff, substring, suser_id, suser_name, user_id, user_name and year.

    The file "comp_tsql_ORA_schema.txt" creates the tablespace and schema to put the objects, and the file "comp_tsql_ORA.txt" creates the functions into the new schema. They will be avaliable for any schema of the oracle instance.

    Hope this help!
    Any suggestion please contact.
    aklein2003
    Last edited by aklein2003; 11-26-2009 at 12:35 PM. Reason: V 1.1

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •