 |
|
|
|
|
|
(Archive) SQL and PL/SQL
An archive of older SQL and PL/SQL answers.
|
|
 |
|
|
|
|
| EXPERT TECHNICAL ADVICE: 1 - 3 of 202 |
|
|
|
|
|
Generating a 10 character alphanumeric sequence
Expert: Azim Fahmi | 29 Apr 2005
EXPERT ANSWER - I need to create a 10 character alphanumeric sequence for a client. The sequence is to be static like this: a111a11a11a. If it's a number, increment 1 until you reach 9, then move to the next column, if it's a letter, ...
|
|
|
Concatenating a null character affecting performance
Expert: Azim Fahmi | 29 Apr 2005
EXPERT ANSWER - Original: (taking 16 mins)
SELECT DISTINCT FIRST_NAME, LAST_NAME
FROM View1@db_link
WHERE NUM = '14718'
AND UPPER(RNAME) = 'MARKETING';
Modified: (taking 1 sec)
SELECT DISTINCT FIRST_NAME, ...
|
|
|
|
SEE ALSO - Topics Related to (Archive) SQL and PL/SQL:
Data Warehousing, ETL, and business intelligence,
(Archive) Database Performance Tuning,
(Archive) Database Administration and Development,
Oracle Internals,
(Archive) Oracle Applications,
Database Backup and Recovery,
Oracle Application Server,
PL/SQL,
Oracle Performance Tuning,
Managing an Oracle shop,
RAC and Availability,
Database Design and Architecture,
(Archive) Database Installation and Upgrade,
(Archive) Database Security,
SQL,
(Archive) Data Warehousing and Business Intelligence,
(Archive) Database Design,
(Archive) App Dev: PL/SQL and XML,
(Archive) Database Installation/Upgrade/Patches,
SOA and Integration,
E-Business Suite |
|
|
|
|
|
|
|
|
|
|
| TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of . |
|
| | |
All Rights Reserved, , TechTarget |
|
|
|
|
|
