 | |
Looking for oracle/sql tutorials and advice
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: Looking for oracle/sql tutorials and advice -
04-27-2008
, 03:04 PM
|
On 27 Apr, 08:28, William Robertson <williamr2... (AT) googlemail (DOT) com wrote: 1. I'm not sure if you want to reorganise your schema design, move data between tables (insert ... select) or restore to a point in time (select ... as of timestamp ..., or flashback table/database though I don't think XE provides that). Did you delete the original data? I didn't delete the original data, but it was replaced with an ID corresponding to the data in the lookup table. So for example the employees table had a column called 'JOB_ID'. What has happened is that all the JOB_ID's have been automatically moved to a separate table with a Unique Key - and the JOB_ID column (in the employees table) was replaced with a new column 'JOB_ID_ID' which has values corresponding the the Unique Key on the new lookup table. I did this by mistake (it is a redundancy because there is already a table called 'jobs' which lists all of the Job_ID's and their definitions). I haven't learnt how to do restorations or reorganising schema design or flashbacks. Maybe I am jumping ahead of myself. 2. I'm not sure this has much to do with foreign keys. It sounds like an Application Express question about how to define a button that pops up a selection list populated from a query. I'm sure there there's a way but I'm afraid I don't know Apex. I haven't studied Application Express yet so I don't know if that is what I am looking for. I noticed that oracle will display a button (on a form) for entering dates. This is the kind of thing I am looking for. I'm beginning to realise that I am probably jumping too far ahead of myself. I think what I really need is a road map of progressive topics I need to study. Are there any books or tutorials that explain the key concepts of oracle without going into too much detail? Michael |
tutorials. They are online and self paced and free. Start there.
Jim
#12
| |||
| |||
|
|
On 27 Apr, 08:28, William Robertson <williamr2... (AT) googlemail (DOT) com wrote: 1. I'm not sure if you want to reorganise your schema design, move data between tables (insert ... select) or restore to a point in time (select ... as of timestamp ..., or flashback table/database though I don't think XE provides that). Did you delete the original data? I didn't delete the original data, but it was replaced with an ID corresponding to the data in the lookup table. So for example the employees table had a column called 'JOB_ID'. What has happened is that all the JOB_ID's have been automatically moved to a separate table with a Unique Key - and the JOB_ID column (in the employees table) was replaced with a new column 'JOB_ID_ID' which has values corresponding the the Unique Key on the new lookup table. I did this by mistake (it is a redundancy because there is already a table called 'jobs' which lists all of the Job_ID's and their definitions). I haven't learnt how to do restorations or reorganising schema design or flashbacks. Maybe I am jumping ahead of myself. 2. I'm not sure this has much to do with foreign keys. It sounds like an Application Express question about how to define a button that pops up a selection list populated from a query. I'm sure there there's a way but I'm afraid I don't know Apex. I haven't studied Application Express yet so I don't know if that is what I am looking for. I noticed that oracle will display a button (on a form) for entering dates. This is the kind of thing I am looking for. I'm beginning to realise that I am probably jumping too far ahead of myself. I think what I really need is a road map of progressive topics I need to study. Are there any books or tutorials that explain the key concepts of oracle without going into too much detail? Michael |
tutorials. They are online and self paced and free. Start there.
Jim
#13
| |||
| |||
|
|
On 27 Apr, 08:28, William Robertson <williamr2... (AT) googlemail (DOT) com wrote: 1. I'm not sure if you want to reorganise your schema design, move data between tables (insert ... select) or restore to a point in time (select ... as of timestamp ..., or flashback table/database though I don't think XE provides that). Did you delete the original data? I didn't delete the original data, but it was replaced with an ID corresponding to the data in the lookup table. So for example the employees table had a column called 'JOB_ID'. What has happened is that all the JOB_ID's have been automatically moved to a separate table with a Unique Key - and the JOB_ID column (in the employees table) was replaced with a new column 'JOB_ID_ID' which has values corresponding the the Unique Key on the new lookup table. I did this by mistake (it is a redundancy because there is already a table called 'jobs' which lists all of the Job_ID's and their definitions). I haven't learnt how to do restorations or reorganising schema design or flashbacks. Maybe I am jumping ahead of myself. 2. I'm not sure this has much to do with foreign keys. It sounds like an Application Express question about how to define a button that pops up a selection list populated from a query. I'm sure there there's a way but I'm afraid I don't know Apex. I haven't studied Application Express yet so I don't know if that is what I am looking for. I noticed that oracle will display a button (on a form) for entering dates. This is the kind of thing I am looking for. I'm beginning to realise that I am probably jumping too far ahead of myself. I think what I really need is a road map of progressive topics I need to study. Are there any books or tutorials that explain the key concepts of oracle without going into too much detail? Michael |
tutorials. They are online and self paced and free. Start there.
Jim
#14
| |||
| |||
|
|
You can go to otn.oracle.com and they have what are called 2 day dba tutorials. They are online and self paced and free. Start there. Jim |
Michael
#15
| |||
| |||
|
|
You can go to otn.oracle.com and they have what are called 2 day dba tutorials. They are online and self paced and free. Start there. Jim |
Michael
#16
| |||
| |||
|
|
You can go to otn.oracle.com and they have what are called 2 day dba tutorials. They are online and self paced and free. Start there. Jim |
Michael
#17
| |||
| |||
|
|
You can go to otn.oracle.com and they have what are called 2 day dba tutorials. They are online and self paced and free. Start there. Jim |
Michael
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.