Inserts in capital in the bank

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
Post Reply
edu_oracle
Moderador
Moderador
Posts: 53
Joined: Mon, 12 Jul 2004 11:24 am
Location: Salvador
Atenciosamente,

Eduardo Santana

"Viva o dia de hoje como se fosse amanhã, por isso, não perca as oportunidades...."

Personal is the following:

I am developing a registration system in jdeveloper and in one of the registration processes I want the data to be entered only as uppercase, regardless of the user to enter them in tiny.

Does anyone know how to do this?

Thanks
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

What can you do, if you do not want to mess with the programs, it's to create a trigger before insert ...

in it, you take the desired field and do so:

0]]]
edu_oracle
Moderador
Moderador
Posts: 53
Joined: Mon, 12 Jul 2004 11:24 am
Location: Salvador
Atenciosamente,

Eduardo Santana

"Viva o dia de hoje como se fosse amanhã, por isso, não perca as oportunidades...."

Thanks man .... I'll apply.
edu_oracle
Moderador
Moderador
Posts: 53
Joined: Mon, 12 Jul 2004 11:24 am
Location: Salvador
Atenciosamente,

Eduardo Santana

"Viva o dia de hoje como se fosse amanhã, por isso, não perca as oportunidades...."

Face is the following,


the trigger that you indicated me is functional, but my situation is as follows:
previously I I was inserting a word in a form and commiting this word in another form, so the trigger worked beauty.

Only now I need to insert the word and commit it in the same form, hence when I go to the main form the word is already changed.


have some suggestion?
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

I think what's missing there is a refresh, or something ... I do not know if you will get it without messing with the codes of your program ... :-(
edu_oracle
Moderador
Moderador
Posts: 53
Joined: Mon, 12 Jul 2004 11:24 am
Location: Salvador
Atenciosamente,

Eduardo Santana

"Viva o dia de hoje como se fosse amanhã, por isso, não perca as oportunidades...."

Pow man, I solved the problem.

The case was: When I fired the trigger, there were some data in one of the tables I had not seen. It hurt error.

The trigger as it is, is running perfectly.

Thanks again.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 8 guests