Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Proposal - add the SUBSTRING alias for the SUBSTR function

iwisNov 24 2020 — edited Apr 15 2021

Hi!
I compared string functions in 5 different RDBMS: PostgreSQL, MySQL, Oracle, SQL Server and SQLite, and also in the ANSI SQL Standard. There are large differences among different RDBMS, and I propose to reduce them a little bit.
Particularly, I propose to add the SUBSTRING alias for the SUBSTR function.
Explanation: This is the current syntax of the SUBSTR[ING] functions in ANSI standard and in different RDBMS:

ANSI standard:      SUBSTRING   (s FROM start [FOR length])
PostgreSQL & MySQL: SUBSTR[ING] (s, start [,length])
Oracle & SQLite:    SUBSTR      (s, start [,length])
SQL Server:         SUBSTRING   (s, start  ,length )

To unify the syntax, I propose to add the SUBSTRING alias to the SUBSTR function in Oracle. SQLite already will support the SUBSTRING alias from the 3.34 version. If Oracle does the same, we will be able to use the SUBSTRING(s, start, length) syntax in all above-mentioned RDBMS. This will make the SQL Server syntax compatible with all major RDBMS. Hopefully this would be another step to help C# programmers switch from SQL Server to other databases. I think it is worth to think about it, especially after the latest release of the .NET 5 framework, which unifies the old .NET Framework and .NET Core, into the single multi-platform framework able to be run on Windows and Linux.
I also proposed this change: https://community.oracle.com/tech/developers/discussion/4477917/proposal-add-an-optional-argument-c-after-a-comma-in-the-trim-s-function.
The changes proposed by me for other RDBMS are listed here: https://github.com/iwis/SQL-notes/blob/master/Functions_proposed_changes.md

Comments

Arjesh-Oracle

Hi,

You can refer the document: Upgrade Advisor: Siebel from Earlier Releases to 8.1.1.x or 8.2.2.x (Doc ID 259.1)

Thanks,

Arjesh

“Please mark any update as "Correct Answer" or "Helpful Answer" if that update helps/answers your question, so that others can identify the Correct/helpful update between many updates.”

AMSI

Hi Arjesh,

thanks. but this refer document is not accessible by oracle. Kindly share this document if you can.

Regards,

AMSI

Arjesh-Oracle

Hi AMSI,

This is an external document and you should see it.

Please login to the support portal and search using the document Id: 259.1

Thanks,
Arjesh

AMSI

hi,

here i have another solution i just wanted to share with you. correct me if i am wrong.can we upgrade in this way. e.g

we install new Sieble version(8.1) on another machine with db 11g

Then we can create the repository upgrade on the source machine of old version(7.8) with db 10g. is there any repository upgrade tool that upgrade the db schema.

then we just import repository on new database with new Sieble version.

Upgrade complete!!

your advice will be appreciated

Regards,

AMSI

Chetan-Oracle

Hello Amsi,

If you are doing complete database upgrade of prior version to new one, then yeah your method is supported one.

I hope it helps.

Best Regards,

Chetan

AMSI

Kindly mention the tool by which we can upgrade the repository?

Regards,

Madhavi Kaza-Oracle

Amsi,

The upgrade path that you mentioned requires full upgrade process.

The upgrade process consists of running steps :

UpgRep,

Merge

UpgPhys

in Dev upgrade.

It is just not possible to upgrade your repository as the upgrade involves upgrading your Database, Repository through Merge process and synchronizing with physical schema and there are many more steps taken care of by the above steps mentioned.

Please review Upgrade Guide for V8.1.x on MOS completely to understand the process involved.

In addition, please review the following doc as mentioned earlier:

Upgrade Advisor: Siebel from Earlier Releases to 8.1.1.x or 8.2.2.x(Doc ID 259.1)


Hope this helps.


Thanks,

Madhavi.

WSiebel-Oracle

AMSI,

Here is a link to the upgrade document on Siebel Bookshelf in case you don't have access to the articles on My Oracle Support (support.oracle.com):

Bookshelf v8.1/8.2: Upgrading the Siebel Database

Hope it helps,

Wilson

1 - 8

Post Details

Added on Nov 24 2020
3 comments
261 views