Re: Accessing Oracle database - Database Discussion Boards

Eddy Vluggen13-Jun-12 1:19

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

Re: difficult query

Michael Potter12-Jun-12 11:02

Michael Potter

12-Jun-12 11:02

SQL

SELECT
    id_Applicant,
    name,
    date_of_birth,
    date_of_death
FROM
    Applicant
WHERE
    '5/30/2012' BETWEEN date_of_birth AND ISNULL(date_of_death,'1/1/3000')

SSIS OleDB or ADO.NET

cjb1107-Jun-12 23:05

cjb110

7-Jun-12 23:05

Just wondering what differences there are between these two connection methods in SSIS? We are connecting to SQL 2008 R2 databases.

Is one better performing than the other? Or is one easier to use? There does seem to be certain tasks that can only use one or the other.

Re: SSIS OleDB or ADO.NET

PIEBALDconsult8-Jun-12 3:44

PIEBALDconsult

8-Jun-12 3:44

An ADO.net connection will use the native client classes so it is better.

sql Date conversion not working in sql 2000

Robymon7-Jun-12 22:12

Robymon

7-Jun-12 22:12

I am trying to insert string date to datetime column with the following way.(Sql2000)

CONVERT(DATETIME, @To, 103)

but this is not saving the DD/MM/YYYY format in the webserver, but it is working in my local machine.In the webserver sql it is saving as MM/DD/YYYY format.

Re: sql Date conversion not working in sql 2000

Bernhard Hiller7-Jun-12 22:41

Bernhard Hiller

7-Jun-12 22:41

Use a parameterized query, that will do the magic around the date format.

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