Using Special Characters in Oracle Passwords

As you can see from the test SQL below, I was testing the special character in the middle of the password.

======================================
Test SQL
======================================

create user bubba identified by "abc~123";
grant create session to bubba;
connect bubba/abc~123;

drop user bubba;

========================================
These special characters worked
========================================
!
%
^
@ (requires quotes around password when entering password in connect statement)
$
*
(
)
_
+
~
`
-
=
[
{
]
}
\
|
;
:
'
,
<
.
>
/ (requires quotes around password when entering password in connect statement)


=============================================
I could not find a way to make these 2 work
=============================================
&
"



####

SQL> drop user bubba;

User dropped.

SQL> create user bubba identified by "abc'123"
2 ;

User created.

SQL> grant create session to bubba;

Grant succeeded.

SQL> connect bubba/abc'123

Who is Jim Hill?

I'm your everyday DBA working in Birmingham, AL. I've been doing Oracle work since 1989, but it still amazes me how much there is to learn. I think I'm more of a learning machine than an expert DBA. In fact, my mind seems to have learned to forget at a much quicker rate in order to accomodate the new info that is coming in the front door.

I initially started my database career with Sybase so the concepts behind SQL Server aren't new to me, but I've actually only been working with SQL consistently for less than a year. I'm really a newby in that environment.

As I run into useful ideas and techniques for Oracle and SQL, I'll be sharing them here so come back often to look for updates.

I'll see you further on up the road.