Oracle user is a reserved word, can generate problems ?

Asked

Viewed 177 times

2

There may be some problem if an Oracle user (USER) is a reserved word ?

In case : MAX

oracle

1 answer

2

Yes!

I’ve been in the same situation, however, in Mysql.

You should use "MAX" quotes to inform as a normal word.

see in this link and look for MAX or RESERVED WORDS (PL/SQL)

I hope I helped you!

  • 1

    I’ll change the name of the user, I won’t worry about this no, thanks.

  • It’s valid, see if it doesn’t affect other procedures, functions and views that you might have already created!

  • No, it’s an old system that uses the Oracle user to authenticate in the system, "drop" one and create another with the user’s last name. I just wanted to make sure it could be this.

  • In fact that was it , with another user it worked.

  • With quotation marks the user is identified easier! Not wanting to meddle (curiosity), what kind of system is this? Commercial Automation? Payroll? Accounting? Book Cashier? :)

  • A legacy system, we don’t have the sources.

Show 1 more comment

Browser other questions tagged oracle

You are not signed in. Login or sign up in order to post.