Zmrss Reader » Ask Tom MOST POPULAR (10)

Feeds

11988 items (11988 unread) in 19 feeds

Blog (67 unread)

• ~依米岛~ (67 unread)

Google (2045 unread)

• Google 黑板报 -- Google 中国的博客网志 (1065 unread)
• 疯狂的设计 (980 unread)

Oracle (3668 unread)

• Ask Tom MOST RECENT ARTICLES (2743 unread)
• Ask Tom HOT ARTICLES (359 unread)
• Ask Tom MOST POPULAR (46 unread)
• Ask Tom MOST POPULAR (10) (46 unread)
• Mark Rittman's Oracle Weblog (273 unread)
• Oracle Professional (201 unread)

OracleERP (1623 unread)

• AppsBI : Applications Business Intelligence (188 unread)
• Oracle BI Publisher Blog (508 unread)
• AMIS Technology blog (927 unread)

ReadBlog (1875 unread)

• 王建硕 (376 unread)
• DBA's notes (1024 unread)
• Chanel [K] (475 unread)

nix (368 unread)

• FreeBSD Project News (368 unread)

OpenSource (370 unread)

• Open Technology and Business Forge (370 unread)

TechNews (1829 unread)

• BusinessWeek Online -- Tech Beat (1829 unread)

Design (143 unread)

• UCDChina.com (143 unread)

Ask Tom MOST POPULAR (10) (10 unread)

• June 27, 2008
• 17:41

  extracting data to a flat file.

   » ‎ Ask Tom MOST POPULAR (10)
  <code>How can i extract data from flat file to oracle table with plsql ? </code>
• August 20, 2007
• 8:42

  Pivot Query

   » ‎ Ask Tom MOST POPULAR (10)
  <code>Please state an example of pivot query. I know that in cardinality I've 2 columns, so how can I show them in columnar form and I know the cardinality is 4. Please also illustrate method of Varray and Nested Tables. Regards Puneet </code...
• April 13, 2007
• 9:01

  SQL Query

   » ‎ Ask Tom MOST POPULAR (10)
  <code>Hi Tom, I have a table like this create table temp1 (f_name varchar2(100), f_date date, f_amount integer ); Records in this table will be like this: Ajay 15-JUL-02 500 Bhavani 15-JUL-02 700 Chakr...
• March 07, 2007
• 8:09

  What don't you like about Oracle?

   » ‎ Ask Tom MOST POPULAR (10)
  <code>Hi Tom, I was wondering if there are some thing you don't like about Oracle? I personally wish more things came setup, out of the box such as autotrace, intermedia text, scott schema etc. Any thoughts on this? -Alex </code>
• January 24, 2007
• 8:36

  How can I track the execution of PL/SQL and SQL?

   » ‎ Ask Tom MOST POPULAR (10)
  <code>Hi Tom, How can I know what a given user is executing if his status is ACTIVE ? How can I know which PL/SQL blocks or SQL statements are being run by him ? As to SQL statemets, I can join v$session.user# with v$sqlarea.parsing_user_id ( am I...
• January 19, 2007
• 12:01

  Stripping special characters

   » ‎ Ask Tom MOST POPULAR (10)
  <code>How would you go about stripping special characters from a partnumber. I do not know of an Oracle function to do this. Are there any packages that do this? I want to strip everything except A-Z, a-z, 0-9. Thanks for your help Lisa </code>
• January 17, 2007
• 19:58

  getting rows N through M of a result set

   » ‎ Ask Tom MOST POPULAR (10)
  <code>I would like to fetch data after joining 3 tables and sorting based on some field. As this query results into approx 100 records, I would like to cut the result set into 4, each of 25 record. and I would like to give sequence number to ea...
• January 12, 2007
• 16:04

  Analytics question

   » ‎ Ask Tom MOST POPULAR (10)
  <code> I have a table from a 3rd party application that is used to track an order through the various manufacturing operations. A subset of the information looks like this: ORDER OPN STATION CLOSE_DATE ----- --- ------- ----------...
• January 10, 2007
• 9:46

  design the table

   » ‎ Ask Tom MOST POPULAR (10)
  <code>Tom: when doing the database design , i have the following question. let's say we have emp table which have empid,empname,deptno, as well as empPicture, empGreeting, empFamilyPict. since we don't use empPicture , empGreeting( which is a...
• January 08, 2007
• 7:16

  Questions on Locking

   » ‎ Ask Tom MOST POPULAR (10)
  <code>Hi Tom, Here are the few questions on Locking. 1)How do I use v$lock to figure out lock details ? Details like whos has locked,on which table,who else is waiting, and what type of locking (shared or exlusive ?), since when it is lock...