Laurent Schneider's Page

I noticed a side effect of SET LONGC today… The default setting for LONG and LONGC is 80. This is quite annoying when you SELECT TEXT FROM ALL_VIEWS as it truncates the text to 80. So why not setting it to the maximum? Let’s first demo the usage of LINESIZE, LONG and LONGCHUNKSIZE SQL> create view v as select [...]

I just notice a new blog on blogs.oracle.com : Oracle Certification Blog This is probably the right place to ask questions or get news about certification. Out of the many questions I may ask here are just a few I am preparing. - When will the OCM upgrade for 9i OCM be available ? - When will be the [...]

How do I retrieve the second highest salary of emp? There is no right or wrong treatment of duplicates, there are only buggy specifications… There are plenty of ways to do this. An Oracle 7 approach would be SELECT MAX(SAL) FROM EMP, (   SELECT MAX(SAL) MAXSAL FROM EMP) WHERE SAL<MAXSAL; Using TOP-n queries I could use SELECT SAL FROM (   SELECT [...]

I have been using Vista for about 3 months and finally found a way to start my databases with a single click The method I used until yesterday was a .BAT file that starts the services, I had then to right click on the shortcut, run as administrator, confirm the UAC warning. 3 Clicks. [...]

select   timestamp '2008-06-30 23:59:59.999999999 Europe/Zurich'-   timestamp '1998-02-01 00:00:00 Europe/Zurich' from dual; +000003802 22:59:59.999999999 select (   timestamp '2008-06-30 23:59:59.999999999 Europe/Zurich'-   timestamp '1998-02-01 00:00:00 Europe/Zurich'   ) year to month from dual; +10-05 This is about the amount of time I spent by my former employer LC Systems. 10 years 5 months (d) I will tune my book in July and start a new challenge in [...]

It is quite a while I have not posted about Linux. The reason is I have bought in new notebook three months ago with Vista and did not have a program to resize the partition… Do I need a program? NO, I do not !!! Vista has disk management that can resize my online partition. Run: compmgmt.msc /s Or [...]

How do I get the current number of milliseconds since 1970-01-01. I still have no access to oracle.com so I created a new account to answer this question. Either you use the difference between timestamp ‘1970-01-01 00:00:00 +00:00′ and current_timestamp, or you can use java, which is more portable. YMMV create function epoch return number as language java name [...]

One year ago I started writing a book on SQL. Writing a book is an amazing amount of work and I am glad I got helped from my five reviewers Chen, Andrew, Tom, Marco and Lutz. It will ship in December 2008. http://amazon.com/Advanced-Oracle-SQL-Programming-Focus/dp/0977671585 addthis_url = 'http%3A%2F%2Flaurentschneider.com%2Fwordpress%2F2008%2F06%2Fmy-book-is-available-on-amazoncom.html'; addthis_title = 'My+book+is+available+on+amazon.com'; addthis_pub [...]

Since yesterday I cannot login to otn and to the forums Probably I posted to much there Since today I cannot login to Metalink What should I expect for tomorrow? No access to the internet? addthis_url = 'http%3A%2F%2Flaurentschneider.com%2Fwordpress%2F2008%2F06%2Flogin-to-oracle.html'; addthis_title = 'login+to+Oracle'; addthis_pub = '';

Today I missed Scott in my emp table. When selecting from EMP, Scott is not there. Gone… Ok, let’s recreate the scott schema. C:> sqlplus / as sysdba SQL*Plus: Release 10.2.0.3.0 - Production Copyright (c) 1982, 2006, Oracle.  All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 SYS@lsc02> spool scott.txt SYS@lsc02> drop user scott cascade; User dropped. SYS@lsc02> @?/rdbms/admin/utlsampl Disconnected from Oracle Database [...]