A community portal about Oracle database with blogs, videos, and photos. According to Wikipedia.org: An Oracle database consists of a collection of data managed by an Oracle database management system. Popular generic usage also uses the...
[more]
A community portal about Oracle database with blogs, videos, and photos. According to Wikipedia.org: An Oracle database consists of a collection of data managed by an Oracle database management system. Popular generic usage also uses the term to refer to the Oracle DBMS management software, but not necessarily to a specific database under its control.
For Basic SQL: How do you convert a date to a string? To_char. A bonus would be that they always include a format mask. What is an aggregate function? Grouping, sums or counts, etc. What is an interval? Specifies a period of time. What is a nested subquery? A subquery in a where clause. What is the dual table? A single row table provided by oracle for selecting values and expressions. For Basic PL/SQL: Describe the block structure of PLSQL. Declaration, Begin, exception, end. What is an... Read Full Story
For Basic SQL:
How do you convert a date to a string? To_char. A bonus would be that they always include a format mask.
What is an aggregate function? Grouping, sums or counts, etc.
What is an interval? Specifies a period of time.
What is a nested subquery? A subquery in a where clause.
What is the dual table? A single row table provided by oracle for selecting values and expressions. Read Full Story
I'm in an all day meeting today so when we hit the slow points, I am jotting down some streams tips. I am working full-time to integrate streams again, so I think now is a good time.
These are pretty generic items. No bombshells or anything to change your life. Just things to keep in mind.
GLOBAL_NAMES=YES is your friend. You do NOT need to have GLOBAL_NAMES turned on. It does help, though.
Make sure you give the actual GLOBAL_NAME for the databases when you define you Read Full Story
I'm in an all day meeting today so when we hit the slow points, I am jotting down some streams tips. I am working full-time to integrate streams again, so I think now is a good time.
These are pretty generic items. No bombshells or anything to change your life. Just things to keep in mind.
GLOBAL_NAMES=YES is your friend. You do NOT need to have GLOBAL_NAMES turned on. It does help, though.
Make sure you give the actual GLOBAL_NAME for the databases when you define you Read Full Story
LewisC's An Expert's Guide To Oracle Technology
The question I am most frequently asked is a variation of "How can I become a DBA or developer?" or "How can I learn x database?". There are so many places to start and so many options when you do start that it can be very confusing. I got a couple of questions this weekend that made me stop and think. Some things that I take for granted are not obvious to those who are just beginning Read Full Story
LewisC's An Expert's Guide To Oracle Technology
Well, I have made the leap to SQL Developer. No more TOAD. In the past, I was using SQL Developer quite a bit but I would still fall back to TOAD for certain things. No more.
I am using v1.5 and have not had any weird crashes, no performance problems. There's nothing that I need to do that I can't. In a few instances, I have had to search arou Read Full Story
Two must have links: Oracle Linux Download and the Oracle 11g Documentation Homepage.
11g is currently Linux only but I would expect Solaris very shortly and other flavors not long afterwards. I would imagine Windows will be available by year end.
This is awesome. I have SO been waiting for this. Oracle teased me with the "release" on July 11 and it has taken almost a month to actually get Read Full Story
LewisC's An Expert's Guide To Oracle Technology
This one is an oopsy. I am playing with 11g again. Having fun too. I'll be writing up some of my experiences shortly. One of the things I have been playing with is Heterogeneous Services. Oracle makes connecting to remote databases (of a non-Oracle persuasion) incredibly easy.
Anyway, I set up a new database. During install, in addition to setting your system level passwords, you can Read Full Story
今年 Oracle Open World
に参加したエンタープライズテクノロジ分野のお客様やパートナーの数は、期待どおりでした。不況が原因で今年は大規模な IT
イベントがいくつか中止になっているなか、Oracle Open World へ参加した IT プロフェッショナルは 42,000
人と、2008 年の参加者数とほぼ同じです。さらに印象的だったのは、Oracle とパートナーを組む企業、Oracle
の競合企業、Oracle を研究する企業がほとんどすべて、サンフランシスコの中心街で開催された年に 1
度のこの集会に参加したことでした。いくつもの展示ホール、 セッション 、イベント、活動、人的ネットワークのおかげで、情報交換が活発に行なわれる環境が整っていました。
Oracle Open World に参加する大小さまざまなベンダーは、次のようなエンタープライズ IT... Read Full Story
One of our customers had previously been certified in the administration database certification, however as new technologies have come on the scene they needed an upgraded regarding their knowledge, but this process was extremely difficult to keep up with the job, so he bought the killtest’s guide and then it was smooth sailing, he gave it an hour everyday and cleared the exam with a very amazing score. But he also sure admit, it would’ve ben really difficult without Killtest.
The full name... Read Full Story
