2,359 Topics
I know many will start with ODBC, but slow down ;) I have searched for ODBC and all I find is UnixODBC. Is this the same as ODBC? Also how stable it is? I will be happy to know some apps/companies behind it! I need support for MySQL, PostGreSQL, DB2, …
I wish to delete all the tables that I have made so far........What should I do ???? Please help !!!
Hi everyone I am a newbbie to writing on fourms and could use a little advice. I currently have a degree in CIS and Business Adm. but I am having a hard time deciding what kind of job I am qualified for. I have learned to program in COBOL,VB, Dreamweaver,Access, …
I'm trying to print at a resolution other than 72 DPI, I managed this using the PrinterResolution (see the code below) but I am having a problem with the printable area. When I change the resolution to 300 DPI I just print everything smaller (ie the getImageableWidth() etc are still …
Hi I want to make my career in Oracle and there are different streams in Oracle like : FUNCTIONAL , TECHNICAL AND DEVELOPMENT. I am quite confused choosing a stream,which will help me in getting my dream job and will offer me good growth in an Organization, so that i …
I made 10 tables for a project. But the first 9 tables along with the values that I entered, are saved in the database. But the last table is not able to save it's values. I have to enter the values every time I run SQL. It always shows "No …
Hi there developers! I'm trying to develop my own online multiplayer game, using the DarkGDK. But I don't want everyone to have access to the media of the game, so I'm working on my own cache archive format. This is how it works: .idx0 = textures .idx1 = sprites .idx2 …
Hi, I am trying to run sql command on unix. this results in the following error "sqlplus: not found" Here is the unix part [CODE] sqlplus id/pass@some_server.com<<eof select sysdate from dual; exit eof [/CODE] The database is on a remote server and. Do I need to enter all the tns …
I have made 8 tables, that are connected with primary keys among each other......What command should I use, to delete all tables at once ????
[CODE]create table items_avail ( pro_id varchar2(10) primary key, mod_id varchar2(5), comp_name varchar2(25) ); [/CODE] I wish to remove the primary key constraint......and add make the prod_id and mod_id as primary keys together. i.e. primary key(prod_id, mod_id) But he thing is this table is already connected to three more tables by …
Can anyone please help me with installation of oracle 11g on windows 7 home basic 64 bit? On prerequisite check its giving an error that "this version is supported by os version up to 6.0 only and not by this version 6.1"
[CODE] create table item_avail ( pro_id int primary key, mod_id int, color varchar(10) ); create table Laptop ( pro_id int primary key, mod_id varchar(5) not null check (mod_id like "L%"), color varchar2(10), comp_name varchar2(20), RAM number(5), spaceHD number(4), foreign key (pro_id, mod_id, color) references item_avail (pro_id, mod_id, color) ); create …
hello friends, can i change the port of oracle 10.i am using tomcat 6.0 and both are using same port 8080.so how could i use oracle with tomcat in windows 7.Reply plz.
hi all i was wonder if its possible to join 3 tables, so i could see the result from the 3 tables. for example lets say that i have INVOICE(invoice_id, client_id,item_id) CLIENTS(id, client_name) ITEM(item_id, item_name) i want 1 table that shows: invoice_id, client_name,item_name is this possible? 10x!
I've looked at this from every angle, but can see nothing wrong. The MS Access table "LocationLinks" contains only 6 fields. LocationLinkKey - autonumber, primary key. LocationKey - long integer, required, indexed, duplicates OK LocationType - string length 4, not required, not indexed RelatedLocationKey - long integer, required, indexed, duplicates …
Is it possible to store images in oracle db, if yes then what will be the data type of the field.? Please illustrate with example....thanx a lot.
Hey .. Everyone ... I'm now to java .. I'm trying to figure out .. how everything fits together .. well .. i have a project that I'm working on .. .. basically it a type of quiz working on java .. where a user takes a simple MCQ quiz …
Hello Every body! I installed oracle 11g and toad 10.6 & when ever i click on the exe of Toad i get this error "[B]olepro32.dll is not a valid windows image[/B]" i browsed for this error but found no solution. i remember when i installed toad last time with the …
Hello, I am a current Java student and am having a problem when I run my compiled program from an in chapter lab assignment called "Stock Tracker". I receive a message from a dialog box "Cannot locate sun.jdbc.odbc.jbcOdbc Driver. Class not found exception creating database object. Following are a list …
I am using a FileUpload control to allow the user to import the contents of an Excel spreadsheet into an DataAdapter and then import into an Oracle database table. This works great when I use a local filesystem project. However, when I try to run this on the server, I …
I work for a government department that stores a fair amount of private data in a database.In an attempt to secure database access, we have created a database table that contains all of the database logins and passwords. We have also created a class called "db_connect.php" which contains the login …
Hello every one. I had sign up daniweb just one day ago. My name is Abid and I have master degree in IT. I work in VB, C, oracle, asp and etc. I want to introduce me and Hello to every community member. Thanx
Hi..i am calling a method where i am selecting a row from DB, this is happening n no of times....bt after somoe no of select statement, connecttion has been lost. Is there any type of limitation with no of select with hibernate. or any issue with .hbm file... my .hbm …
I had a small issue. Can you pls check this... I have two tables TABLEA,TABLEB. TABLEA -------------- col1 col2 col3 TABLEB -------------- cl1 cl2 cl3 If col2 in TABLEA = cl2 in TABLEB, then i need to update cl3 in TABLE B with col3 in TABLE A. I tried running …
Howdy, I want to make a sql that goes to oracle. the sql should be "Select "cusip", "price structure" from tableA" (basically the columns are wrapped in double quotes. I used this synatax in C#: string mysql = "select "+'"'+"cusip,"+'"' + '"'+ "Price structure\"" from tableA" and I am getting …
hello i am using oracle 9i enterprise edition i want to open isql plus in my browser please tell me how to do it. i am very beginner to oracle. please help me.
hi.. What are the significance and constraints of a primary key? Thnxx
i have a project in c# code with 3 leyer; and all of database code are in data leyer, which method is better? 1- send sql string statementto data base for select or update? 2 - using stored procedure? in databases with larg scale wich is better? pleas help me?!
when i run my code...this error come out [QUOTE]"data type mismatch in criteria expression"[/QUOTE] here my code: [CODE]Private Sub Text2_Change() TXT1 = "" TXT1 = "SELECT * FROM Profile WHERE sID =' " & Text2 & "'" If RS.State = 1 Then RS.Close End If RS.Open TXT1, Conn, adOpenKeyset, adLockOptimistic …
hi guys... i use windows7 32 bit edition on my notebook recently i installed oracle 8 on this... the installation completed successfully but when i try to start database... i get the message that the database could not be started -> i tried starting in services.msc but failed -> when …
Hello, I am using vb6 as front end and oracle as back end. i want to insert new row in database using adodc. i put adodc1.recordset.addnew on command's click event....do i need to mention adodc1.recorset.save or adodc1.recorset.update? and while executing the code text boxes are becoming blank whenever i goto …
Well i can see lot of career related questions are posted here So i thought i could contribute something for youth. with more than 5 years of Experience in above subjects I have decided to take classes. Location : Mumbai . Subjects: C Java: Java Basic. Advance Java. C#. VB …
Hello everybody!!! I just want to ask some internet sites where I can download Oracle server like mysql and sql server because I want to learn about how to use it. I have already knowledge about sql and mysql and how to access them using vb.net, and for more improvement …
dear sir madam i give oracle permission to folder this way [root@srvr1 ~]# chown -R oracleinstall /oracle/* [root@srvr1 ~]# chmod -R 775 /oracle/* so what it did each every file, it attached filename* (asteric * in last) now each file shown under /oracle directory looks with * can someone give …
hi i m doin III yr cse i hv to do mini project on hospital management system by using vb as front end and oracle as back end can anybody help in modules....... pls.......... waiting for u replies
According to Codd's Tweleve rules which are considered as a basics of the relational database system, which one of the following three systems: Oracle, DB2 and SQL server is most applied and relational than the others? Please give me your opinion and why.
Hello Everybody I am doing oracle 10g d2k it means the front end is forms so can anybody suggest me a good topic for project development and what are the thing that are need to be included or taken care of when developing the project Thanks & Regards
I have made a project in vb with oracle 9i at back end....its almost complete... however i can't code the previous button on d form... i used rs.moveprevious property but it generates an error... help!!!
hai its mahadevan,please reply how to connect oracle with vb.
Hi Friends I have a challenging task in SQL (Oracle). Let me know if you have any answer. I have 2 tables. 1. Dept 2. Employee Dept [B]Dept_No Dept_Name[/B] 10 Admin 20 Data Warehousing 30 HR Employee [B]Employee_No Employee_Name [/B]Dept_No[/B] E01 Sangeetha 10 E02 Michael 10 E07 Immanuel 20 E11 …
Hi i want my formatted output should be in a straight line : 1 2 3 4 5 6. Is this possible in PL/SQL ? declare n number:=0; begin loop n:=n+1; dbms_output.put_line( n ); exit when n>=6; end loop; end; / Output : 1 2 3 4 5 6 PL/SQL …
hi i am using oracle 9i and now a days i am learning sql. due to some problems i have to change my system and i will install oracle 9i in my new system, but problem is that after installing i need all that old tables that i have created …
Hi friends, I would like to introduce myself, I am Manim from Singapore. Currently working in Olam International singapore as Oracle DBA. Also interested in web development and seo topics. I have created few websites (SNIP SNIP SNIP ha..ha.. i'm not promoting my sites, just for info.) and learnt something …
hi everyone, and this is me officially making my first post. came here looking for some code and ended up doing lots of reading :-) anyways, im currently in computer programming and i use programs like netbeans, eclipse, visual studio, oracle (through a linux environment in vmware) and dreamweaver. right …
hello world; i want to know how i represent or write "IN" in relational algebra; lets if i have the following query; then how i write in relational algebra select CourseTitle, Amount from DegreeCourse, Fee where DegreeCourse.FeeType = Fee.FeeType and Amount IN ( select MAX(Amount) from Fee );
Hi I am learning SQL at school. I need to work with Oracle 8.0 or any other version before 9i. I have tried to do it, but just came to know that its antique. Hence I need your help to download it. Kindly give me the link.
how to connect vb with oracle...?? Very urgent.. plssssssssssssssssssssssss..
i need a simple project on dbms ...... with vb as front end ....... no fixed project title ....... if you have any pls mail to me............. my id is [removed]
The End.