GeekArticles
FAQ
Oracle FAQQuery
Author: asktom.oracle.com |
Published: 27th Apr 2008 |
Visited: 94 times |
Add CommentFiled in: Oracle FAQHi Tom,
I definetly remember seeing something similar to this on this site, but could not find. If I am right, could you direct me to the link please?
Thank you,
Sinan
here is my question.
<code>
-- Create table
create table ASKTOM_TAS...
Read Article Sponsored Links
Related Articles
• Sql query Sir,
I have joined this team having severe problems with SQL and found one having excessive CpU from AWR reports.
There are many changes that we have suggested to this insert, could you please give your valuable inputs also please.
On a 10G i ...
• How to query a large table with cpu throttling My requirements:
1. I have a large table, in the range of 1 billion records.
2. But the machine is a relatively slow one. Therefore I would not
like to clog the machine when querying this large table.
My question:
A. Supposed I ...
• sql query hi tom,,,u r great to helpout us
create table T
(empid number(4),
deptid number(4),
fromdate date,
todate date);
/
insert into T values (101,1,'25-jan-02', '25-feb-02');
insert into T values (101,1,'26-feb-02', '01-jun-03');
insert in ...
• Query to obtain pagination links Hi Tom,
I am trying to formulate a SQL query to obtain a pagination links to display "By Name" in alphabetically. The page limit being 200 records.
E.g
A - L | M - S | T - Z
Authors starting char "A" to "L" are less than( ~ 200 like 190 ...