2,951 Posted Topics

Member Avatar for rinoa04

before you develop your peoject and i suggest you anything my i know what are the programming languages that you know,which can be used as frontend . and as u said u will be studying oracle ,it means u also have few or no idea of oracle it self. In …

Member Avatar for waqasali11657
0
172
Member Avatar for sayeedbd
Member Avatar for eXceed69
Member Avatar for tyson.crouch

There links will surely help you.[URL="http://download.oracle.com/docs/cd/B19306_01/server.102/b14200.pdf"] sql[/URL] [URL="http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261.pdf"]pl/sql[/URL]

Member Avatar for tyson.crouch
0
104
Member Avatar for jemz
Member Avatar for jemz
0
155
Member Avatar for jemz

Your looks ok (i did not check in IDE ) Are you getting any error from your code ? Please check the auto generated code in inbuilt wizard in VB 6 .

Member Avatar for jemz
0
385
Member Avatar for krille

I don't think that version is available any more. That has been de-supported by the parent company.

Member Avatar for vb5prgrmr
0
1K
Member Avatar for x_mysterious_x

You need to understand the theory part of distributed database , before trying to understand it. for example ----try to use a DB link (in oracle) to connect to different database servers and fetch the data using a single SQL.

Member Avatar for ayazkhatri003
0
80
Member Avatar for whizkidash

Basic export / import (exp/imp) will work for, no need to go for data pump version (may involve access issue for creating directory). But ensure to disable all the triggers on the target schema before importing . Later on you can enable those.

Member Avatar for debasisdas
0
279
Member Avatar for The Dude
Member Avatar for Obelisk4

You will always get errors, if you try T-SQL syntax in oracle. Please read more [URL="http://www.sc.ehu.es/siwebso/KZCC/Oracle_10g_Documentacion/server.101/b10759/statements_8001.htm"]here[/URL] and [URL="http://www.adp-gmbh.ch/ora/sql/create_type.html"]here[/URL] .

Member Avatar for Obelisk4
0
194
Member Avatar for SREENIVAS_DANDA

Please start anew thread for your new question , do not hijack others threads. Which tool you are using for the ER diagram ?

Member Avatar for idcj
0
64
Member Avatar for sivak

Sorry, no one can . You need to read books for the purpose and understand the job at hand.

Member Avatar for Ozzzo
-1
66
Member Avatar for jdbaba

What exactly is the error message. If oracle server is installed on your own PC why you need internet. Check that oracle service and listener is in running (from control panel).

Member Avatar for debasisdas
0
68
Member Avatar for 1manik

[URL="http://forums.oracle.com/forums/thread.jspa?threadID=565989"]This[/URL] may be helpful to you. Optionally you also my need to download OCCI from [URL="http://www.oracle.com/technology/tech/oci/occi/occidownloads.html"]here[/URL].

Member Avatar for debasisdas
0
112
Member Avatar for Learner7
Member Avatar for habte2010
Member Avatar for Ulquiorraa
Member Avatar for clair0917

You question should have been posted in [URL="http://www.daniweb.com/forums/forum58.html"]vb.net[/URL] section of the forum. Does your application connects to any database for the list of items ?

Member Avatar for clair0917
0
137
Member Avatar for jnip
Member Avatar for deven_a76
Member Avatar for debasisdas
0
72
Member Avatar for tukky

you need to check for existance of the ID before trying to insert a new record. If it exists prompt the user to enter a new ID or can increment the max(id) by 1 and continue.

Member Avatar for debasisdas
0
134
Member Avatar for Neub

You need to create a separate table for POINTS and assign some score for each position. That needs to be implement as a look up table in your database.

Member Avatar for debasisdas
0
38
Member Avatar for NH1

I don't think that is an database issue. who has designed the DLL ? Try to get it registered with windows by using REGSVR32 key and recheck.

Member Avatar for debasisdas
0
57
Member Avatar for raymondhsu09

Is there a chance that your SqlCommand or the corresponding SqlConnection is shared and used by multiple threads and one of them might have closed the connection (socket/handle)? If the application uses one connection from multiple threads then, If one thread closed the connection, and another tried to use it …

Member Avatar for raymondhsu09
0
515
Member Avatar for babz83

first of all you need to correct the database design 1. there is no primary key in any of your tables 2. why tables are joined on name and description field ? 3. what are those gur... and NOK.... fields ? (needs to be moved into some new tables) 4. …

Member Avatar for vbboy
0
665
Member Avatar for rafik.mulla

Can you please clarify a bit. What exactly is the requirement ?

Member Avatar for debasisdas
-1
31
Member Avatar for severman

so what is the problem ? post the code that you aare working on currently to get any help from experts. NOTE:---You need a procedure not a function.

Member Avatar for debasisdas
0
302
Member Avatar for questionary

You need to understand the actual requirement before jumping into database design.

Member Avatar for drjohn
0
89
Member Avatar for dewyShaikh

a simple subtraction of birthdate from sysdate will do the trick for you.

Member Avatar for dzen
0
183
Member Avatar for anjeza
Member Avatar for kau14

So what is the problem ? student Id is not the Primay Key in Test_StudentSubjectTrans.

Member Avatar for kau14
0
106
Member Avatar for mohit007kumar00
Member Avatar for jemz
Member Avatar for avatarkk

[QUOTE=avatarkk;1179328] everyone can teach me???[/QUOTE] but who will pay me ?

Member Avatar for anatolse
0
203
Member Avatar for onlyonebui

If you want to store the image in database then this is how you [URL="http://bytes.com/topic/visual-basic/insights/641548-blob-save-image-database"]store[/URL] and this is how you [URL="http://bytes.com/topic/visual-basic/insights/641546-blob-retrieve-image-stored-database"]retrieve[/URL] image

Member Avatar for tsmvasanth
0
242
Member Avatar for gunnarflax

what about creating two tables 1..containing the user information 2..containing the users files information. and linking both

Member Avatar for gunnarflax
0
88
Member Avatar for prem2

To avoid unnecessary extra joins which can be avoided to retrieved data.

Member Avatar for debasisdas
0
51
Member Avatar for neosonic

You need to use the trigonometric functions SIN and COS for the purpose and use the X,Y co-ordinates of the control for position.

Member Avatar for hkdani
0
87
Member Avatar for moone009

Option 1---- point the application to the latest JVM location. Option 2---- download the version of SQL Developer that comes bundled with JVM.

Member Avatar for debasisdas
0
79
Member Avatar for lakshma.sugunan

you can use either a sequence or the max value of PK field +1 for the next unique not null value.

Member Avatar for emsm
0
278
Member Avatar for moone009
Member Avatar for debasisdas
0
166
Member Avatar for psyb0rg
Member Avatar for 1manik

You need to use UTL_FILE predefined package for the purpose.

Member Avatar for debasisdas
0
51
Member Avatar for Simple
Member Avatar for danish_k12
Member Avatar for moone009
Member Avatar for dewyShaikh

please find the details [URL="http://www.mathworks.com/access/helpdesk/help/toolbox/database/ug/database.html"]here[/URL].

Member Avatar for debasisdas
0
49
Member Avatar for regalla

try this if using ADODB for database connection. [code] conn.begintrans 'ADODB connection object. conn.execute "your insert statement goes here" conn.committrans [/code]

Member Avatar for jhai_salvador
0
104
Member Avatar for achiman

The End.