OraFAQ Forum: Forms » How To Show Data Like This

Home » Developer & Programmer » Forms » How To Show Data Like This (11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How To Show Data Like This [message #623825]

Mon, 15 September 2014 03:48

cool06prashant
Messages: 9
Registered: September 2014
Location: delhi

Junior Member

username :Abc
password :******90

or atm mini statement like as **********456

How Can We Do That in Oracle From at textitem -on pre-insert trigger

Report message to a moderator

Re: How To Show Data Like This [message #623827 is a reply to message #623825]

Mon, 15 September 2014 03:55

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Use SUBSTR; leave the last several characters intact, mask the other ones with asterisks.

Report message to a moderator

Re: How To Show Data Like This [message #623854 is a reply to message #623827]

Mon, 15 September 2014 08:31

CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA

Senior Member

I should think the Conceal Data property of the text item would work better than using Substr(). This will mask the entire input, but I can't think of any reason why you would want to reveal part of the input and not all of it.

Craig...

Report message to a moderator

Re: How To Show Data Like This [message #623878 is a reply to message #623854]

Mon, 15 September 2014 15:17

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Because, sometimes, people want to display only part of (for example) credit card number and conceal the rest of it?

Report message to a moderator

Re: How To Show Data Like This [message #623880 is a reply to message #623878]

Mon, 15 September 2014 16:49

CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA

Senior Member

Fair enough, I can understand concealing part of the number in that scenario, just not with a password entry Smile

Craig...

Report message to a moderator

Re: How To Show Data Like This [message #623890 is a reply to message #623880]

Tue, 16 September 2014 00:18

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

On the other hand, you are right & I agree with you. If it is about a password, the conceal data property makes sense. The truth is: I didn't read the question carefully enough and saw only "significant" (yeah, right ...) parts of it, such as "how to show ..." and "**********456". I completely ignored the "password" part of it. My bad.

So: partially concealed password doesn't make much sense. Some - yes. For example, if you have numerous accounts and passwords, it might be handy if you see just part of it which would remind you of the rest of the password. Rather stupid reason, I admit. Maybe the OP will explain it better.

Report message to a moderator

Re: How To Show Data Like This [message #624383 is a reply to message #623890]

Mon, 22 September 2014 07:46

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

here is the solution of your problem :-

/forum/fa/12187/0/

Attachment: concelspecifictext.JPG
(Size: 10.87KB, Downloaded 1604 times)

Report message to a moderator

Re: How To Show Data Like This [message #624385 is a reply to message #624383]

Mon, 22 September 2014 07:49

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

@jgjeetu,

You don't need to post an image to post just text.
So just post the text (but post it formatted).

Report message to a moderator

Re: How To Show Data Like This [message #624398 is a reply to message #623825]

Mon, 22 September 2014 10:01

cool06prashant
Messages: 9
Registered: September 2014
Location: delhi

Junior Member

Thanks To all.

Report message to a moderator

Re: How To Show Data Like This [message #624606 is a reply to message #624385]

Tue, 23 September 2014 23:47

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

ok @michel Smile

Report message to a moderator

Previous Topic:	How to link Receivable(HZ_PARTIES) and its Bank Account?
Next Topic:	Exception NO_DATA_FOUND

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Aug 27 22:40:11 CDT 2025