text:
vEoa�, mimetypeapplication/epub+zipPK vE iTunesMetadata.plistK��
An EXISTS
condition tests for existence of rows in a subquery.
Table 7-11 shows the EXISTS
converts char
of CHAR
, or NVARCHAR2
datatype to a value of DATE
Note: This function does not convert data to any of the other datetime datatypes. For information on other datetime conversions, refer to TO_TIMESTAMP, TO_TIMESTAMP_TZ, TO_DSINTERVAL, and TO_YMINTERVAL. |
The fmt
is a datetime model format specifying the format of char
. If you omit fmt
, then char
must be in the default date format. The default date format is determined implicitly by the NLS_TERRITORY
initialization parameter or can be set explicitly by the NLS_DATE_FORMAT
parameter. If fmt
is J
, for Julian, then char
must be an integer.
Caution: It is good practice always to specify a format mask (fmt ) with TO_DATE , as shown in the examples in the section that follows. When it is used without a format mask, the function is valid only if char uses the same format as is determined by the NLS_TERRITORY or NLS_DATE_FORMAT parameters. Furthermore, the function may not be stable across databases unless the explicit format mask is specified to avoid dependencies. |
The 'nlsparam'
argument has the same purpose in this function as in the TO_CHAR
function for date conversion.
Do not use the TO_DATE
function with a DATE
value for the char
argument. The first two digits of the returned DATE
value can differ from the original char
, depending on fmt
or the default date format.
This function does not support CLOB
data directly. However, CLOB
s can be passed in as arguments through implicit data conversion.
The following example converts a character string into a date:
SELECT TO_DATE( 'January 15, 1989, 11:00 A.M.', 'Month dd, YYYY, HH:MI A.M.', 'NLS_DATE_LANGUAGE = American') FROM DUAL; TO_DATE(' --------- 15-JAN-89
The value returned reflects the default date format if the NLS_TERRITORY
parameter is set to 'AMERICA
'. Different NLS_TERRITORY
values result in different default date formats:
ALTER SESSION SET NLS_TERRITORY = 'KOREAN'; SELECT TO_DATE( 'January 15, 1989, 11:00 A.M.', 'Month dd, YYYY, HH:MI A.M.', 'NLS_DATE_LANGUAGE = American') FROM DUAL; TO_DATE( -------- 89/01/15
Use the CREATE
statement to create a role, which is a set of privileges that can be granted to users or to other roles. You can use roles to administer database privileges. You can add privileges to a role and then grant the role to a user. The user can then enable the role and exercise the privileges granted by the role.
A role contains all privileges granted to the role and all privileges of other roles granted to it. A new role is initially empty. You add privileges to a role with the GRANT
If you create a role that is NOT
or is IDENTIFIED
or BY
, then Oracle Database grants you the role with ADMIN
. However, if you create a role IDENTIFIED
, then the database does not grant you the role.
See Also:
Specify the name of the role to be created. Oracle recommends that the role contain at least one single-byte character regardless of whether the database character set also contains multibyte characters. The maximum number of user-defined roles that can be enabled for a single user at one time is 148.
Some roles are defined by SQL scripts provided on your distribution media.
Specify NOT
to indicate that this role is authorized by the database and that no password is required to enable the role.
Use the IDENTIFIED
clause to indicate that a user must be authorized by the specified method before the role is enabled with the SET
BY password The BY
clause lets you create a local role and indicates that the user must specify the password to the database when enabling the role. The password can contain only single-byte characters from your database character set regardless of whether this character set also contains multibyte characters.
USING package The USING
clause lets you create an secure application role, which is a role that can be enabled only by applications using an authorized package. If you do not specify schema
, then the database assumes the package is in your own schema.
Caution: When you grant a role to a user, the role is granted as a default role for that user and is therefore enabled immediately upon logon. To retain the security benefits of an application role, you must ensure that the role is not a default role. Immediately after granting the application role to a user, issue anALTER USER statement with the DEFAULT ROLE ALL EXCEPT role clause, specifying the application role. Doing so will enforce the rule that, in subsequent logons by the user, the role will not be enabled except by applications using the authorized package. |
EXTERNALLY Specify EXTERNALLY
to create an external role. An external user must be authorized by an external service, such as an operating system or third-party service, before enabling the role.
Depending on the operating system, the user may have to specify a password to the operating system before the role is enabled.
GLOBALLY Specify GLOBALLY
to create a global role. A global user must be authorized to use the role by the enterprise directory service before the role is enabled at login.
If you omit both the NOT
clause and the IDENTIFIED
clause, then the role defaults to NOT
Creating a Role: Example The following statement creates the role dw_manager
CREATE ROLE dw_manager;
Users who are subsequently granted the dw_manager
role will inherit all of the privileges that have been granted to this role.
You can add a layer of security to roles by specifying a password, as in the following example:
CREATE ROLE dw_manager IDENTIFIED BY warehouse;
Users who are subsequently granted the dw_manager
role must specify the password warehouse
to enable the role with the SET
The following statement creates global role warehouse_user
CREATE ROLE warehouse_user IDENTIFIED GLOBALLY;
The following statement creates the same role as an external role:
CREATE ROLE warehouse_user IDENTIFIED EXTERNALLY;
The storage_clause
lets you specify how Oracle Database should store a permanent database object. Storage parameters for temporary segments always use the default storage parameters for the associated tablespace. Storage parameters affect both how long it takes to access data stored in the database and how efficiently space in the database is used.
See Also: Oracle Database Storage Administrator's Guide for a discussion of the effects of the storage parameters |
When you create a cluster, index, materialized view, materialized view log, rollback segment, table, LOB, varray, nested table, or partition, you can specify values for the storage parameters for the segments allocated to these objects. If you omit any storage parameter, then Oracle uses the value of that parameter specified for the tablespace in which the object resides. If no value was specified for the tablespace, then the database uses default values.
Note: The specification of storage parameters for objects in locally managed tablespaces is supported for backward compatibility. If you are using locally managed tablespaces, then you can omit these storage parameter when creating objects in those tablespaces. |
When you alter a cluster, index, materialized view, materialized view log, rollback segment, table, varray, nested table, or partition, you can change the values of storage parameters. The new values affect only future extent allocations.
The storage_clause
is part of the physical_attributes_clause
, so you can specify this clause in any of the statements where you can specify the physical attributes clause (see physical_attributes_clause). In addition, you can specify the storage_clause
in the following statements:
and ALTER
: to set or change the storage characteristics of the cluster and all tables in the cluster (see CREATE CLUSTER and ALTER CLUSTER).
and ALTER
: to set or change the storage characteristics of an index segment created for a table index or index partition or an index segment created for an index used to enforce a primary key or unique constraint (see CREATE INDEX and ALTER INDEX).
The ENABLE
clause of CREATE
or ALTER
: to set or change the storage characteristics of an index created by the system to enforce a primary key or unique constraint.
and ALTER
: to set or change the storage characteristics of a materialized view, one of its partitions, or the index Oracle generates to maintain the materialized view (see CREATE MATERIALIZED VIEW and ALTER MATERIALIZED VIEW).
and ALTER
: to set or change the storage characteristics of the materialized view log (see CREATE MATERIALIZED VIEW LOG and ALTER MATERIALIZED VIEW LOG).
and ALTER ROLLBACK SEGMENT
: to set or change the storage characteristics of a rollback segment (see CREATE ROLLBACK SEGMENT and ALTER ROLLBACK SEGMENT).
and ALTER
: to set the storage characteristics of a LOB or varray data segment of the nonclustered table or one of its partitions or subpartitions, or the storage table of a nested table (see CREATE TABLE and ALTER TABLE).
and ALTER
: to set or change the default storage characteristics for objects created in the tablespace (see CREATE TABLESPACE and ALTER TABLESPACE). Changes to tablespace storage parameters affect only new objects created in the tablespace or new extents allocated for a segment.
: to specify storage for the index (and its partitions, if it is a partitioned index) used to enforce the constraint (see constraint).
To change the value of a STORAGE
parameter, you must have the privileges necessary to use the appropriate CREATE
or ALTER
This section describes the parameters of the storage_clause
. For additional information, refer to the SQL statement in which you set or reset these storage parameters for a particular database object.
Note: Thestorage_clause is interpreted differently for locally managed tablespaces. For locally managed tablespaces, Oracle Database uses INITIAL , NEXT , PCTINCREASE , and MINEXTENTS to compute how many extents are allocated when the object is first created. After object creation, these parameters are ignored. For more information, see CREATE TABLESPACE. |
Specify the size of the first extent of the object. Oracle allocates space for this extent when you create the schema object. Refer to size_clause for information on that clause.
In locally managed tablespaces, the value of INITIAL
, in conjunction with the values of MINEXTENTS
and PCTINCREASE
, is used to determine the initial size of the segment. For autoallocate extent management, the database determines the size of the extents that constitute the initial segment size. For uniform extent management, the number of extents is determined from initial segment size and the uniform extent size specified at tablespace creation time. For example, in a uniform locally managed tablespace with 1M extents, if you specify an INITIAL
value of 5M, then Oracle creates five 1M extents.
In dictionary managed tablespaces, the default initial extent size is 5 blocks, and all subsequent extents are rounded to 5 blocks. If MINIMUM
was specified at tablespace creation time, then the extent sizes are rounded to the value of MINIMUM
Restriction on INITIAL You cannot specify INITIAL
in an ALTER
Specify in bytes the size of the next extent to be allocated to the object. Refer to size_clause for information on that clause.
In locally managed tablespaces, the size of the NEXT
is determined by Oracle if the tablespace is set for autoallocate extent management. In UNIFORM
tablespaces, the size of NEXT
is the uniform extent size specified at tablespace creation time.
In dictionary-managed tablespaces, the default value is the size of 5 data blocks. The minimum value is the size of 1 data block. The maximum value depends on your operating system. Oracle rounds values up to the next multiple of the data block size for values less than 5 data blocks. For values greater than 5 data blocks, Oracle rounds up to a value that minimizes fragmentation.
See Also: Oracle Database Administrator's Guide for information on how Oracle minimizes fragmentation |
In locally managed tablespaces, Oracle Database uses the value of PCTINCREASE during segment creation to determine the initial segment size and ignores this parameter during subsequent space allocation.
In dictionary-managed tablespaces, specify the percent by which the third and subsequent extents grow over the preceding extent. The default value is 50, meaning that each subsequent extent is 50% larger than the preceding extent. The minimum value is 0, meaning all extents after the first are the same size. The maximum value depends on your operating system. Oracle rounds the calculated size of each new extent to the nearest multiple of the data block size. If you change the value of the PCTINCREASE
parameter by specifying it in an ALTER
statement, then Oracle calculates the size of the next extent using this new value and the size of the most recently allocated extent.
Suggestion: If you want to keep all extents the same size, then you can prevent theSMON background process from coalescing extents by setting the value of PCTINCREASE to 0. In general, Oracle recommends a setting of 0 as a way to minimize fragmentation and avoid the possibility of very large temporary segments during processing. |
Restriction on PCTINCREASE You cannot specify PCTINCREASE
for rollback segments. Rollback segments always have a PCTINCREASE
value of 0.
In locally managed tablespaces, Oracle Database uses the value of MINEXTENTS
in conjunction with PCTINCREASE
and NEXT
to determine the initial segment size.
In dictionary-managed tablespaces, specify the total number of extents to allocate when the object is created. The default and minimum value is 1, meaning that Oracle allocates only the initial extent, except for rollback segments, for which the default and minimum value is 2. The maximum value depends on your operating system.
In a locally managed tablespace, MINEXTENTS
is used to compute the initial amount of space allocated, which is equal to INITIAL
. Thereafter this value is set to 1, which is reflected in the DBA_SEGMENTS
In a dictionary-managed tablespace, MINEXTENTS
is simply the minimum number of extents that must be allocated to the segment.
If the MINEXTENTS
value is greater than 1, then Oracle calculates the size of subsequent extents based on the values of the INITIAL
, and PCTINCREASE
storage parameters.
When changing the value of MINEXTENTS
by specifying it in an ALTER
statement, you can reduce the value from its current value, but you cannot increase it. Resetting MINEXTENTS
to a smaller value might be useful, for example, before a TRUNCATE
statement, if you want to ensure that the segment will maintain a minimum number of extents after the TRUNCATE
Restrictions on MINEXTENTS The MINEXTENTS
storage parameter is subject to the following restrictions:
is not applicable at the tablespace level.
You cannot change the value of MINEXTENTS
in an ALTER
statement or for an object that resides in a locally managed tablespace.
This storage parameter is valid only for objects in dictionary-managed tablespaces. Specify the total number of extents, including the first, that Oracle can allocate for the object. The minimum value is 1 except for rollback segments, which always have a minimum of 2. The default value depends on your data block size.
Restrictions on MAXEXTENTS MAXEXTENTS
is ignored for objects residing in a locally managed tablespace.
UNLIMITED Specify UNLIMITED
if you want extents to be allocated automatically as needed. Oracle recommends this setting as a way to minimize fragmentation.
Do not use this clause for rollback segments. Doing so allows the possibility that long-running rogue DML transactions will continue to create new extents until a disk is full.
Caution: A rollback segment that you create without specifying thestorage_clause has the same storage parameters as the tablespace in which the rollback segment is created. Thus, if you create a tablespace with MAXEXTENTS UNLIMITED , then the rollback segment will have this same default. |
The MAXSIZE
clause lets you specify the maximum size of the storage element. For LOB storage, MAXSIZE
has the following effects
If you specify RETENTION
in LOB_parameters
, then the LOB segment increases to the specified size before any space can be reclaimed from undo space.
If you specify RETENTION
, or NONE
in LOB_parameters
, then the specified size is a hard limit on the LOB segment size and has no bearing on undo retention.
UNLIMITED Use the UNLIMITED
clause if you do not want to limit the disk space of the storage element. This clause is not compatible with a specification of RETENTION
in LOB_parameters
. If you specify both, then the database uses RETENTION
and MAXSIZE
In tablespaces with manual segment-space management, Oracle Database uses the FREELISTS
storage parameter to improve performance of space management in OLTP systems by increasing the number of insert points in the segment. In tablespaces with automatic segment-space management, this parameter is ignored, because the database adapts to varying workload.
In tablespaces with manual segment-space management, for objects other than tablespaces and rollback segments, specify the number of free lists for each of the free list groups for the table, partition, cluster, or index. The default and minimum value for this parameter is 1, meaning that each free list group contains one free list. The maximum value of this parameter depends on the data block size. If you specify a FREELISTS
value that is too large, then Oracle returns an error indicating the maximum value.
This clause is not valid or useful if you have specified the SECUREFILE
parameter of LOB_parameters. If you specify both the SECUREFILE
parameter and FREELISTS
, then the database silently ignores the FREELISTS
Restriction on FREELISTS You can specify FREELISTS
in the storage_clause
of any statement except when creating or altering a tablespace or rollback segment.
In tablespaces with manual segment-space management, Oracle Databases uses the value of this storage parameter to statically partition the segment free space in an Oracle Real Application Clusters environment. This partitioning improves the performance of space allocation and deallocation by avoiding inter instance transfer of segment metadata. In tablespaces with automatic segment-space management, this parameter is ignored, because Oracle dynamically adapts to inter instance workload.
In tablespaces with manual segment-space management, specify the number of groups of free lists for the database object you are creating. The default and minimum value for this parameter is 1. Oracle uses the instance number of Oracle Real Application Clusters (RAC) instances to map each instance to one free list group.
Each free list group uses one database block. Therefore:
If you do not specify a large enough value for INITIAL
to cover the minimum value plus one data block for each free list group, then Oracle increases the value of INITIAL
the necessary amount.
If you are creating an object in a uniform locally managed tablespace, and the extent size is not large enough to accommodate the number of freelist groups, then the create operation will fail.
This clause is not valid or useful if you have specified the SECUREFILE
parameter of LOB_parameters. If you specify both the SECUREFILE
parameter and FREELIST
, then the database silently ignores the FREELIST
Restriction on FREELIST GROUPS You can specify the FREELIST
parameter only in CREATE
, and CREATE
The BUFFER_POOL
clause lets you specify a default buffer pool or cache for a schema object. All blocks for the object are stored in the specified cache.
If you define a buffer pool for a partitioned table or index, then the partitions inherit the buffer pool from the table or index definition unless overridden by a partition-level definition.
For an index-organized table, you can specify a buffer pool separately for the index segment and the overflow segment.
Restrictions on the BUFFER_POOL Parameter BUFFER_POOL
is subject to the following restrictions:
You cannot specify this clause for a cluster table. However, you can specify it for a cluster.
You cannot specify this clause for a tablespace or a rollback segment.
KEEP Specify KEEP
to put blocks from the segment into the KEEP
buffer pool. Maintaining an appropriately sized KEEP
buffer pool lets Oracle retain the schema object in memory to avoid I/O operations. KEEP
takes precedence over any NOCACHE
clause you specify for a table, cluster, materialized view, or materialized view log.
RECYCLE Specify RECYCLE
to put blocks from the segment into the RECYCLE
pool. An appropriately sized RECYCLE
pool reduces the number of objects whose default pool is the RECYCLE
pool from taking up unnecessary cache space.
DEFAULT Specify DEFAULT
to indicate the default buffer pool. This is the default for objects not assigned to KEEP
or RECYCLE
See Also: Oracle Database Performance Tuning Guide for more information about using multiple buffer pools |
The OPTIMAL
keyword is relevant only to rollback segments. It specifies an optimal size in bytes for a rollback segment. Refer to size_clause for information on that clause.
Oracle tries to maintain this size for the rollback segment by dynamically deallocating extents when their data is no longer needed for active transactions. Oracle deallocates as many extents as possible without reducing the total size of the rollback segment below the OPTIMAL
The value of OPTIMAL
cannot be less than the space initially allocated by the MINEXTENTS
, and PCTINCREASE
parameters. The maximum value depends on your operating system. Oracle rounds values up to the next multiple of the data block size.
NULL Specify NULL
for no optimal size for the rollback segment, meaning that Oracle never deallocates the extents of the rollback segment. This is the default behavior.
This clause is valid only when you are creating a tablespace. Specify ENCRYPT
to encrypt the entire tablespace. You must also specify the ENCRYPTION
clause in the CREATE
Specifying Table Storage Attributes: Example The following statement creates a table and provides storage parameter values:
CREATE TABLE divisions (div_no NUMBER(2), div_name VARCHAR2(14), location VARCHAR2(13) ) STORAGE ( INITIAL 100K NEXT 50K MINEXTENTS 1 MAXEXTENTS 50 PCTINCREASE 5);
Oracle allocates space for the table based on the STORAGE
parameter values as follows:
The MINEXTENTS
value is 1, so Oracle allocates 1 extent for the table upon creation.
The INITIAL
value is 100K, so the size of the first extent is 100 kilobytes.
If the table data grows to exceed the first extent, then Oracle allocates a second extent. The NEXT
value is 50K, so the size of the second extent will be 50 kilobytes.
If the table data subsequently grows to exceed the first two extents, then Oracle allocates a third extent. The PCTINCREASE
value is 5, so the calculated size of the third extent is 5% larger than the second extent, or 52.5 kilobytes. If the data block size is 2 kilobytes, then Oracle rounds this value to 52 kilobytes.
If the table data continues to grow, then Oracle allocates more extents, each 5% larger than the previous one.
The MAXEXTENTS
value is 50, so Oracle can allocate as many as 50 extents for the table.
If a table contains hierarchical data, then you can select rows in a hierarchical order using the hierarchical query clause:
specifies the root row(s) of the hierarchy.
specifies the relationship between parent rows and child rows of the hierarchy.
The NOCYCLE
parameter instructs Oracle Database to return rows from a query even if a CONNECT
loop exists in the data. Use this parameter along with the CONNECT_BY_ISCYCLE
pseudocolumn to see which rows contain the loop. Refer to CONNECT_BY_ISCYCLE Pseudocolumn for more information.
In a hierarchical query, one expression in condition
must be qualified with the PRIOR
operator to refer to the parent row. For example,
... PRIOR expr = expr or ... expr = PRIOR expr
If the CONNECT
is compound, then only one condition requires the PRIOR
operator, although you can have multiple PRIOR
conditions. For example:
CONNECT BY last_name != 'King' AND PRIOR employee_id = manager_id ... CONNECT BY PRIOR employee_id = manager_id and PRIOR account_mgr_id = customer_id ...
is a unary operator and has the same precedence as the unary + and - arithmetic operators. It evaluates the immediately following expression for the parent row of the current row in a hierarchical query.
is most commonly used when comparing column values with the equality operator. (The PRIOR
keyword can be on either side of the operator.) PRIOR
causes Oracle to use the value of the parent row in the column. Operators other than the equal sign (=) are theoretically possible in CONNECT
clauses. However, the conditions created by these other operators can result in an infinite loop through the possible combinations. In this case Oracle detects the loop at run time and returns an error.
Both the CONNECT
condition and the PRIOR
expression can take the form of an uncorrelated subquery. However, CURRVAL
and NEXTVAL
are not valid PRIOR
expressions, so the PRIOR
expression cannot refer to a sequence.
You can further refine a hierarchical query by using the CONNECT_BY_ROOT
operator to qualify a column in the select list. This operator extends the functionality of the CONNECT
] condition of hierarchical queries by returning not only the immediate parent row but all ancestor rows in the hierarchy.
See Also: CONNECT_BY_ROOT for more information about this operator and "Hierarchical Query Examples" |
Oracle processes hierarchical queries as follows:
A join, if present, is evaluated first, whether the join is specified in the FROM
clause or with WHERE
clause predicates.
The CONNECT
condition is evaluated.
Any remaining WHERE
clause predicates are evaluated.
Oracle then uses the information from these evaluations to form the hierarchy using the following steps:
Oracle selects the root row(s) of the hierarchy—those rows that satisfy the START
Oracle selects the child rows of each root row. Each child row must satisfy the condition of the CONNECT
condition with respect to one of the root rows.
Oracle selects successive generations of child rows. Oracle first selects the children of the rows returned in step 2, and then the children of those children, and so on. Oracle always selects children by evaluating the CONNECT
condition with respect to a current parent row.
If the query contains a WHERE
clause without a join, then Oracle eliminates all rows from the hierarchy that do not satisfy the condition of the WHERE
clause. Oracle evaluates this condition for each row individually, rather than removing all the children of a row that does not satisfy the condition.
Oracle returns the rows in the order shown in Figure 9-1. In the diagram, children appear below their parents. For an explanation of hierarchical trees, see Figure 3-1, "Hierarchical Tree".
To find the children of a parent row, Oracle evaluates the PRIOR
expression of the CONNECT
condition for the parent row and the other expression for each row in the table. Rows for which the condition is true are the children of the parent. The CONNECT
condition can contain other conditions to further filter the rows selected by the query.
If the CONNECT
condition results in a loop in the hierarchy, then Oracle returns an error. A loop occurs if one row is both the parent (or grandparent or direct ancestor) and a child (or a grandchild or a direct descendent) of another row.
Note: In a hierarchical query, do not specify eitherORDER BY or GROUP BY , as they will override the hierarchical order of the CONNECT BY results. If you want to order rows of siblings of the same parent, then use the ORDER SIBLINGS BY clause. See order_by_clause . |
CONNECT BY Example The following hierarchical query uses the CONNECT
clause to define the relationship between employees and managers:
SELECT employee_id, last_name, manager_id FROM employees CONNECT BY PRIOR employee_id = manager_id; EMPLOYEE_ID LAST_NAME MANAGER_ID ----------- ------------------------- ---------- 101 Kochhar 100 108 Greenberg 101 109 Faviet 108 110 Chen 108 111 Sciarra 108 112 Urman 108 113 Popp 108 200 Whalen 101 203 Mavris 101 204 Baer 101 . . .
LEVEL Example The next example is similar to the preceding example, but uses the LEVEL
pseudocolumn to show parent and child rows:
SELECT employee_id, last_name, manager_id, LEVEL FROM employees CONNECT BY PRIOR employee_id = manager_id; EMPLOYEE_ID LAST_NAME MANAGER_ID LEVEL ----------- ------------------------- ---------- ---------- 101 Kochhar 100 1 108 Greenberg 101 2 109 Faviet 108 3 110 Chen 108 3 111 Sciarra 108 3 112 Urman 108 3 113 Popp 108 3 200 Whalen 101 2 203 Mavris 101 2 204 Baer 101 2 205 Higgins 101 2 206 Gietz 205 3 102 De Haan 100 1 ...
START WITH Examples The next example adds a START
clause to specify a root row for the hierarchy and an ORDER
clause using the SIBLINGS
keyword to preserve ordering within the hierarchy:
SELECT last_name, employee_id, manager_id, LEVEL FROM employees START WITH employee_id = 100 CONNECT BY PRIOR employee_id = manager_id ORDER SIBLINGS BY last_name; LAST_NAME EMPLOYEE_ID MANAGER_ID LEVEL ------------------------- ----------- ---------- ---------- King 100 1 Cambrault 148 100 2 Bates 172 148 3 Bloom 169 148 3 Fox 170 148 3 Kumar 173 148 3 Ozer 168 148 3 Smith 171 148 3 De Haan 102 100 2 Hunold 103 102 3 Austin 105 103 4 Ernst 104 103 4 Lorentz 107 103 4 Pataballa 106 103 4 Errazuriz 147 100 2 Ande 166 147 3 Banda 167 147 3 ...
In the hr.employees
table, the employee Steven King is the head of the company and has no manager. Among his employees is John Russell, who is the manager of department 80. If you update the employees
table to set Russell as King's manager, you create a loop in the data:
UPDATE employees SET manager_id = 145 WHERE employee_id = 100; SELECT last_name "Employee", LEVEL, SYS_CONNECT_BY_PATH(last_name, '/') "Path" FROM employees WHERE level <= 3 AND department_id = 80 START WITH last_name = 'King' CONNECT BY PRIOR employee_id = manager_id AND LEVEL <= 4; ERROR: ORA-01436: CONNECT BY loop in user data
The NOCYCLE
parameter in the CONNECT
condition causes Oracle to return the rows in spite of the loop. The CONNECT_BY_ISCYCLE
pseudocolumn shows you which rows contain the cycle:
SELECT last_name "Employee", CONNECT_BY_ISCYCLE "Cycle", LEVEL, SYS_CONNECT_BY_PATH(last_name, '/') "Path" FROM employees WHERE level <= 3 AND department_id = 80 START WITH last_name = 'King' CONNECT BY NOCYCLE PRIOR employee_id = manager_id AND LEVEL <= 4 ORDER BY "Employee", "Cycle", LEVEL, "Path"; Employee Cycle LEVEL Path ------------------------- ---------- ---------- ------------------------- Abel 0 3 /King/Zlotkey/Abel Ande 0 3 /King/Errazuriz/Ande Banda 0 3 /King/Errazuriz/Banda Bates 0 3 /King/Cambrault/Bates Bernstein 0 3 /King/Russell/Bernstein Bloom 0 3 /King/Cambrault/Bloom Cambrault 0 2 /King/Cambrault Cambrault 0 3 /King/Russell/Cambrault Doran 0 3 /King/Partners/Doran Errazuriz 0 2 /King/Errazuriz Fox 0 3 /King/Cambrault/Fox ...
CONNECT_BY_ROOT Examples The following example returns the last name of each employee in department 110, each manager above that employee in the hierarchy, the number of levels between manager and employee, and the path between the two:
SELECT last_name "Employee", CONNECT_BY_ROOT last_name "Manager", LEVEL-1 "Pathlen", SYS_CONNECT_BY_PATH(last_name, '/') "Path" FROM employees WHERE LEVEL > 1 and department_id = 110 CONNECT BY PRIOR employee_id = manager_id ORDER BY "Employee", "Manager", "Pathlen", "Path"; Employee Manager Pathlen Path --------------- --------------- ---------- ------------------------------ Gietz Higgins 1 /Higgins/Gietz Gietz King 3 /King/Kochhar/Higgins/Gietz Gietz Kochhar 2 /Kochhar/Higgins/Gietz Higgins King 2 /King/Kochhar/Higgins Higgins Kochhar 1 /Kochhar/Higgins
The following example uses a GROUP
clause to return the total salary of each employee in department 110 and all employees below that employee in the hierarchy:
SELECT name, SUM(salary) "Total_Salary" FROM ( SELECT CONNECT_BY_ROOT last_name as name, Salary FROM employees WHERE department_id = 110 CONNECT BY PRIOR employee_id = manager_id) GROUP BY name ORDER BY name, "Total_Salary"; NAME Total_Salary ------------------------- ------------ Gietz 8300 Higgins 20300 King 20300 Kochhar 20300
See Also:
Object types are defined using PL/SQL. Please refer to Oracle Database PL/SQL Language Reference for complete information on creating, altering, and dropping object types.
Use the DROP
statement to drop the specification and body of an object type, a varray, or a nested table type.
The object type, varray, or nested table type must be in your own schema or you must have the DROP
system privilege.
Specify the schema containing the type. If you omit schema
, then Oracle Database assumes the type is in your own schema.
Specify the name of the object, varray, or nested table type to be dropped. You can drop only types with no type or table dependencies.
If type_name
is a supertype, then this statement will fail unless you also specify FORCE
. If you specify FORCE
, then the database invalidates all subtypes depending on this supertype.
If type_name
is a statistics type, then this statement will fail unless you also specify FORCE
. If you specify FORCE
, then the database first disassociates all objects that are associated with type_name
and then drops type_name
If type_name
is an object type that has been associated with a statistics type, then the database first attempts to disassociate type_name
from the statistics type and then drops type_name
. However, if statistics have been collected using the statistics type, then the database will be unable to disassociate type_name
from the statistics type, and this statement will fail.
If type_name
is an implementation type for an indextype, then the indextype will be marked INVALID
If type_name
has a public synonym defined on it, then the database will also drop the synonym.
Unless you specify FORCE
, you can drop only object types, nested tables, or varray types that are standalone schema objects with no dependencies. This is the default behavior.
Specify FORCE
to drop the type even if it has dependent database objects. Oracle Database marks UNUSED
all columns dependent on the type to be dropped, and those columns become inaccessible.
Caution: Oracle does not recommend that you specifyFORCE to drop object types with dependencies. This operation is not recoverable and could cause the data in the dependent tables or columns to become inaccessible. |
If you specify VALIDATE
when dropping a type, then Oracle Database checks for stored instances of this type within substitutable columns of any of its supertypes. If no such instances are found, then the database completes the drop operation.
This clause is meaningful only for subtypes. Oracle recommends the use of this option to safely drop subtypes that do not have any explicit type or table dependencies.
Dropping an Object Type: Example
The following statement removes object type person_t
. See Oracle Database PL/SQL Language Reference for the example that creates this object type. Any columns that are dependent on person_t are marked UNUSED
and become inaccessible.
DROP TYPE person_t FORCE;
Use the ALTER
statement to modify, maintain, or recover an existing database.
Note: In earlier versions of Oracle Database, you could use theALTER DATABASE for two conversion operations:
These clauses are no longer supported. Refer to Oracle Database Upgrade Guide for more information on migration and interoperability issues. |
See Also:
You must have the ALTER
system privilege.
To specify the RECOVER
clause, you must also have the SYSDBA
system privilege.
Groups of ALTER DATABASE syntax:
recovery_clauses ::=
(general_recovery ::=, managed_standby_recovery::=)
general_recovery ::=
(full_database_recovery ::=, partial_database_recovery::=)
Note: Several subclauses ofmanaged_standby_recovery are no longer needed and have been deprecated. These clauses no longer appear in the syntax diagrams. Refer to the semantics of managed_standby_recovery. |
(create_datafile_clause::=, alter_datafile_clause::=, alter_tempfile_clause::=)
(autoextend_clause ::=, size_clause::=)
(autoextend_clause ::=, size_clause::=)
logfile_clauses ::=
(logfile_descriptor::=, add_logfile_clauses::=, drop_logfile_clauses::=, supplemental_db_logging ::=)
(redo_log_file_spec::=, logfile_descriptor::=)
(activate_standby_db_clause::=, maximize_standby_db_clause::=, register_logfile_clause::=, commit_switchover_clause::=, start_standby_clause::=, stop_standby_clause::=, convert_database_clause::=, parallel_clause::=)
(flashback_mode_clause ::=, set_time_zone_clause::=)
security_clause ::=
Specify the name of the database to be altered. The database name can contain only ASCII characters. If you omit database
, then Oracle Database alters the database identified by the value of the initialization parameter DB_NAME
. You can alter only the database whose control files are specified by the initialization parameter CONTROL_FILES
. The database identifier is not related to the Oracle Net database specification.
The startup_clauses
let you mount and open the database so that it is accessible to users.
Use the MOUNT
clause to mount the database. Do not use this clause when the database is already mounted.
MOUNT STANDBY DATABASE You can specify MOUNT
to mount a physical standby database. The keywords STANDBY
are optional, because Oracle Database determines automatically whether the database to be mounted is a primary or standby database. As soon as this statement executes, the standby instance can receive redo data from the primary instance.
MOUNT CLONE DATABASE Specify MOUNT
to mount the clone database.
Use the OPEN
clause to make the database available for normal use. You must mount the database before you can open it.
If you specify only OPEN
without any other keywords, then the default is OPEN
on a primary database, logical standby database, or snapshot standby database and OPEN
on a physical standby database.
OPEN READ WRITE Specify OPEN
to open the database in read/write mode, allowing users to generate redo logs. This is the default if you are opening a primary database. You cannot specify this clause for a physical standby database.
RESETLOGS | NORESETLOGS This clause determines whether Oracle Database resets the current log sequence number to 1, archives any unarchived logs (including the current log), and discards any redo information that was not applied during recovery, ensuring that it will never be applied. Oracle Database uses NORESETLOGS
automatically except in the following specific situations, which require a setting for this clause:
You must specify RESETLOGS
After performing incomplete media recovery or media recovery using a backup control file
After a previous OPEN
operation that did not complete
After a FLASHBACK
If a created control file is mounted, then you must specify RESETLOGS
if the online logs are lost, or you must specify NORESETLOGS
if they are not lost.
UPGRADE | DOWNGRADE Use these OPEN
clause parameters only if you are upgrading or downgrading a database. This clause instructs Oracle Database to modify system parameters dynamically as required for upgrade and downgrade, respectively. You can achieve the same result using the SQL*Plus STARTUP
or STARTUP
See Also:
OPEN READ ONLY Specify OPEN
to restrict users to read-only transactions, preventing them from generating redo logs. This setting is the default when you are opening a physical standby database, so that the physical standby database is available for queries even while archive logs are being copied from the primary database site.
Restrictions on Opening a Database The following restrictions apply to opening a database:
You cannot open a database in READ
mode if it is currently opened in READ
mode by another instance.
You cannot open a database in READ
mode if it requires recovery.
You cannot take tablespaces offline while the database is open in READ
mode. However, you can take datafiles offline and online, and you can recover offline datafiles and tablespaces while the database is open in READ
See Also: Oracle Data Guard Concepts and Administration for additional information about opening a physical standby database |
The recovery_clauses
include post-backup operations. For all of these clauses, Oracle Database recovers the database using any incarnations of datafiles and log files that are known to the current control file.
See Also: Oracle Database Backup and Recovery User's Guide for information on backing up the database and "Database Recovery: Examples" |
The general_recovery
clause lets you control media recovery for the database or standby database or for specified tablespaces or files. You can use this clause when your instance has the database mounted, open or closed, and the files involved are not in use.
Note: Parallelism is enabled by default during full or partial database recovery and logfile recovery. You can disable parallelism of these operations by specifyingNOPARALLEL as shown in the respective syntax diagrams. |
Restrictions on General Database Recovery General recovery is subject to the following restrictions:
You can recover the entire database only when the database is closed.
Your instance must have the database mounted in exclusive mode.
You can recover tablespaces or datafiles when the database is open or closed, if the tablespaces or datafiles to be recovered are offline.
You cannot perform media recovery if you are connected to Oracle Database through the shared server architecture.
Note: If you do not have special media requirements, then Oracle recommends that you use the SQL*PlusRECOVER command rather than the general_recovery_clause . |


text:
Released: Mar 17th, 2009
Running Time: 85 Min.
Director: Scott Hancock
Company: Overboard Video
DVD Extras: Still Gallery(ies)
Lindsay Kay, Sisi Sinz, Scarlett Pain, Kelly Divine, Cherry Poppens, Maya Hills, Anita Blue, Misty Vonage, April Blossom, Erika Vuiton
Critical Rating: AAA
Genre: Gonzo
Women try to take big dicks into their mouth to the hilt!
The DVD menu and subtitle suggest that there's a contest underway, although this is never addressed anywhere. We feel safe assuming that Sisi Sinz, the girl on the cover, won the contest—she gives an admirable performance and handles a throat pounding with remarkable ease. We'd like to suggest Scarlett Pain as a runner-up and give an honorable mention to Anita Blue—who may not be the best deep throater but really impresses us with her "can do" attitude.
Director Scott Hancock does a good job of switching angles, ensuring every scene isn't a clone, although his lighting could use some work.

subset: commoncrawl


text:
Seaweeds have been eaten by the seafaring peoples of Britain and Ireland for countless centuries. Below are the main varieties:
These related seaweeds are essentially the same as Japanese nori, and go by two different names: Laver is perhaps the best known of the traditional native words for this food. The name is attested in the sense of "edible seaweed" since the 17th century, although it is seen referring to indeterminate water plants long before that. Its best-known native preparation is Welsh laverbread. Another native English and British name for laver is sloak (with many regional spellings attributed to the Scots and Irish - sloke, slake, slawk, and so on).
Laver is a word of Latin origin; sloak is related to Irish slabhac and related forms.
This is the second most important edible British/Irish seaweed, known as dulse. The name comes from Celtic; compare Irish duileasg "leaf" + "water". (The Celtic word for "water" also survives in English in the word whisky.) Dulse is reddish purple and has a beautifully delicate flavor.
This dark, tough frond is often compared to Japanese wakame. Henware and badderlocks are its main native English names. The root ware, used as a word by itself regionally and in "seaware", is common in Germanic words for seaweed.
The usual English names are Carrageen, carragheen, or Irish moss, and has also been called "Carraghan moss". It has little flavor of its own and now has uses mostly as the food additive carrageenan, but in the early 19th century it saved many lives as a famine food. It is named after an Irish town near Waterford.
More general names for edible seaweeds have been sea-liverwort, and sea-lettuce, and there are doubtless others.
Seaweeds have also been used extensively as fertilizer and for fuel, going by names such as sea-wrack, sea woad, sea ore, mermaid's hair, thread-tangle, and so on. Kelp (Japanese kombu) is today the best known of the large fuel-seaweeds. The name "kelp" refers to several different plants, and it does not seem to have been eaten in traditional Britain. Its etymology, though ancient, is uncertain.
Mainstream English and French cuisine have not traditionally valued seaweeds - dulse is associated with Ireland and Scotland, while laver is considered Welsh. Here is our friend Prosper Montagné (1865-1948), writing in the Larousse gastronomique:
Sea wrack, rock-weed. ... It is said that the inhabitants of Iceland, the Faroe Islands, Scotland, Norway, Denmark and North America use it for food. It is, however, only eaten in times of scarcity, except in Scotland, where the young stems of the tangle or sea-lettuce are sometimes eaten as a salad. This dish, however, has not found much favour with any visitors who have tasted it.
One can forgive the French; they know not what they do. But for the English, perhaps it will only take a little more contact with the "other" sceptered isle to reacquaint their palates with these native British foods
Log in or registerto write something here or to contact authors.
Sign up
Need help? email@example.com


text:
Find a Mother's Day gift she'll love. See details.
Exclusive finds with a new theme each month.
Shop: Pop-In
Our director of creative projects shares what she's into.
Read More
Stay updated with a steady stream of new info.
Italian-crafted sunglasses fashioned with hints of glint on the temples sport oversized circular frames fitted with scratch-resistant gradient lenses.


text:
Text Only Version | Site Map | UMass Donahue Institute | |||
Since 1971 The UMass Donahue Institute has provided successful managers, leaders, and other professionals with training resources and consulting services needed to succeed in government, non- profits and businesses today. At The UMass Donahue Institute we know how important it is to succeed in business. Discover how we can help you succeed today. Training Consulting |


text:
Join My Voice Nation for free stuff, concert and dining info & more!
Greasy slices of Brooklyn-style round pie are served 24-7 to clubgoers after last call at this posh pizzeria located across the street from Myst. Although one end of the place is devoted...
Find the best all right here.
We're your essential guide for what to see, where to eat, and what to do, and now all of that information is on your mobile phone. For free.
Get Editors Picks of the best things going on each week, full restaurant listings, last night reviews of concerts, events, and nightlife, slideshows by the city's best party photographers, hundreds of local event listings every day, and much, much more.


text:
Released: Feb 01st, 1998
Running Time: 85
Director: Nancy Nemo
Company: Stardust Video
Dave Hardman, Don Fernando, Diana Richards, Kitty Foxx, Paul Strider, Rick Masters, Stormy Gale
Critical Rating: AAA
Genre: Specialty
If mature honeys are your bag, these bags are for you. A birthday party that's attended by some Elvis impersonators turns into an orgy. Not to be missed are the hilarious theme song, and Dave Hardman in an over-the-top Johnny Bravo wig.


text:
What non-fiction books would you recommend for a book club with kids ranging in age from 6-9?
What non-fiction books would you recommend for a book club with kids ranging in age from 6-9? We are typically doing books around 150-200 pages, and I thought it would be good to introduce a non-fiction book next month. I appreciate any input.
Asked by Tracy on the Education.com Facebook page
In Topics:
Helping my child with reading, Recommended Books
Asked by Tracy on the Education.com Facebook page
> 60 days ago
What the Expert Says:
Other Similar Questions
- My child is going into first grade. Should I review what he learned in Kindergarten or start teaching him what he will learn in 1st grade this summer?
- I love reading program
- What are books recommended for K grade?
- I am a volunteer parent tutoring a 4th grade student who is reading at a 1st grade level. I need ideas to help her pass 4th grade.
- Do you have any good 5th grade or pirate book ideas (for a 3 year old)?
- How to get kids excited about reading?
- What's a good book for kindergarten?
- My 9 year old daughter is dyslexic. Can you recommend some books that would encourage and help her read?
- What is the average second grade reading level? What books should 2nd graders be reading?
- Mockingbird reading list for 2010


text:
Talaash - Download Mp3 Song Single
Talaash (2012)
Year of Release: 2012
Cast: Aamir Khan, Rani Mukerji, Kareena Kapoor Khan, Nawazuddin Siddiqui, Shernaz Patel, Raj Kumar Yadav, Vivan Bhatena, Sheeba Chaddha, Gulfam Khan
Music Director: Ram Sampath
Lyricist: Various
MP3 Bitrate: 128 & 320 Kbps (VBR)
Description: Download & Listen Talaash Mp3 Songs at songspk in high quality mp3 format. Talaash music album containing soundtracks are available in 128kbps & 320kbps bitrate. Find all indian hindi movies albums in good quality.
Suman Sridhar
Vishal Dadlani
Sona Mohapatra, Ravindra Upadhyay
Ram Sampath
Ram Sampath
Vidhal Dadlani
Download Links - All In One [Zip Links] -
Zip File / Size: 27.6 MB -
Zip File / Size: 47.9 MB
Tags cloud: download Talaash songs, Talaash mp3 songs, download
Talaash music, Talaash hindi songs 2012, download Talaash indian movie songs, indian mp3 rips,
Talaash 320kbps, Talaash 128kbps mp3 download, mp3 music of
Talaash, Talaash tracklist, download hindi songs of Talaash,
Talaash soundtracks, download Talaash torrent, hindi mp3 songs of bollywood movies, listen online
Talaash mp3s, Talaash songspk
HTML Comment Box is loading comments...


text:
Website home
about our city
City Services
City Leadership
Public Records
Contact Us
News Home
Event Calendar
City Publications
City Cable 14
Local Media
Email Subscriptions
Follow Us:
Press Releases
City of Fort Collins Receives Colorado Parks and Recreation Association Awards
This news was released
575 days ago and may contain inaccurate information.
Contact Information
Bob Adams, City of Fort Collins - Recreation Director
John Litel, City of Fort Collins - Community Relations and Marketing
The City of Fort Collins received two awards at the Colorado Parks and Recreation Association's annual conference held in Vail, CO this fall. The Colorado Parks and Recreation Association or CPRA is a dynamic, proactive organization that creates healthy residents and livable communities by promoting excellence in parks and recreation. The association's mission is to promote the parks and recreation profession and its growth throughout the State of Colorado. In its 61st year, the association's membership is comprised of parks and recreation departments in Colorado. Every year the organization hosts a conference that provides educational sessions and honors organizations and individuals throughout Colorado.
The City's Park Planning Director, Craig Foreman, was presented the CPRA 2013 Fellow Award. According to CPRA the Fellow Award is "The highest honor bestowed upon a CPRA member." Foreman has worked for the City of Fort Collins for over 27 years and has been an integral part in the development of numerous parks and trails. Craig was honored for his dedication, leadership and his ability to collaborate successfully with other organizations. In 1986, when Foreman started working for City's Park Planning department, there were 26 parks, today there are 54 parks throughout Fort Collins. Included in that number are two 100 acre community parks – Spring Canyon Community Park and Fossil Creek Community Park. Mr. Foreman and his team have also enhanced and established the City's popular paved trail system. In 1986 the City of Fort Collins included 10 miles of trails, today citizens of Fort Collins benefit from over 32 miles of paved trails. Marty Heffernan, Community Services Executive Director, presented the Fellow Award to Foreman at the conference. During Heffernan's presentation he pointed out Craig's legacy and dedication, "In surveying the Fort Collins landscape it's guaranteed you'll find Craig Foreman's 27 year influence in just about every corner" Heffernan continued "He has shined at establishing collaborations that work and the citizens of Fort Collins have reaped the benefits."
The Colorado Association of Senior Centers (CASC), a section of CPRA, honored the Recreation Department's social event "Winter Whimsy" as the "Best Senior Center Program." "Winter Whimsy" is a fundraiser for the Senior Center's expansion project and was recognized for its innovation and for its impact on participants. The "ladies night out" event is its 4th year and features drinks, food, auctions and entertainment specifically for women. The 2014 "Winter Whimsy" event is scheduled for January 24 at the Fort Collins Senior Center. For more information on the event or to purchase tickets call 970.221.6357.
For more information:
City of Fort Collins:


text:
Directory Search
Support CMU
Press Releases
2010 Releases
Oct. 29: Alumna's Student Art Portfolio From 1940s On Display at CMU's Ellis Gallery, Nov. 4-6
Oct. 28: Obituary: Watts Humphrey Succeeded in Changing the World of Software Engineering
Oct. 27: Researchers, Educators Discuss "Science Never Seen Before" At Inaugural Scientific Conference on Gigapixel Imaging
Oct. 27: Kauffman Foundation Recognizes Carnegie Mellon As National Leader in Commercialization Efforts
Oct. 25: CMU's School of Music Celebrates Chopin's Bicentennial With Weekend of Performances, Oct. 30-31
Oct. 22: CMU's David Dzombak Selected To Participate in National Lecture Tour About Environmental Issues
Oct. 21: Carnegie Mellon Researchers Break Speed Barrier in Solving Important Class of Linear Systems
Oct. 21: Carnegie Mellon Honored With EPA's Green Power Leadership Award
Oct. 19: CMU's Information Networking Institute, Alta Associates Announce Fellowship Recipient
Oct. 19: Carnegie Mellon University President Jared L. Cohon Elected Chairman of Executive Committee of the Association of American Universities
Oct. 19: Culturally Inspired Mobile Phone Games Help Chinese Children Learn Language Characters, Carnegie Mellon Research Shows
Oct. 18: Media Advisory: CMU To Create Human Histogram of Heights in Honor of World Statistics Day
Oct. 14: "Lighthead" by CMU's Terrance Hayes Selected As a Finalist for 2010 National Book Awards
Oct. 14: CMU's Information Networking Institute, WQED Multimedia To Create Cybersecurity Outreach Programs
Oct. 13: Broadcast Advisory: Carnegie Mellon Expert Available To Discuss "Don't Ask, Don't Tell" Policy, Federal Injunction
Oct. 12: Media Advisory: Carnegie Mellon's CAUSE Lecture Series To Feature Talk on the Remaking of Black America
Oct. 12: "From Milltown to Malltown," CMU Professors Explore Steel Valley Communities Through Poetry and Photography
Oct. 12: Carnegie Mellon, FBI Announce Competition Promoting Internet Safety Awareness
Oct. 11: U.S. Department of Education Releases Teaching Guide for Fractions Developed by CMU Cognitive Psychologist Robert Siegler
Oct. 11: CMU Receives Andy Warhol Foundation Grant To Research Contemporary Artists Working at the Intersection of Art, Science and Technology
Oct. 8: Media Advisory: Carnegie Mellon and FBI Officials To Announce National Program Promoting Internet Safety
Oct. 8: Carnegie Mellon, Goldman Sachs Gives Announce $2 Million Grant To Support Students Hurt by Recession
Oct. 6: Carnegie Mellon's School of Music Stages "Mozart Scenes: The Trials of Love," Oct. 21-24
Oct. 6: Carnegie Mellon Spinoff YinzCam To Help Steelers Football Nation Stay Connected
Oct. 5: Carnegie Mellon's Metin Sitti and Colleagues Work To Use Gecko Biology for Printing Electronics on Complex Surfaces
Oct. 5: Carnegie Mellon's School of Music Celebrates Life of Pianist, Alumnus Earl Wild, Saturday, Oct. 9
Oct. 4: Carnegie Mellon University Press Acquires Stock of Eastern Washington University Press
Oct. 4: Carnegie Mellon Releases Specifications, Software For Low-Cost Automated Braille Writing Tutor
Oct. 1: CMU, MIT and Union Study Shows Collective Intelligence of Groups Exceeds Cognitive Abilities of Individual Group Members
Oct. 1: CMU's Philip R. LeDuc Named to Board of Directors For National Biomedical Engineering Society
Oct. 1: Carnegie Mellon's College of Engineering To Host Media Summit About Shift to Niche News
Student Life
About Us
Oct. 29: Alumna's Student Art Portfolio From 1940s On Display at CMU's Ellis Gallery, Nov. 4-6
| >
Press Releases
2010 Releases
> Oct. 29: Alumna's Student Art Portfolio From 1940s On Display at CMU's Ellis Gallery, Nov. 4-6
Eric Sloss / 412-268-5765 /
Alumna's Student Art Portfolio From 1940s
On Display at CMU's Ellis Gallery, Nov. 4-6
Rare Works, Titled "After Pearl Harbor," Recreate World War II Student Era
PITTSBURGH—This student art portfolio has stood the test of time.
Eleanor Wilson Stoltz, a 1945 Carnegie Tech alumna who became a professional artist and educator, will share her work created almost 70 years ago in an exhibition titled "After Pearl Harbor" in Carnegie Mellon University's Ellis Gallery Nov. 4 - 6. The exhibit recreates the World War II student era, a time when campus life changed as men enlisted to fight the war and women dominated the art studios. Additional artwork she created in her professional career and personal artifacts will be included in the exhibition.
"A portfolio like hers from this period, so complete and in such good condition is extremely rare," said CMU Archivist Jennie Benford. "It might be the only Carnegie Tech student portfolio covering the time from the 1940s, from the war period through Andy Warhol's student years."
Stoltz studied with the same art professors who taught Andy Warhol, Balcomb Green, Robert Lepper, Russell "Papa" Hyde, Wilfrid Readio, Sam Rosenberg and Robert Gwathmey. Warhol graduated from Carnegie Tech in 1949.
Her daughter Susan Stoltz, an artist, oral historian and curator, preserved the portfolio and through this exhibit introduces the Eleanor Wilson Stoltz Collection to the public. Featured drawings and many items on display will become part of the CMU Archives at the Hunt Library.
A charcoal series from life-drawing classes from 1941to 1943 are juried and date-stamped by art faculty. These artworks, some double-sided, together with a selection of oil-on-paper portraits, pencil drawings and other class assignments, comprise her student art portfolio.
A collection of metal crafts, tools, photographs, framed artworks, personal objects and archives on loan from the family supplement the exhibit. Her hand-sewn 1941 Carnegie Tech tartan plaid dress will be on display along with a self-portrait in oil, in which she employed a glazing technique using chalk to give the portrait luminosity. Selected transcripts of her memories of teachers and their methods, the art studio and campus life help tell her story.
The exhibit is free and open to the public. The Ellis Gallery is located on the third floor of the College of Fine Arts building. The gallery hours are 1 to 6 p.m. Thursday, 9 a.m. to 6 p.m. Friday, and 9 a.m. to 7 p.m. Saturday.
Eleanor Wilson Stoltz was born in Pittsburgh in 1923 and graduated from Carnegie Tech with a
bachelor's of fine arts
degree in art education. Like Warhol, she was selected from her grade school to participate in exclusive Saturday art classes for children at the university.
She supported herself through window display work at local department stores. In 1947, she married Jim Stoltz, a Carnegie Tech electrical engineering student and World War II veteran. An art teacher and supervisor in Pittsburgh area public schools, Stoltz started two children's art schools, one in Ben Avon, Pa., and a Saturday art school in Wauwatosa, Wis. She returned to Pittsburgh in 1969 and taught art in the public schools into her 70s. She has four daughters.
Susan Stoltz lives in New York City. She holds a master's degree in studio art from New York University and has exhibited art and film in New York City and abroad including the Moscow Film Festival. She co-produced and directed a National Public Television Series in 1995 about the lives of women artists, including "Life Paths & Choices and Our Mothers/Ourselves." She created a performance about the parallel lives of Warhol and her mother, which was performed at the Knitting Factory in 1993.
Self-portrait in Studio, oil on board, 20x24 inches, photo courtesy of Eleanor Stoltz


text:
Chad showing us his ink during the LIVE WAAF interview @ The Middle East!
Tour Date:
Middle East Upstairs Being upfront definitely has it's advantages!!!!! Glad I was ready with the camera!!! ;)
(2 votes)
For more information on riredrocker (as well as more of their photos, videos and blogs), click on their name to visit their profile.


text:
Atlanta, GA - Free Redfin Home Buying Class
- 848 Peachtree Street Northeast, Atlanta, GA 30308, USA
Redfin's Free Title Class - Burbank, CARedfinMonday, December 10, 2012 from 6:30 PM to 8:30 PM (PST) |
Learn how to Protect Your Most Valuable Investment!
Foregoing title defects must be eliminated in order to close and insure the buyer with a clear title. It's important to be aware of these potential problems.
Join expert Redfin Agent Eric Tan and Equity Title Company expert Tiffany Grimm as they discuss the potential title clearance issues you could face as a homeowner. We'll explain the necessary documentation required and how to go about clearing problems from your title.
Potential Title Clearance Problems for Owners:
Your Host, Redfin Listing Specialist Eric Tan
Eric Tan is an attorney and Redfin's Los Angeles Listing Broker. He's helped over 43 people buy and sell. Want to meet him before the class or just have a quick question? Feel free to give him a call at (310) 995-4292 or email him at email@example.com. He's happy to answer all of your home buying and selling questions.
Free dinner and parking!
(Redfin will host your self parking, bring your ticket in with you to the class!)
Free and Never any Obligation
Our mission is to reinvent real estate. A big part of this means we want you to be as informed as possible about buying or selling a home. Attending this class doesn't obligate you to work with a Redfin agent; just come to learn, eat, and drink!
In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.


text:
punch & judy magic lantern hand painted victorian rare it... Read more
Stay informed of the latest antiques news and offers by signing up for our FREE monthly newsletter here:
Sell your antiques on Antiques.co.uk - simple fee structure, NO commission, HUGE global audience.
register nowTo browse the directory of sellers, simply click on the region of the map in which you'd like to search, or enter a keyword and/or specialisation into the form fields below.
You can search for specific seller names, towns, counties or keywords.


text:
Stephanie Rinish and Joseph Osmanski were united in marriage on Oct. 4, 2013, at St. Anthony's Maronite Church, Wilkes-Barre, Pa. The ceremony was performed by Father Hanna Karam.
The bride is the daughter of Sandra Rinish, Plains Township, and the late Lawrence Rinish.
The groom is the son of Ilene Osmanski, Wilkes-Barre, and the late Joseph Osmanski.
The bride was escorted down the aisle and given in marriage by her mother. She chose her daughter, Kennedy Rinish, as maid of honor. Bridesmaids were Dawn Frew and Karen Shedlock, friends of the bride.
The groom chose his best friend, Robert Galuska, as best man. Groomsmen were Kevin Osmanski, brother of the groom, and Michael Osmanski Jr., nephew and godson of the groom. Flower girl was Brealynn Rinish, niece of the bride.
A scripture reading was given by Christine Osmanski, sister-in-law of the groom. Musical selections were provided by Olivia Richards.
The bride was honored with a bridal shower given by her bridesmaids at the Palmer House. A rehearsal dinner was held at Leggio's Restaurant, Plains Township. An evening reception was held at the Pittston Township Fire Hall.
The bride is a 1996 graduate of Coughlin High School. She attended King's College and graduated in 2003 with a Bachelor of Arts degree in psychology. She also attended Allied Medical and Technical Institute and graduated in 2009 with an EKG, phlebotomy and lab assistant degree. She is employed as a phlebotomist with Commonwealth Health and as a front-end coordinator with Wegmans.
The groom is a 1986 graduate of GAR Memorial High School. He attended King's College and graduated in 1998 with a Bachelor of Science degree in business administration, with a minor in computer information systems. He is employed as an information analyst with InterMetro Industries and as a course instructor with Fortis Institute.
The couple honeymooned on a cruise to Bermuda. They reside in Pittston.


text:
The Lying Game: Season 2
# | Air Date | Title |
1 | Jan 08 2013 |
The RevengersAlec is in jail following his arrest for Derek's murder, but he still manages to unnerve Emma, who is desperate for answers. Rebecca and Sutton's mother-daughter bo… |
2 | Jan 15 2013 |
Cheat, Play, LoveSutton steps up her plans to win back Ethan, and makes a point to let Emma know her intentions. Feeling left out of Emma and Thayer's growing closeness, Mads visits her f… |
3 | Jan 22 2013 |
Advantage SuttonRebecca advises Sutton to reclaim her life, leading Sutton to challenge Emma to a tennis match – winner gets to live as Sutton Mercer. Ethan is in danger of failing out o… |
4 | Jan 29 2013 |
A Kiss Before LyingEmma learns more about what happened the night Sutton's car went into the lake, raising her suspicions about whether her sister has been truthful. Ted invites his family… |
5 | Feb 05 2013 |
Much Ado About EverythingEmma and Thayer further their investigation into the twins' birth mother and what Sutton may know about her. Laurel begins to suspect that something is not right with her… |
6 | Feb 12 2013 |
Catch Her in the LieThe Flipside Formal offers Emma the chance to try and trap Rebecca and Sutton in a lie, but she needs Ethan's help to pull it off. Laurel struggles with where her loyalti… |
7 | Feb 19 2013 |
Regrets OnlyEmma struggles to make sense of newfound revelations and shifts in her relationships with Ethan and Thayer. After hearing Emma's suspicions about Rebecca, Sutton's… |
8 | Feb 26 2013 |
Bride and Go SeekEveryone gathers to celebrate Dan and Theresa's wedding but the celebrations do not go off as planned. Ethan figures out who Emma is protecting and confronts her about sh… |
9 | Mar 05 2013 |
The Grave TruthEthan's confession to Dan threatens to shatter the brothers' relationship forever. Sutton receives a mysterious phone call that may provide some valuable informatio… |
10 | Mar 12 2013 |
To Lie ForThe charity gala takes a somber turn as everyone honors the memory of a loved one. Dan issues Ethan an ultimatum that has heartbreaking consequences. Emma finally confronts Reb… |


text:
Also on offer at all 11 hotels through the duration of the festival is the �Blossoms & Bubbles� package, which includes a locally handcrafted cherry blossom soap, a $25 dining or parking credit per day, and bubbles for kids at check-in. Package rates start at $159 at Morrison House and Hotel Monaco Alexandria.
[Photo: Joy Asico]


text:
Bookshelf Home | Contents | Index | PDF |
Siebel eScript Language Reference > Siebel eScript Commands > The Math Object > Math.pow() MethodThis function returns the value of its first parameter raised to the power of its second parameter. SyntaxReturnsThe value of x to the power of y. UsageThis function returns the value of x raised to the power of y. ExampleThis example uses the Math.pow() function to determine which number is larger: 99^100 (99 to the 100th power) or 100^99 (100 to the 99th power). Note that if you attempt to use the Math.pow() method with numbers as large as those used in the example in Math.log() Method, the result returned is function Test_Click () See Also |
Siebel eScript Language Reference |


text:
Noisebridge logo
Motto | "Be Excellent to Each Other" |
Formation | 2007 |
Purpose | Hacking |
Location | |
San Francisco, California |
Jacob Appelbaum, Mitch Altman, volunteers |
Affiliations | Pumping Station: One, Chaos Computer Club, Metalab, NYC Resistor and similar |
Website | www |
Noisebridge is an award-winning[1][2] anarchistic educational hackerspace in San Francisco, inspired by hackerspaces in Europe, like the Metalab in Vienna and c-base in Berlin. It is a registered non-profit California corporation, with IRS 501(c)(3) charitable status.[3] According to the Noisebridge website's Vision page, "Noisebridge is a space for sharing, creation, collaboration, research, development, mentoring, and of course, learning. Noisebridge is also more than a physical space, it's a community with roots extending around the world."[4][5] It was organized and began regularly meeting in 2007 and has had permanent facilities since 2008.[6]
Noisebridge encourages participation by anyone who feels they can contribute, and non-members are welcome at the space at any time. All workshops and activities are free, with some exceptions for materials costs, and all are open to the public.
Noisebridge members have been involved with major award-winning research projects. This includes winning the best paper awards[citation needed] from top tier academic conferences such as Usenix Security Conference[7] and CRYPTO[8][9]
Noisebridge operates a lights-out cloud computing lab[10] with more than 100 computer cores and contributes resources to several open source projects, including the GCC compile farm.
Community participation[edit]
Noisebridge members regularly speak at events around the world such as Defcon, Blackhat, The Chaos Computer Club's Chaos Communications Congress, CCC Camps, HOPE, and more, as well as present at local events such as Maker Faire, and contribute to the founding of hackerspaces elsewhere.[11] It is well known for its Five Minutes Of Fame event as well as hosting the local San Francisco Dorkbot.
Noisebridge has an active near space exploration program, which has launched weather-balloon probes exploring altitudes of nearly 70,000 feet, carrying a variety of smartphones and digital cameras for imaging and altitude sensing using a GPS system.[12][13][14][15] Altitudes reached have exceeded the operational limits of consumer level GPS systems.[16]
Media coverage[edit]
Noisebridge won the SF Bay Guardian 2010 Best of the Bay award as "Best Open Source Playground"; the review concluded, "the vibe is welcoming and smart."[1] In 2011 the SF Weekly awarded Noisebridge Best of San Francisco as "Best Hacker Playground", describing it as "the ultimate in DIY ethic" and noting its "distinctive sense of humor."[2] Noisebridge has been covered by international media for a myriad of projects involving their membership, in NPR,[17] the BBC,[14] Wired,[13] The Guardian,[18] CNET,[5] Le Monde, which covered biohacking classes at Noisebridge,[19] Heise Online, ORF, Irish Times, Die Welt Online, Die Zeit Online, Der Standard, and elsewhere.[20] The Noisebridge policy is open access for all; as a result, homeless people can attend to craft things to earn money, but there have also been repeated thefts of tools, computers, and the donation box. [1].
Physical space[edit]
During most of 2007 and 2008, Noisebridge was a group of people meeting in new locations weekly. In October 2008 the Noisebridge group began renting a commercial property in San Francisco's Mission District,[6] but it quickly outgrew that location. In September 2009 Noisebridge moved to a much larger facility a few blocks south on Mission Street.[21] The current space has a machine shop, optics lab and darkroom, kitchen,[5] two classrooms, areas for electronics work and sofas for laptop work and socializing.[21]
- ^ a b "Best Open Source Playpen". Best of the Bay 2010 - Editor's Picks - City Living. SF Bay Guardian. July 27, 2010. Retrieved 2010-12-05.
- ^ a b "Best Hacker Hangout - 2011 - Noisebridge". Best of San Francisco 2011 - People & Places. SF Weekly. May 19, 2011. Retrieved 2011-05-19.
- ^ "Search Charitable Organizations". Internal Revenue Service. Retrieved 2010-12-04.
- ^ "Noisebridge website's Vision page". Noisebridge. Retrieved 2010-12-03.
- ^ a b c Elinor, Mills (November 30, 2009). "Building circuits, code, community at Noisebridge hacker space". CNET News. Retrieved 2010-12-03.
- ^ a b O'Brien, Danny (October 24, 2008). "Hackers need space to innovate". Irish Times. Retrieved 2010-12-03.(subscription required)
- ^ "Lest We Remember: Cold Boot Attacks on Encryption Keys". Proc. 17th USENIX Security Symposium (Sec '08), San Jose, CA,. Princeton University. July 2008. Retrieved 2010-12-03.
- ^ "CRYPTO 2009: Program: Best-paper award for Short Chosen-Prefix Collisions for MD5 and the Creation of a Rogue CA Certificate". iacr.org. International Association for Cryptologic Research. August 16, 2009.
- ^ "MD5 considered harmful today: Creating a rogue CA certificate". 25th Annual Chaos Communication Congress. Berlin. December 30, 2008. Retrieved 2010-12-03.
- ^ "Noisecloud". Noisebridge. Retrieved 2010-12-13.
- ^ Aithal, Archana (25 April 2011). "Xinchejian: Hackerspace Shanghai". CNN International.
- ^ Ganapati, Priya (February 12, 2010). "DIY Group Sends $25 Balloon to 70,000 Feet". Wired.com. Retrieved 2010-12-04.
- ^ a b Ganapati, Priya (August 12, 2010). "Amateurs Fling Their Gadgets to Edge of Space". Wired.com.
- ^ a b Knowles, Jamillah (August 19, 2010). "Hackspaces get closer to home". BBC. Retrieved 2010-12-03.
- ^ "Spacebridge". Noisebridge. Retrieved 2010-12-03.
- ^ "Spacebridge Alpha Launch". Noisebridge. Retrieved 2010-12-04.
- ^ Kalish, Jon (November 21, 2010). "DIY hackers tinker everyday things into treasure". NPR. Retrieved 2010-12-03.
- ^ "Hackers of the world unite". The Guardian. January 13, 2010.
- ^ Eudes, Yves (September 4, 2009). "Biohackers: les bricoleurs d'ADN (Biohackers: DIYers of DNA)". Le Monde. Retrieved 2011-01-04.
- ^ "Noisebridge website's Media coverage page". Noisebridge. Retrieved 2010-12-03.
- ^ a b Martínez-Cabrera, Alejandro (September 11, 2010). "Hackerspaces nurture creative spirits". San Francisco Chronicle. Retrieved 2010-12-04.
External links[edit]
Wikimedia Commons has media related to Noisebridge. |
- "Noisebridge website's Board and Officers page". Noisebridge. Retrieved 2010-12-03.
Coordinates: 37°45′45″N 122°25′10″W / 37.762413°N 122.419313°W


text:
Property Condition Report - Move In Checklist |
carefully documented Property Condition Checklist The Condition Inspection Report may be used with or without a Security Settlement Statement, but I have had better success using both together. This document is not only a complete condition checklist at Move -In and Move - Out, signed by the tenant at move -in, it also puts the tenant on notice that the condition has been documented, dated and acknowledged. It is very important for the landlord to establish the condition of the premises before the lease begins and after the term ends. It will be very difficult for the tenant to argue the facts noted on this form which is signed by them! Video and Photo reminder: Tenants are reminded that the premises may have been photographed and video taped prior to occupancy and also upon vacancy. Includes a Security Settlement section to calculate any deductions Using The Condition Inspection Report along with the Security Settlement Statement will afford maximum landlord protection. As long as your charges are legitimate and conform to your lease agreement, it is very unlikely that any deductions will be challenged by the tenant. |
© 2000-2015 The Landlord Protection Agency, Inc.


text:
Reibach & Co.
Designer(s): Manufacturer(s): Please Login to use shopping lists. |
Product Awards
Games Magazine Awards
Best Family Card Game, 1997
Best Family Card Game, 1997
Spiel des Jahres
Nominee, 1996
Nominee, 1996
Deutscher Spiele Preis
4th place, 1996
4th place, 1996
Product Information
Alan R Moon ,Mick Ado Manufacturer(s):
FX Schmid Germany Year: 1996
Players: 3 - 5
Time: 60 minutes
Ages: 12 and up
Weight: 310 grams
Language Requirements: Game components are language-independent. An English translation of the rules is provided.
You might be interested in these related products as well:
Other Resources for Reibach & Co.:
Board Game Geek is an incredible compilation of information about board and card games with many descriptions, photographs, reviews, session reports, and other commentary.


text:
Home | About us | Commercial Photography | Gallery | Articles/reviews/blog | ||||||||||||
Keith Cooper (more biographical details)"I hope you enjoy some of the images I've got on this site, both landscape and commercial. If you are looking for a commercial photographer, then I hope some of my passion and interest for the subject comes across, and you can see how I could help get the photographs you want." "My Landscape photographs reflect a desire to capture the essence of a scene, from seashores to distant mountains. They are windows — I want people to be able to revisit them and share some of the emotions and wonder I feel when taking them. For me they work when people feel, even for a moment, that they are somewhere else. I'm pleased to be able to present some of my work through Northlight Images and hope that above all, people enjoy looking at what is here." Most of Keith's landscape work is sold through exhibition and personal recommendation, to corporate and private clients, however the limited edition of works presented here is offered for sale by Northlight Images in a variety of sizes and mounting options. This is explained in the 'Buying prints' section. Keith is happy to discuss direct commissions for specific work and locations (contact details above). Keith Cooper holding a 40"x30" print, with a 26"x16" framed print on the wall behind him. Keith has produced these exclusive versions of some of his most popular works for Northlight Images. The images presented here cannot truly do justice to a carefully framed 25x17 inch print (~63x43 cm), but will give some insight into the range of Keith's work. Please do have a look at the 'Viewing tips' page to ensure that your monitor is set up to display images at their best. About the printsThe prints themselves are printed using high quality pigment based inks to give a range of tone and detail that is difficult to achieve with conventional darkroom processes. We produce prints to look their best under specific lighting conditions and are happy to discuss your detailed requirements before printing. Digital technology has advanced to the stage where Keith now uses it for almost all of his work. He has written several articles (in our articles section) covering the transition to digital and its comparison with film. The latest advancements in the printing process at Northlight Images utilise high resolution digital printers, and specially formulated ink sets. The fine art prints are printed onto high quality specialist papers and have optional environmental protective coatings to ensure quality standards for our clients. Please feel free to contact us if you would like any more technical information about the prints, or the processes used. Other areas of our site that may be of interest... All new material appears on the Articles, news and reviews page. We've a whole section of the site devoted to Digital Black and White photography and printing. It covers all the specialist articles and reviews written by Keith Cooper. We've many other Photography Articles and Photographic equipment and software reviews on the site aimed at helping you get the best out of your own photography. There is a gallery of landscape photography and fine art prints. Visiting Leicester or wondering where it is? We have views from the Leicester traffic cameras. |


text:
Campbell, Catherine and Williams, Brian (1999) Understanding the impact of a community-led HIV prevention programme in South Africa: context, conceptual framework and methodology. Australian Journal of Primary Health, 5 (4). pp. 9-23. ISSN 1324-2296
Full text not available from this repository.Abstract
In this paper we provide an account of our multi-dimensional evaluation of a community led HIV-prevention program in the southern African mining community of Carletonville. The Mothusimpilo Project has three pillars: peer education and condom distribution, syndromic management of sexually transmitted diseases (STDs), and stakeholder mobilisation. Substantial efforts are being made to evaluate the impact of the intervention and in this paper we outline the theoretical rationale, research design and some preliminary results of the evaluation. The first section provides the setting for the evaluation work, viz an intervention which seeks to contextualise traditional biomedical and behavioural approaches to HIV-transmission within their broader community and social contexts. In the second section we outline the theoretical assumptions underlying the evaluation (which has both 'outcome evaluation' and 'process evaluation' components). In particular, we discuss the way in which the concepts of identity, empowerment and social capital are used to understand the processes involved in health-enhancing behaviour change. In the third section we describe our multi-disciplinary evaluation methodology and present some preliminary findings from our on-going evaluation study. One important goal of our evaluation research is to demonstrate the extent to which community level factors serve to assist or hinder the project in achieving its goals. In this way we hope to contribute to understandings of the role of community participation in influencing the outcomes of community-based health promotional projects.
Item Type: | Article |
Official URL: | http://www.publish.csiro.au/nid/261.htm |
Additional Information: | © 1999 La Trobe University |
Library of Congress subject classification: | R Medicine > RA Public aspects of medicine |
Sets: | Research centres and groups > LSE Health Departments > Social Psychology |
Date Deposited: | 21 May 2010 09:33 |
URL: | http://eprints.lse.ac.uk/7435/ |
Actions (login required)
Record administration - authorised staff only |


text: He lived to relate this story of his near death, and lived until his middle 60's. This story was related by him to Bobby's brother. The German prisoner of war reminds me of the Hippocratic oath that doctors have to make and shows how much has changed in our modern times. The modern version of the Hippocratic oath is still very virtuous but is being disparaged in some areas today, especially in the area of deaths of little babies, yet unborn.


text:
Student Affairs
Julie Arnold Director of International Affairs and Studies email@example.com |
Amanda Atchison Coordinator of Multicultural Affairs Volleyball Assistant Coach King Hall Residence Coordinator Amanda Atchison assumed the position of Coordinator of Multicultural Affairs in May 2012 following her graduation with a master's from Heidelberg, and will be a Residence Coordinator living in King Hall. Amanda is primarily responsible for developing and facilitating programs / services for historically underrepresented students, working to improve awareness and appreciation for racial and cultural diversity, and strengthening retention and academic success. firstname.lastname@example.com |
Dustin Brentlinger Dean of Student Affairs email@example.com |
Andrea (Wensowitch) Fillipovich Director of Student Engagement Andrea, from Ennis, Texas, is in her fourth year at Heidelberg University. Prior to joining Heidelberg, Andrea worked in London, England, for several years in recruitment and international admissions. Andrea earned a Masters degree in College Student Personnel at Bowling Green State University and a Bachelors of Business Administration in Marketing and Management at Texas Woman's University. Andrea is responsible for the following areas:
firstname.lastname@example.com |
Jeff Garvin Director of Athletic Marketing and Information firstname.lastname@example.com |
Kristen Lindsay Assistant Dean of Student Affairs for Student Success Director of the Academic & Career Support Center email@example.com |
Jeff Rhoades Director of Security and Safety email@example.com |
Paul Sittason Stark Chaplain Director of Religious Life and Civic Engagement firstname.lastname@example.com |
Kayela Tidrick Director of Wellness and Healthy Living email@example.com |
Mark Zeno Assistant Dean of Student Affairs for Campus Life Mark is the Assistant Dean of Student Affairs for Campus Life. He graduated from Heidelberg in 1996 with a CIS degree. He also completed a masters degree in Higher Education Administration in 1998 from the University of Akron. Currently, Mark is completing his PhD in Higher Education Administration from Bowling Green State University (anticipated completion in 2015). Mark has worked at many institutions around Ohio such as Ohio Wesleyan University, Ashland University and Case Western Reserve University. He also spent 2 years at Baker University in Baldwin City, Kansas before returning to Heidelberg. Mark enjoys serving the community as a member of the Tiffin Kiwanis Club, spending his free time restoring old cars, and traveling with his family and friends. email@example.com |
Name | Title | Email Address | Phone Number |
Peggy George | Administrative Assistant to the Dean of Student Affairs | email@example.com | (419)-448-2062 |
Rebecca Gosche | Assistant Director of Stoner Health Center | email@example.com | (419)-448-2041 |
Lindsay Kagy | Administrative Assistant | firstname.lastname@example.com | (419)-448-2207 |
Stephanie Lehman | Housing Coordinator | email@example.com | 419-448-2214 |
Teresa Schmidt | Administrative Assistant | firstname.lastname@example.com | (419)-448-2058 |
Mark Zeno | Assistant Dean of Student Affairs for Campus Life | email@example.com | (419)-448-2058 |


text:
Share your thoughts
What do you think of the
The North Face Altea 35 Backpack - Women's - 2150cu in
? Share a...
Here's what others have to say...
Women need women packs
What a difference this pack makes!. Being prior military, I have first hand experience on what an ill-fitting pack can do to your body. Sore shoulders, sore hips, chaffing, even blisters!
This pack fit perfectly in the hip strap and shoulder straps. The only things I would change are longer straps on the bottom (sleeping bag mat would not fit) and additional pockets throughout the center of the pack. While the top pouch and hip strap pockets are nice, I prefer having extra storage in the center area of the pack.
There is also a camel back pouch that I did not get a chance to use.
Mel Nisbet
A great pack if you are able to go light
I got this pack to force myself into packing light on short trips and use it for everything from hiking trips to relaxing weekends away. The windtunnel back keeps me comfortable hiking in the hot Australian summer and the rain cover keeps everything dry when I get caught in heavy rains. Using the compression straps I can use the pack as carry-on luggage when flying and the multiple access points mean that I can easily access anything without having to empty out half my gear.


text:
Results 1 to 3 of 3
- Join Date
- Dec 2012
- Location
- High Wycombe
- Posts
- 67
Graduate entry applicants or students
Has anyone applied here with an adult nursing degree, and received a place?? Not sure whether to apply here or not.
- Join Date
- May 2012
- Location
- -
- Posts
- 14
as long as your degree matches their specific entry criteria sheet (available on their website). you should go ahead and apply. however i do not think adult nursing involves any lab work. imperial require 100+ hours of lab work.
- Join Date
- Oct 2009
- Posts
- 5
Your best bet would be to call them up directly and ask about it. I had the same issue with not being sure my degree would be suitable due to the 100 hours of lab work requirement, but the lady I spoke to said they were not too strict about it, and that the cadaver dissection I have carried out and in some cases even clinical visits would be sufficient.
However, like I said, don't take my word for it, call them up and ask for yourself. Here's the number I used - +44 (0)20 7594 7259. They may be a bit busy now with interviews and processing applications but it's still worth trying to give them a call sometime this week. If not, I'm assuming you're finding out for 2014 entry so you've got a fair bit of time still.
Also, here is the link for their graduate degree checklist messi10 referred to - https://workspace.imperial.ac.uk/ugp...0Checklist.pdf.
Hope this helps a bit!
Similar Threads
Requests for Testimonials - Graduate Entry Applicants
By DPSM in forum Mature StudentsReplies: 249Last Post: 03-09-2010, 10:02 PM -
Graduate entry applicants
By MissD in forum Cambridge Medical SchoolReplies: 109Last Post: 24-11-2009, 01:34 PM -
Graduate Entry Students
By genetik in forum Liverpool Medical SchoolReplies: 20Last Post: 23-04-2009, 12:59 PM -
Graduate Entry Med Students
By Ahhhhhh in forum Access to MedicineReplies: 3Last Post: 20-09-2006, 01:59 AM -
Calling all Applicants to Cambridge graduate Entry Course(CGCM)- 2005
By sea203 in forum Cambridge Medical SchoolReplies: 0Last Post: 26-12-2005, 08:13 PM


text:
You may also like
Rate Dr. Alan H. Kanter
Dr. Alan H. Kanter's Ratings
I am very happy with the results of my spider vein treatment on my legs. This place is THE best....they specialize in vein treatment. I wish I would have done it sooner. I can wear shorts again! Hooray.
Thank you Dr. Cantor. Deborah M.
Was this rating useful? 0 [[ userState['ratings'][2793316].votes_count ]]
My experiences with Dr. Kanter and his staff have all been absolutely wonderful. I was treated for spider veins on my legs and the results have been phenomenal. The veins on the inside of the knee disappeared after one treatment and have never returned, but this wasn't even the greatest success. I had a stubborn patch of veins on the back of my right leg that had previously been treated by two other doctors, one of which treated them three times. They never disappeared. When I went to Dr. Kanter, he assured me he would do everything he could to help me with these embarrassing veins and he was true to his word! He treated them once, with only minor improvement, but on the second treatment he tried injecting them much higher in my leg than where the veins actually were. He said that the veins above may have been "feeding" the lower ones. He was absolutely right! They completely disappeared just in time for my honeymoon! I am ecstatic about the results. I can now wear shorts and skirts without being embarrassed, and I haven't been able to do that for years. Thank you, Dr. Kanter!
Was this rating useful? 0 [[ userState['ratings'][2564080].votes_count ]]
I went to Dr. Kanter late April of this year. I had several spider veins around my ankles. He did an amazing job on my ankles, I had a wonderful summer in my shorts and skirts. He is the top professional at what he does, didn't miss one. The staff is knowledgeable and fun, I love to go to Dr. Kanter. He has changed my life twice now and if you are looking for the best doctor for your legs, whatever your problem is, look no further. Really, really, takes the time to make sure you are having the proper treatment and explains the process to you expertly. Again, thank you Dr. Kanter for changing my life! Gail B.
Was this rating useful? 0 [[ userState['ratings'][2550308].votes_count ]]


text:
That AMV was under my supervision, if it looks crappy i'm the one to be blamed.
yeah, yeah, i made an AMV, this AMV has something special it has reggeaton instead of deth metal as usual.
That AMV was under my supervision, if it looks crappy i'm the one to be blamed.
good job looks like your other one u made ketaro
Full Metal Alchemist - Anime news information and lots of fun.
Anime Gallery - Check out the image gallery for some cool anime pictures.
Anime Forums - Join my anime forums and help us grow while talking about what you love best anime!
Not bad... Good job!
can you tell me what an amv???
anime music video...Originally Posted by jeilee
The AMV looks great
Only I really hate the song! (thats personal I know)
If men where made to think, women where made to tell them they thought wrong
(Just kidding guys )


text:
Fantasy Football: Breaking down the Seattle Seahawks
• Inside the Locker Room
With freelance writer Dan Raley
Mike Williams was able to make a comeback in Seattle with his former USC coach Pete Carroll. Should fantasy players be concerned that this was just a one-year wonder situation?
Williams was motivated to get in shape and...


text:
An Empirical Investigation of International Asset PricingRobert A. KorajczykNorthwestern University - Kellogg School of Management Claude VialletINSEAD August 1, 1989 Review of Financial Studies, Vol. 2, No. 4, pp. 553-585, 1989 Abstract: We investigate several asset pricing models in an international setting. We use data on a large number of assets traded in the United States, Japan, the United Kingdom, and France. The models together with the hypothesis of capital market integration imply testable restrictions on multivariate regressions relating asset returns to various benchmark portfolios. We find that multifactor models tend to outperform single-index models in both domestic and international forms especially in their ability to explain seasonality in asset returns. We also find that the behavior of the models is affected by changes in the regulatory environment in international markets. Number of Pages in PDF File: 71 Keywords: International CAPM, International APT, International Asset Pricing JEL Classification: G10, G12, F30 Date posted: October 25, 2011Suggested Citation |
© 2015 Social Science Electronic Publishing, Inc. All Rights Reserved.
Terms of Use
Privacy Policy
Contact Us
This page was processed by apollo5 in 0.265 seconds


text:
There are a lot of reasons to try Bill Pay online—it's safe, fast, easy, and convenient —and so much easier than writing checks, you'll wonder why you didn't try it sooner.With Bill Pay online, you can:
You'll even save money on stamps. There's no reason not to sign up for online Bill Pay.Get Bill Pay online–sign up today by clicking on the Bill Pay link within Online Banking. Check out our online video demonstration for Bill Pay or call 800.562.0999 for more information.


text:
2009 Austin Music Awards
Best Performing Bluegrass Band
Bob Schneider's Texas Bluegrass Massacre
Rolf, Oliver Steck, Conrad Choucroun, Warren Hood, Bob Schneider
'Best Performing Bluegrass Band'
2008 Austin Music Awards
Bob Schneider's Texas Bluegrass Massacre
Oliver Steck, Heather Woodrow, Conrad Choucroun, Bob Schneider, Rolf, Bruce Hughes
photo: Austin Chronicle
On March 21, 2008 The Siekers were inducted into the Gatesville Country Music Hall Of Fame.
Playing fiddle with us on stage is Zach Long
Rolf Sieker - Texas State
Banjo Champion 2001
by Eddie Collins | ||
Rolf Sieker who moved from Berlin, Germany to Texas a little more than a year ago won the Texas State Banjo Championship 2001. He was pictured in the May 1998 issue of Banjo Newsletter after aquiring Bobby Thompson's famous Baldwin studio banjo. Rolf put that very special banjo to good use in winning that championship. The tunes he performed were "Pickaway", "Dixie Hoedown", "Sweet Georgia Brown" and "High Performance", - an original tune that he recorded on his tribute album to Bobby Thompson, Nashville Cat.
| |
Shawn Spiars (3rd place), Rolf Sieker (1st place), Chris Hirsch (2nd place)


text:
Welcome to our new Online Shop Dark World Creations strives to make the highest quality resin models that we possibly can by making use of the most up to date technology. All of our models are cast in polyurethane resin, which gives our models the highest level of detail possible.
You can follow us on:


text:
Jump to Content
Search OAC
Browse Institutions
Browse Collections
Browse Map
About OAC
What is OAC?
> Home
> Seaver Center for Western History Research, Natural History Museum of Los Angeles County
Collection Guide
∞ http://www.oac.cdlib.org/findaid/ark:/13030/c8hm598k
Collection Title:
Collection Number:
Get Items:
Mount Lowe Photograph Collection
No online items
Contact Seaver Center for Western History Research, Natural History Museum of Los Angeles County
View entire collection guide
(51.71 Kb)
Search this collection
Entire Collection Guide
Online Items
Collection Overview
Table of contents
Photographs and negatives (glass, film and lantern slides). Scenes of Mt. Lowe including construction of the Mt.Lowe Railroad. Many snow scenes. All by W.H. Hill, Pasadena photographer, except for one by George Wharton James. Also prints and a negative of Battleship "Illinois" displayed at 1893 World's Fair taken by Vroman. circa 1892-1921, undated. See also GC 1121 Mount Lowe Collection
.2 linear feet (Boxes: ½ letter; 2 ½ letter)
Permission to publish, quote or reproduce must be secured from the repository and the copyright holder
Research is by appointment only
Collection Overview
Collection Details
Descriptive Summary
Publication Rights
Preferred Citation
Acquisition Information
Scope and Content of Collection
Indexing Terms


text:
Monday, April 27, 2015
More New York Times Critics' Picks »
The following shows have received ratings of at least four stars from Times readers.
Most Highly Rated Shows »
In "Wittenberg," Dr. Faustus and Martin Luther have fun batting about Hamlet, their student.
Full New York Times Review »