[askdba] Re: solution needed
- From: <sanjay.khangarot@xxxxxxxxx>
- To: <askdba@xxxxxxxxxxxxx>
- Date: Fri, 24 Sep 2004 10:56:26 +0530
suppose u want 2 pick evry 2nd row then
select * from emp where (rowid,0) in (select rowid,mod(rownum,2) from emp)
-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]On
Behalf Of Soumya K. Mishra
Sent: Friday, September 24, 2004 10:43 AM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] solution needed
Q1) Below given is a simple table with Customer_id and Book_Name as 2
fields. Analyzing the book name we can see that every third book is a
book on database technology. I want to design a query to retrieve the
1st record, the 4th ,the 7th and the 10th.
And generalize it to n no of rows i.e retrieve every nth record. Please
suggest solution.
=0D
=0D
Customer_id=0D
Book_Name
001
Mastering oracle sql
002
Microbiology for beginners
003
Algebra by Hall n Night
004
Inside of SQL Server
005
Economics by M.L Seth
006
Modern India History
007
DB2 for programmers
008
Universe in a Nutshell Stephen Hawking
009
Mutation by Robin Cook
010
Oracle 9i database administration fundamentals 1
=0D
Q2) I was asked in an interview a proposed solution for the following
problem:
=0D
Interviewer: The order management department manager faces the following
problem in the subsequent module of SAP ERP package-
Each time he makes an update of the latest order, it takes quite a lot
time to be reflected in the different module of that ERP solution. What
is that as a DBA you can check for it?
=0D
I need to know in which field the DBA should put his concentration:
=0D
Application programming: should go for the tuning of the queries, procs,
indexes, packages that the ERP application uses.
=0D
Core DBA: should he go for managing the data dictionary, the buffer
cache , the table spaces for the user etc.
=0D
System Administration: should he suggest for configuring the controller
set up?
Ex: change the RAID set up from 15 to 01...
=0D
Thanks=0D
=0D
Soumya Mishra.
=0D
Confidentiality Notice=0D
The information contained in this electronic message and any attachments to=
this message are intended
for the exclusive use of the addressee(s) and may contain confidential or=
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or=
Mailadmin@xxxxxxxxx immediately
and destroy all copies of this message and any attachments.
Other related posts:
