This is achieved by using the sys.dba_users table, which means these queries must be done using an account with proper privileges. Beyond creation of users, the second SQL statement in the example below also generates account-locking commands for those users that are currently marked as locked. Finally, note the output file has the extension .sql, which suggests that it can be run directly from SQL*Plus as part of an automated script, if necessary.
set linesize 256;
spool c:oracleUsers.sql;
select 'create user '||username||' identified by values '||''''||password||''''||'
default tablespace '||default_tablespace||'
temporary tablespace '||temporary_tablespace||'
quota unlimited on '||default_tablespace||'
quota unlimited on '||temporary_tablespace||';' as "-- create_users"
from sys.dba_users
where default_tablespace not in('SYSAUX','SYSTEM')
order by username;
select concat(concat('alter user ',du.username),' account lock;') as "--lock_users"
from sys.dba_users du
where du.account_status<>'OPEN'
and du.default_tablespace not in('SYSAUX','SYSTEM')
order by du.username;
spool off;
The following steps outlines how to manually delete a database within Oracle 11g, running in an Linux environment. I am currently running Oracle’s Enterprise Linux release 5 update 2.
Use SQL*Plus or your favorite SQL command line tool to log in to the target database; log in as sysdba
Issue the following commands to get the path to various files
select name from v$datafile;
select member from v$logfile;
select name from v$controlfile;
select name from v$tempfile;
Shut down the database within SQL*Plus, and then exit out of SQL*Plus
shutdown immediate;
quit;
Stop the listener service by issuing the following command in the terminal prompt:
lsnrctl stop
Recall the file paths found earlier; use them as a check list as you delete each one of those files. Reminder: did you back up your database yet? When ready, go ahead delete your data files, redo log files, control files, and temp files.
Go to the $ORACLE_HOME/network/admin directory and delete the tnsnames.ora and listener.ora files
Go to the $ORACLE_HOME/dbs directory and delete the init[db_name].ora, orapw[db_name], and spfile[db_name].ora files
Go to the $ORACLE_HOME/admin/[db_name]/pfile directory and delete the init[db_name].ora file
Go to the $ORACLE_HOME/admin/[db_name]/adump directory and delete all files in that directory
Edit the file /etc/oratab by removing the line that starts with your database name
To do so, we will make use of Oracle’s next_day() function. The sample code is as follows:
select next_day(sysdate-14,'SUNDAY') as week_start, next_day(sysdate-7,'SATURDAY') as week_end from dual;
Assuming the current date is 20 Aug 2008, the above code will return 10 Aug 2008 and 16 Aug 2008, reflecting that the previous calendar week is between Sunday the 10th and Saturday the 16th. Thus, your query to get records inserted in the previous calendar week may look something like the following.
select record_id, record_stuff, entry_date
from bunch_of_records
where entry_date between
next_day(sysdate-14,'SUNDAY') and
next_day(sysdate-7,'SATURDAY');
To populate some random text, call the Javascript function “loremIpsum(‘elementName’)”, where “elementName” is the ID of an element you wish to populate the text to. The following code illustrate how we can use this function to populate automatic lorem ipsum text into a DIV.
<html>
<head>
<script type="text/javascript" src="lorem.js"></script>
</head>
<body>
<p><b>Lorem Ipsum generator</b><br />
Written by C. Peter Chen of <a href="http://dev-notes.com">dev-notes.com</a></p>
<div id="div1">
</div>
<input type="button" onclick="loremIpsum('div1');" value="Add Text">
</body>
</html>
Finally, the following section is a live demo of how the code should behave.
To do so, follow the sample code shown below. To use the code as-is, just alter the configuration parameters by providing the from address, to address, subject, body, and SMTP server information. Optionally, you may also provide a path to a file that you want to attach to the email. Usually SMTP port number is 25; if you are unsure, leave this parameter untouched and it will probably work at the default value of 25.
option explicit
dim fromAddress, toAddress, subj, body, smtp, attach, smtpPort
'''''''''''''''''
' Configuration '
'''''''''''''''''
' Required parameters
fromAddress = "my@email.address" ' The from email address
toAddress = "recepient@email.address" ' The to email address
subj = "Email Subject" ' The subject of the email
body = "Put a message here!" ' The body message of the email
smtp = "mail.server.com" ' Name of the SMTP server you wish to use
' Optional parameters
attach = "c:filename.txt" ' Optional file you may wish to attach to the email
smtpPort = 25 ' SMTP port used by your server, usually 25; if not provided, the script will default to 25
'''''''''''''''''''''
' End Configuration '
'''''''''''''''''''''
if fromAddress = "" then
msgbox("Error: From email address not defined")
elseif toAddress = "" then
msgbox("Error: To email address not defined")
elseif subj = "" then
msgbox("Error: Subject not defined")
elseif body = "" then
msgbox("Error: Body not defined")
elseif smtp = "" then
msgbox("Error: SMTP server not defined")
else
dim objMessage
Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = subj
objMessage.From = fromAddress
objMessage.To = toAddress
objMessage.TextBody = body
if attach <> "" then
objMessage.AddAttachment attach
end if
objMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
objMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserver") = smtp
if smtpPort <> "" then
objMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = smtpPort
else
objMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
end if
objMessage.Configuration.Fields.Update
objMessage.Send
msgbox("Email sent successfully")
end if
Fonts for the Mac usually come in .otf and .ttf files, which are OpenType and TrueType files, respectively. After you download a new font, make sure you have at least one of these two files.
Next, you should decide who will get to use the new font, particularly if you have more than one user on the computer. The answer to that question will determine whether you should copy the .otf/.ttf files to one or the other of the two folder locations below. Wether you have system administrator access also plays a role.
/Users/[username]/Library/Fonts/
/Library/Fonts/
If you only want one particular user to have access to the new font, or if you only have access to install fonts for yourself, place the font files in the first folder. If you have administrator access and would like to install his font for everyone who uses the computer, put the files in the second folder.
I actually had this issue on Dev-Notes.com for a little while. To get around it, I changed the style class for code so it looks like the following:
pre.code {
overflow: auto;
overflow-y: visible;
}
With this, when encountered with a long line of code, a horizontal scroll bar will appear to allow the user to scroll left and right instead of breaking the width and sometimes positioning of the parent DIV. Below is a demo of this CSS style.
BufferedWriter out = new BufferedWriter(new FileWriter("/folder/anotherFolder/thirdFolder/anotherFolderToMakeThisLineLong/file.txt"));
The Javascript code below provides a sample of how the user’s mouse cursor position, displayed as X- and Y-coordinates in relation to the top left corner of the page. In this example, I put the X- and Y-coordinate values in an input box, but you can tweak that to fit your needs.
The following example demonstrates how it could be done.
alter table schema1.my_table drop column unused_field;
There is also an alternative syntax that could be used to drop multiple fields at once.
alter table schema1.my_table drop (unused_field); -- Dropping one field only
alter table schema1.my_table drop (unused_field1, unused_field2); -- Dropping two fields
In the second example, if you need to drop more than two fields, just keep adding them within the parenthesis, separated by commas.
