2,627 Topics
 | |
| | hi guys just wanted to ask you about the specialization that you would choose and here are the options for example: .Net, Oracle, or Cisco??? I chose Oracle a while ago and already passed the requirements and form in our university. But still I'm confused because right now it keeps … |
 | i want to make j2me application for java supported phones. I have downloaded Wireless toolkit from oracle's website but it does not allow to copy, paste. There's many sites available giving sample source code for begginers but I dont know where to write those code in that wireless toolkit. Please …  |
| | I am having problem during installation of 10g. "the value of envoirmental varible is more than 10243. The value cannot be set ". I found that i have to set variable in Computer –> right click –> properties –> Advanced –> Environment Variables but how to do it? i need …  |
| | Hi guys, I'm a student and need to practice Oracle SQL queries since we have Advance SQL in our syllabus. I have Intel-based MacBook Pro running Mac OS X Snow Leopard 10.6.8. I just downloaded the SQLDeveloper for Mac and unzipped it. The application executed and started well. But I'm … |
| | create table A ( id number(6) , Amount number(10) ); create table B ( id number(6) , Amount number(10) ); insert into A values (1, 50); insert into A values (2, 500); insert into A values (1, 600); insert into A values (2, 900); insert into A values (1, 600); … |
| | hello I m 3rd year enginnering student in computer science field. I have to make project in DBMS using connectictivty with VB. could you plz suggest me the topics and guide me with ur valuable ideas. thanx Arpita Asthana |
 | Hi I have created many tables in database. Now when i used to create new table that's name may already exists. So, before creating new table i must know which table names are already exists in my database. And for that i want to display all the tables created in … |
 | Hi there, I've lost my password and username and am trying to log in using sysdba. It doesn't log me in and I would like to retrieve my username and password without re-installing the software. IS there a way of doing that?> |
| | Good afternoon. I am trying to import a csv file to a SQL database hosted through GoDaddy. However, I continue to receive an error which states "Line 7 has 24 values (20 expected)". Line 7 in my .csv file only has 20 columns (20 values) and no matter what I … |
| | Hi everyone, I had Oracle working perfectly fine and was able to connect to 127.0.0.1/apex . After a fresh re-install, I couldn't access the page. I can manage to log into oracle database by using SQL command line. I'm running Oracle 11g express edition. The message I get when I … |
| | |
| | Heyo guys, and girls Well, something to start with is that I'm lost... I'm a computer science graduate for 5 years now, and since then, I never worked at programming, been bouncing from one job to the other and that wasted a huge amount of time for me. So, lately …  |
| | Hi everyone, I'm sure the update statement is well-written but for some reason Oracle sql command line is refusing to execute it. UPDATE myTable SET country = 'Aus' WHERE username = '"martin"'; // I know you can see single quote and double-quote as well. Well, names were inserted into the … |
| | hii..sneha here , i'm studying in te-it, and i was in search for some interesting and innovative topics for my dbms project for which we have to use vb as front end & oracle as back end... so plss can u suggest me some of them.pls avoid regular & popular …  |
| | Please I am relatively new to Java and would really appreciate your help. Can anyone please tell me what I am doing wrong. I'm trying to send a string to an oracle and save it's output. My program just hangs when I get to this block of code. try { … |
| | Hi, I am fairly new to VB.NET and i'm just wondering if anyone can help with a problem I am having. I am looking to pass some parameters to a vb.net application fwhen I call the app from another program (written in oracle forms). My question relates to how these … |
| | I have created an application with report features. report features is created via iReport My application also contains a reports folder containing all .japser files Here is the code public MyiReportViewer(InputStream stream,HashMap parameter) { this(); try { /* load the required JDBC driver and create the connection here JDBC Type … |
| | Hey, Iv been looking around for a simple way (meaning less than 10 lines) to reverse the order of my bytes in a byte array. At the moment my code is: public byte[] outputarray() { byte b[] = new byte[10]; ByteBuffer buf = ByteBuffer.wrap(b); buf.putLong(output); } The problem is that … |
| | CREATE OR REPLACE PROCEDURE transfer( crdtacno IN NUMBER, dbtacno IN NUMBER, amount NUMBER, transno NUMBER ) IS BEGIN INSERT INTO transaction VALUES(transno,amount,SYSDATE); UPDATE account SET accbal=accbal+amount WHERE accno=crdtacno; INSERT INTO entrylist VALUES(transno,crdtacno,'CR'); UPDATE account SET accbal=accbal-amount WHERE accno=dbtacno; INSERT INTO entrylist VALUES(transno,dbtacno,'DB'); END; / |
| | Hello everyone, I have a table called job.In the table two particular columns are empid and managerid.When I am creating the table I must ensure that the managerid should be an existing empid.How do I write the create table statement for this.I am using oracle 10g. Thank you |
| | Learning php. Set-up IIS7 on my local Win 7 computer. Accessing data from an Oracle database. Dreamweaver for IDE. Created a simple form.php page, POST action to process.php, pulls data from Oracle. Works fine (for my first php project). But when I edit the process.php file to try other techniques, …  |
| | We are getting trouble when reading the data like ("â¦", "dóñez", etc) from a data file and storing into oracle DB, these are special characters and they must read and write into database as they are. These following areas where we are getting the problems: 1) when we use split() … |
| | hello iam using oracle 10g express edition actually iam not able to connect to sql plus if i enter the commands it shows an error mesaage as "not connected".so i tried another way of opening by connecting in oracle 10g go to database home page and entered my password and … |
 | I just finished installing ODTwithODAC112012 (Oracle Developer tool for Visual Studio ODT) on my system . Now I am trying to deploy dbmsclr.plb as SYSDBA from SQLPLUS But I am getting the error SP2-024 nothing to change. Here is the command window:- C:\>sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Tue … |
 | Hey! So i'd like to learn the JMF api. And to start i wanted to build an application that can capture frames/video from a webcam. Now, i started by trying to list all the devices: Vector info = CaptureDeviceManager.getDeviceList(null); if (info == null || info.size()==0) System.out.println("No Capture devices known to …  |
| | Hi, I am new to Oracle. I have installed Oracle 11g R2 standard edition (server software, 2GB download from Oracle). I found that the 'Environment Variable PATH' has not been set. Which of these directory should I use for the PATH value:- 1. Oracle base, 2. Software location or 3. … |
| | Hi all !! I am planning to do a masters in computer science from a US university. I am not sure which field I should specialize in. I have my interests, but job prospects are also important to consider, which I have little idea of. I am listing the specializations … |
| | Oracle : 11.2.0.1.0 Apache 2.0 Handler PHP Version 4.4.9 Windows XP I have problem to connect with Oracle 11g. Log apache : PHP Warning: Unknown(): Unable to load dynamic library 'C:\\Program Files\\Apache Group\\Apache2\\php\\extensions\\php_oracle.dll' - The specified module could not be found.\r\n in Unknown on li when I open phpinfo : …  |
| | how to connect data base in play framework backend oracle ?**Bold Text Here** |
 | hi guys i got some problem with this code error said that exact fetch row return more than expected rows CREATE OR REPLACE PROCEDURE "MAINTAIN_REQUESTSTATUS1" (emplevel IN NUMBER,eid IN NUMBER,depid IN NUMBER,teamid IN NUMBER) is lastreq number; seq number; stat NUMBER; tok varchar2(60); appr number; CURSOR c1 IS select empid … |
| | Hi! 1. Whats the difference between using these PL/SQL records? -Table Based -Cursor Based -Programmer Based 2. Whats the importance of using PL/SQL Table? 3. Whats the importance of using VARRAYS? 4. When to use these 3 RECORDS, TABLES, VARRAYS Thanks! |
| | Good Day! We would like to seek help on managing multiple values within a single XML attribute. <Row> <title>type Title here</title> <description>type Description here</description> <stage>Development</stage> <platform>Java, .NET, Mainframe</platform> <lifecycle>Custom Development</lifecycle> <servicegroup>System Integration (SI), Technology Consulting (TC)</servicegroup> </Row> With the above sample xml, as you may notice, <platform> does have 3 …  |
| | I have calendar in php and two veriable : date3 , data4 When i run a statement <input type="button" name="button2" id="button2" value="Date" onClick="javascript:alert('from date : '+this.form.date3.value+' ,to date: :'+this.form.date4.value);"> I have in response two dates I need to use this dates in query to oracle to filtr result from db. …  |
| | Hi Is it possible to add a new category and combining the old categories into one? It's very difficult finding answer on this category. It's **MYSQLI** & **PDO** there are some questions but not much. I had to go other forum to look for answers plus blogs but I prefer … |
| | $stmt=OCIParse($conn,'SELECT *FROM USERS where USER_NAME = "USER_1"); when I want to execute this stmt , I have problem with "32" , error: OCIStmtExecute: ORA-00904: "32": invalid identifier maybe somebody know how to replace "" to validate character apache 4 oracle 11 |
| | Hey there I have two separate queries and I am trying to figure out how to combine them into one. I've verified separately each one works. They are: SELECT FACULTY_t.LastName||', '||FACULTY_T.FirstName AS "Committee", STUDENT_T.LastName||', '||STUDENT_T.FirstName AS "Student" FROM STUDENT_T, FACULTY_T Where STUDENT_T.CommitteeID = FACULTY_T.FacultyID and select decode(COMMITTEE_MEMBER_T.FacultyID,COMMITTEE_MEMBER_T.ChairPerson,'Y') chair from COMMITTEE_MEMBER_T … |
| | Hi I want to install the following on my new laptop:- 1. VB6 2. Crystal Reports 8.5 3. Crystal Reports 9 4. SQL Server 2005 5. VS 2005 6. SQL Server 2008/SQL Server 2008 R2 7. VS 2008 8. Oracle Server 9. Microsoft Office 2007 What sequence should i follow …  |
| | hi to all, i want to create user on student table IN ORACLE.... CREATE USER john IDENTIFIED BY out_standing DEFAULT TABLESPACE users QUOTA UNLIMITED ON users DEFAULT TABLESPACE temp QUOTA UNLIMITED ON system; but, oracle shows following error like...."insufficient priviveleges on password... please give some suggestion for creating user in … |
| | I have two problems... Here is code : <?php // Create connection to Oracle $conn = oci_connect("root", "admin", "//127.0.0.1/xe"); $query = 'select * from TEST_RESULTS'; $stid = oci_parse($conn, $query); $r = oci_execute($stid); print '</br>'; // Fetch each row in an associative array print '<b> MONITORING SRODOWISK TESTOWYCH </br>'; print '</br>'; …  |
 | Hello DBAs, Any one familar with the ER diagram generation in TOAD. I am able to generate the diagram for one particular table. I need to generate for the whole schema. Can you please help me to find out a way? Always Thanks, BMantri |
 | Need help urgently. Can anyone please help me finish up a project which i have a deadline to meet in 3 hours time. It's a camp application to input and store the records of the children from my church! I have created the GUI and I am left with the …  |
| | hi, can we use sub query in order by clause?? and how? |
 | Hi! DaniWeb has tons of intelligent people – woot woot! If they gave rewards for intelligence then, wow, - we might just have to go for broke! But anyway, I surfed DaniWeb wide and far, long and deep, from uber smokin' article to article. A few questions and realizations came …  |
| | Hi, My Application was developed using c#.NET with java web services to connect to oracle database. It is working fine with my windows XP machine, but when i deployed the same app in another win7 machine by just cpoying the release folder with dll and exe files and launched the … |
| | I have about 16 tables in a database schema that are empty and wish to populate them with junk row values of the same type which I have defined,is there a way to do it? |
 | I created the GUI to display the monthly mortgage payment for any loan principle at a specific term and rate. The GUI works fine but I have some improvements I can't seem to figure out and I need to display an amortization table. Issue# 1: I am usure how to … |
| | Hi I'm a final year university student and i'm running into a bit of trouble with my final year project (It's very important) My task is to create a DBA (Database Administration) tool in visual basic to allow me to add/edit/delete users from an existing oracle(sql) database. I really don't … |
| | //Hi, //I want to make an application that sends email; the email need to be taken from an oracle database, I had make the email code and it is working succseeful and also I made the coonection to the database in the next class which is also working successfully, but …  |
| | |
| | IN ORACLE 10G I CREATED A TABLE AND INSERTED 3 ROWS AND COLOUMNS.NOW MY DOUBT IS WHERE THE DATABASE FILE WILL BE STORED????THE REASON WHY IAM ASKING IS BCOZ IT MAY NEED FOR JAVA CONNECTIVITY |
The End.