If you use HTML Templates (Page Skins and/or Content Layouts) on your Oracle Portal implementations, you might notice that they are cached often. If you want the results/rendering to change more often for these components, you might want to disable the page cache or tweak the webcache settings appropriately.
Oracle Rename Table – Example Syntax and Dependencies
Renaming a table in Oracle is simple. Following is the generic Oracle table rename syntax: 1 ALTER TABLE current_table_name RENAME TO new_table_name;alter table current_table_name rename to new_table_name; In practice, you might realize you left off a prefix that you are using as a naming standard. Changing the table name can be accomplished with the following example syntax: 1 ALTER TABLE employee RENAME TO dw_employee;alter table employee rename to dw_employee; If the table is already in use, I recommend that you review custom code, Oracle packages, stored procedures, and any other references to the table. You can use tools like TOAD … Read More
Oracle Database vs Sun MySQL
Well, this is a topic we have reviewed numerous times over the years for projects and customers. The fact is, like most important decisions, picking a winner is based mostly on your specific needs. Of the many aspects we review, we will discuss one line of thought in this article.
If there is in-house expertise in Oracle, and management is happy with the skills, productivity of existing staff, and license fees, stick with it. I don’t know many — actually, I don’t know any — CIOs or Directors in IT Management that have been berated for choosing Oracle as an enterprise-wide database platform.
That said, if the strategic decision to use Oracle database for all purposes hasn’t been made, MySQL is worth a very serious look, especially for …
FreeQL – Free Oracle SQL Select Statements
M&S Consulting has begun a revolutionary service where we will write Oracle SQL statements for FREE. We have named this service FreeQLTM.
Who can use FreeQL?
Anybody can request an Oracle SQL statement to be written, as complex as you desire. You must provide a valid, non-free email address that we will use to communicate with you. That means that we will not entertain requests from gmail, hotmail, yahoo, etc.
What’s the catch?
With years in the business writing high performing, very practical SQL statements for Oracle customers (many in the business intelligence space), we want to share our knowledge and get the word out about our skills, ability, and friendly business style.
You are welcome to sign up for our newsletter or make a small payment if you desire, though that is not a requirement.
I’m in. Now what?
Simply populate the FreeQL form and we will respond to you with SQL. Everyone wants something without spending money…and we’re here to give it to you!
Oracle SUBSTR Function – SQL Syntax Examples
The Oracle SUBSTR SQL Function is very common, and many times misused.
Below shows the SUBSTR function along with the arguments it takes:
1 | substr(string, POSITION) |
1 | substr(string, POSITION, substring_length) |
The Oracle SUBSTR function returns a portion of string, beginning at character position, substring_length characters long.
Following are important rules to follow along with syntax exemplifying the implications of the rules.
Who is M&S?
We are asked this question quite a lot. Find out some unique insights on M&S Consulting in this article.
The M&S business model is created from the group up to deliver repeated success, consistently: a great benefit to our organization and yours.
Oracle Portal 10.1.4 or 10.1.4.1 Upgrade to 10.1.4.2 – Features and Bug Fixes
You may have applied or are considering applying the Oracle Application Server 10.1.2.3 patch for a variety of reasons. As a result, if you are running Oracle Portal 10.1.4 or 10.1.4.1, your Portal will be upgraded to 10.1.4.2.
Portal 10.1.4.2 New Features
There isn’t much to be found in terms of documented new features for Portal 10.1.4.2, but I understand the following to be new to this release:
- Portal Repository JSR-170 adapter
- You can now copy pages across page groups
- New HTML DOCTYPE specification
Portal 10.1.4.2 Bug Fixes
Of the many bug fixes documented for Oracle AS 10.1.2.3 and Portal 10.1.4.2, following are just a few that you might be pleased about:
- Omniportlet onclick was still opening the link in the same browser window.
- Customize/Personalize links on a portlet were accessible even after the Global Inactivity Timeout has occurred.
- When a WSRP portlet tried to upload content of size > 64k as multipart request, then an error was displayed saying > 64K is being uploaded.
- All old-style URLs may now be redirected directly to the new URL without going via the splash screen.
- More in the full article…