login comand (merged) [message #377620] |
Tue, 23 December 2008 23:43  |
CLS63AMGV8
Messages: 11 Registered: November 2008 Location: Oman
|
Junior Member |
|
|
hi all
how are you
I need help please
I'm new user in oracle
I want to create user name and password and i need the comad for pl/sql
and i created login table. user_name is 42278 and password is fdg456
|
|
|
|
|
|
Re: login comand (merged) [message #377711 is a reply to message #377620] |
Wed, 24 December 2008 07:57   |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
CLS63AMGV8 wrote on Wed, 24 December 2008 00:43 | user_name is 42278 and password is fdg456
|
That is an invalid username in Oracle. There are ways around it, but since you are starting out, it's best not to know how to do unconventional things.
|
|
|
Re: login comand (merged) [message #378031 is a reply to message #377711] |
Sat, 27 December 2008 23:39   |
CLS63AMGV8
Messages: 11 Registered: November 2008 Location: Oman
|
Junior Member |
|
|
thanks all for passing and replying
so what about this comand
declare
x number;
begin
if :users11.username= 'hct ' and
:users11.pass_word= 'hct'
then
call_form(' C:\Documents and Settings\student\Desktop\PROJECT Group 2\UserPass.fmx');
else
x:=show_alert('alert7');
end if;
end;
|
|
|
Re: login comand (merged) [message #378037 is a reply to message #378031] |
Sun, 28 December 2008 01:02  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Instead of posting in bold, colored and big size, read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags.
Use the "Preview Message" button to verify.
Regards
Michel
|
|
|