Accessing Oracle database - Database Discussion Boards

Re: SQL Compound Primary Keys

PIEBALDconsult13-Jun-12 4:10

PIEBALDconsult

13-Jun-12 4:10

Yes, but why would the client be adding records to those tables?

Kevin Marois wrote:
PK's are unique

Globally unique?

Re: SQL Compound Primary Keys

Kevin Marois13-Jun-12 6:33

Kevin Marois

13-Jun-12 6:33

I don't understand why you're questioning this.

The software is installed locally on a user's PC, along with a local copy of the DB. The software does CRUD operations on the local copy of the DB.

Then, at night, or at least once per week, the software uploads all new/changed/deleted records to the server.

If it's not broken, fix it until it is

Re: SQL Compound Primary Keys

Eddy Vluggen13-Jun-12 1:21

Eddy Vluggen

13-Jun-12 1:21

PIEBALDconsult wrote:
That is a big reason not to use integers as keys.

Yeah, people being too lazy. The problem goes away with GUIDs, since that allows for laziness.

Bastard Programmer from Hell Suspicious | :suss:

Re: SQL Compound Primary Keys

Jörgen Andersson12-Jun-12 21:56

Jörgen Andersson

12-Jun-12 21:56

Kevin Marois wrote:
and each night will upload its data to the server

Is this a oneway communication where the data is only uploaded, or will it synchronise the data with the server?
If it's just an upload you don't need to have global keys, you can add new keys at the server when uploading.

Light moves faster than sound. That is why some people appear bright, until you hear them speak.
List of common misconceptions

Re: SQL Compound Primary Keys

Kevin Marois13-Jun-12 6:34

Kevin Marois

13-Jun-12 6:34

There will be two-way communicaation

If it's not broken, fix it until it is

Re: SQL Compound Primary Keys

Eddy Vluggen13-Jun-12 1:19

Eddy Vluggen

13-Jun-12 1:19

I don't see a key, only an identity-field. If that identity is the key, and you need a quick solution, add a second column with a GUID and promote that to be the primary key.

I'd recommend to have a "real" key; take those columns that uniquely identify a record, and use those as a key, and the identity merely as an alternative shortcut to that.

Bastard Programmer from Hell Suspicious | :suss:

Maybe look at Set IDENTITY_INSERT On/Off

David Mujica13-Jun-12 2:56

David Mujica

13-Jun-12 2:56

You may have to change the way you are bringing data from the client DB to your server DB.

Check this article out ...

http://www.sqlteam.com/article/how-to-insert-values-into-an-identity-column-in-sql-server[^]

Remember to vote if this helps. Thumbs Up | :thumbsup:

Accessing Oracle database

Dangermouse9912-Jun-12 3:37

Dangermouse99

12-Jun-12 3:37

Hi we have an Oracle 10g database that I would like to connect to, the database has been written by a 3rd party.

I was wondering what free tools I can use to access the tables, etc. Something similar to SQL Server management studio would be nice.

Also if I need to install something else Oracle related, dll or whatever, in order to connect to it. We have the server, database login, etc, just need to connect to it!
Thanks

Re: Accessing Oracle database

Pete O'Hanlon12-Jun-12 3:49

Pete O'Hanlon

12-Jun-12 3:49

Dangermouse99 wrote:
Something similar to SQL Server management studio would be nice.

Something like Sql Developer[^] perhaps?

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Re: Accessing Oracle database

Dangermouse9912-Jun-12 4:08

Dangermouse99

12-Jun-12 4:08

Thanks, that looks good.

Re: Accessing Oracle database

Pete O'Hanlon12-Jun-12 5:34

Pete O'Hanlon

12-Jun-12 5:34

No problem. Glad to help.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Re: Accessing Oracle database

PIEBALDconsult12-Jun-12 7:49

PIEBALDconsult

12-Jun-12 7:49

I downloaded Oracle's ADO.net connector and added support for it in my database classes. That meant that I could access Oracle databases from my console and WinForms apps, including one that allows the user to enter ad hoc queries and view the schema.

Re: Accessing Oracle database

Jörgen Andersson12-Jun-12 21:33

Jörgen Andersson

12-Jun-12 21:33

SQLTools[^] if you want it lightweight.
TOra[^] is at the other end of the spectrum.
Both are opensource.

SQL Developer and Oracle Developer Tools for Visual Studio has already been mentioned. They are from Oracle and are supported, ... sort of.

You will also need to install some version of the Oracle Client which is available in several versions such as the normal Client, Instant Client or Oracle Data Provider for Dotnet.
Oracle Developer Tools for Visual Studio has the Client built in.

Light moves faster than sound. That is why some people appear bright, until you hear them speak.
List of common misconceptions

SQL Server (image) data type

Midnight Ahri10-Jun-12 20:33

Midnight Ahri

10-Jun-12 20:33

I save image to database using byte array to SQL server image type, if i save 10 MB image, is it going to be bigger or smaller in database? D'Oh! | :doh:

Re: SQL Server (image) data type

Eddy Vluggen11-Jun-12 0:07

Eddy Vluggen

11-Jun-12 0:07

10 Mb will remain just that, unless you use a CompressionStream.

Bastard Programmer from Hell Suspicious | :suss:

MySQL Password

Tom M3W10-Jun-12 4:09

Tom M3W

10-Jun-12 4:09

I had a programmer in a foreign country develop an application for me, I had to dismiss him because he would not finish the program on time. I asked him for the source code to MySQL db and he would not provide it. I paid him so that wasn't the issue. I need to move my application from one cloud server to another company and I need help in figuring out how to break the db code to move the application. There are a lot of connection points in and out of the db so I can't just copy the db and move it over.

Thanks

Re: MySQL Password

Eddy Vluggen10-Jun-12 4:13

Eddy Vluggen

10-Jun-12 4:13

Isn't the password mentioned in the connectionstring?

Bastard Programmer from Hell Suspicious | :suss:

difficult query

m_safaaaa9-Jun-12 8:12

m_safaaaa

9-Jun-12 8:12

hello,

I have a table named: 'Applicant' having fields:

'id_Applicant', 'name,'date_of_birth','date_of_death'

the sql or oracle query is:

'Select all applicant who are alive on 30-05-2012'

Please it's urgent

thanks alot.

Re: difficult query

Richard Andrew x649-Jun-12 9:09

Richard Andrew x64

9-Jun-12 9:09

What have you tried so far?

The difficult we do right away...
...the impossible takes slightly longer.

Re: difficult query

Paul Conrad9-Jun-12 9:24

Paul Conrad

9-Jun-12 9:24

m_safaaaa wrote:
Please it's urgent

That's a big no no to say in a forum post. People will help you when they can. As the other poster has mentioned, what have you tried so far?

""Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Re: difficult query

PIEBALDconsult9-Jun-12 10:16

PIEBALDconsult

9-Jun-12 10:16

I suspect that 2012-05-30 just might possibly be between the date_of_birth and the date_of_death (or some date in the future if null). Unsure | :~

You are using DATE or DATETIME fields, right? Right?

modified 9-Jun-12 17:11pm.

Re: difficult query

Sandeep Mewara9-Jun-12 20:09

Sandeep Mewara

9-Jun-12 20:09

Posting in multiple forums is considered rude. Please find an appropriate forum and stick to it: Difficult query please it's urgent[^]

Sandeep Mewara
[My last tip/trick]: Server side Delimiters in ASP.NET[^]

Re: difficult query

vvashishta10-Jun-12 19:08

vvashishta

10-Jun-12 19:08

SELECT * FROM Applicant
WHERE Date_Of_Death > CONVERT(VARCHAR,'30-05-2012',106)

- Happy Coding -
Vishal Vashishta

Re: difficult query

Bernhard Hiller10-Jun-12 20:02

Bernhard Hiller

10-Jun-12 20:02

Works great, if the guy is still alive today...
Your query selects all who have already died past that date - that's a difference.

Re: difficult query

Bernhard Hiller10-Jun-12 19:59

Bernhard Hiller

10-Jun-12 19:59

Either date_fo_death is null or greater than the given date:

SQL

SELECT *
FROM Applicant 
WHERE date_of_death is null
   OR date_of_death>@somedate

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.