Useful One-line Scripts for sed
Handy sed oneliners:
Update:
Return 1st Line
sed -n ‘1p’ file
Return all except 1st line
sed ‘1d’ file
Oracle 11g: The Top New Features for DBAs and Developers
Some days ago Oracle 11g for Linux x86 is available. Here a list of features. This features are currently available to read the rest is comming soon:
- Database Replay
- Schema Management
- Partitioning
- Transaction Management
- SQL Plan Management
- SQL Perfomance Analyzer
- SQL Access Advisor
- RMAN
- PL/SQL: Efficient Coding
- Security
- Automatic Storage Management
- Manageability
- Caching and Pooling
- SQL Operations: Pivot and Unpivot
- Secure Files
- Reciliency
- Data Guard
- PL/SQL Performance
- Data Warehousing and OLAP
- And don’t forget…
Read them here!
Online SQL Formatter
With the online SQL Formatter you can easily format your SQL’s to a nice format.
Before
SELECT D.Dept_Name, AVG(Getdate()-DOB) FROM EMPLOYEE E
/*Comment now comes an inner join*/ INNER JOIN DEPARTMENT D ON
E.DEPT_ID=DEPT_ID GROUP BY DEPT_ID;
After
SELECT D.Dept_Name,
AVG(Getdate()-DOB)
FROM EMPLOYEE E
/*Comment now comes an inner join */
INNER JOIN DEPARTMENT D
ON E.DEPT_ID=DEPT_ID
GROUP BY DEPT_ID;
You can also download the desktop version which requires JRE 1.5.
Update:
Another SQL and PL/SQL Formatter.
