|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Searching between alphanumeric ranges |
1 |
1069 |
Fri, 12 January 2001 15:52 By: dapzoid ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Convert varchar to number in sql By: Kelsi on Thu, 11 January 2001 |
1 |
965 |
Fri, 12 January 2001 14:18 By: Andrew again... ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Rownum problem in Oracle 7 |
1 |
1636 |
Fri, 12 January 2001 14:14 By: Andrew again... ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Re: Text Editing Platfom - http://www.ultraedit.com/. |
0 |
998 |
Fri, 12 January 2001 14:01 By: Andrew again... ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Re: Text Editing Platfom By: Bala on Fri, 12 January 2001 |
0 |
910 |
Fri, 12 January 2001 10:20 By: Bala ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
queary |
1 |
1238 |
Fri, 12 January 2001 05:10 By: Baskar ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
queary |
1 |
1166 |
Fri, 12 January 2001 03:16 By: John R ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
query |
2 |
1665 |
Fri, 12 January 2001 03:00 By: debasish ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Dual Sequence |
0 |
991 |
Thu, 11 January 2001 16:17 By: Salman Rasheed ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
recommended books By: dan kim on Wed, 10 January 2001 |
1 |
972 |
Thu, 11 January 2001 09:40 By: Jan G ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
String Move in Text Editing, etc.... By: sat on Wed, 10 January 2001 |
0 |
970 |
Wed, 10 January 2001 13:17 By: sat ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Defragmentation of tables in oracle |
1 |
1089 |
Wed, 10 January 2001 12:17 By: Andrew again... ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
fetching data for a fiscal week of prevoius year |
1 |
1072 |
Wed, 10 January 2001 11:46 By: me ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to make oracle database case-insensitive? By: Latha.G on Wed, 10 January 2001 |
1 |
1020 |
Wed, 10 January 2001 10:01 By: Suresh ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Regarding Storage Of Images Into Database |
1 |
966 |
Wed, 10 January 2001 09:47 By: Deanna ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Re: finding nth max of column in a table |
0 |
978 |
Wed, 10 January 2001 08:37 By: Suresh Vemulapalli ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
display "NULL" for null value ? By: Angu on Fri, 03 November 2000 |
3 |
1587 |
Wed, 10 January 2001 06:51 By: Sandeep Udupa ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
selecting the nth record By: Gus on Sun, 03 December 2000 |
2 |
1152 |
Wed, 10 January 2001 06:29 By: Sandeep Udupa ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Business Days |
1 |
1085 |
Wed, 10 January 2001 06:21 By: Sandeep Udupa ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Top 100 report |
3 |
1134 |
Wed, 10 January 2001 06:06 By: Sandeep Udupa ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
select statement ... By: jimmy on Tue, 09 January 2001 |
4 |
1577 |
Wed, 10 January 2001 05:30 By: John R ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Returning a value to VB |
2 |
1469 |
Wed, 10 January 2001 05:26 By: Sandeep Udupa ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query Tunning By: sandeep on Tue, 09 January 2001 |
2 |
1345 |
Tue, 09 January 2001 22:33 By: Sandeep Udupa ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Equivalent of "Database Link"? By: Derrick on Tue, 09 January 2001 |
0 |
939 |
Tue, 09 January 2001 21:49 By: Derrick ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Select Staement Help By: David on Mon, 08 January 2001 |
3 |
943 |
Tue, 09 January 2001 14:34 By: David ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
indexs and performance By: dan kim on Mon, 08 January 2001 |
1 |
921 |
Tue, 09 January 2001 13:22 By: Andrew again... ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to put a '&' in the SQL query? By: dennis on Tue, 09 January 2001 |
2 |
931 |
Tue, 09 January 2001 13:12 By: Andrew again... ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQLPLUS format |
1 |
1277 |
Tue, 09 January 2001 10:07 By: Bala ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Need some special output from select (order, decode, ...) By: X Men on Mon, 08 January 2001 |
2 |
939 |
Tue, 09 January 2001 09:07 By: me ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Looking for a simple way to clone data (intra table). |
2 |
1342 |
Tue, 09 January 2001 08:57 By: Christopher Beattie ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
default values not defaulting |
1 |
1010 |
Tue, 09 January 2001 08:46 By: me ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Decimal format in SqlLoder By: Archana on Tue, 09 January 2001 |
0 |
968 |
Tue, 09 January 2001 08:38 By: Archana ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
To get primary and corresponding foreign key By: Satya on Tue, 02 January 2001 |
2 |
1264 |
Tue, 09 January 2001 07:04 By: Sandeep Udupa ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Trigger question |
4 |
1224 |
Tue, 09 January 2001 06:57 By: Sandeep Udupa ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL Loader Question - Keeping blanks as blanks instead of nulls |
3 |
1310 |
Mon, 08 January 2001 18:03 By: Bala ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
composite primary keys By: dan kim on Fri, 05 January 2001 |
1 |
1349 |
Mon, 08 January 2001 14:31 By: Andrew again... ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Re: Is JOIN a better choice over SUBQUERY ? Pl. expl. |
0 |
992 |
Mon, 08 January 2001 14:22 By: Andrew again... ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
star schema to demormalized table By: meena on Mon, 08 January 2001 |
0 |
965 |
Mon, 08 January 2001 13:21 By: meena ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ORDER BY and rank By: Datch on Sun, 07 January 2001 |
1 |
1027 |
Mon, 08 January 2001 13:17 By: Bala ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Finding the common records |
0 |
921 |
Mon, 08 January 2001 01:06 By: vijaya kumar ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |