2,627 Topics
 | |
 | I am trying to format my text firlds so that if the user inputs letters or somethings improper, it will display an error message and ask the user to retry entering the number. i am not quite sure where to start with this part. i have the calculator code working …  |
| | ***My tnsNames.Ora File -*** XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Sonia-PC)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) … |
| | hey all i have a table in my project which called tasktable it retrives data from database (oracle) how can i change the color of the row that has the color in the cell ex. (i,8) Automatically when i click in refresh butomn i have tried so many times to … |
 | hey guys, i was looking into rewriting the php custom framework at work into java. i was going to download the J2EE but there is 2 versions. J2EE SDK (regular) and J2EE Web Profile SDK http://www.oracle.com/technetwork/java/javaee/downloads/index.html i've look at the descriptions and the includes and it look the same. whats …  |
| | how to drop multiple columns at a time.. i tried with the following syntax "alter table <table_name> drop column <col_name1>, <col_name2>" but i am getting syntactical error. |
| | can we use double quotes to the column name while creating a table?? if yes, then how to insert the records into it???  |
| | I am looking forward to develop game in java and might sell it as well so here is the question: Do we need to pay fee to Oracle if we sell our game on the market or host it on our own web site with advertisement on the game page? …  |
| | Hi All, I'm currently working on finding a solution to strip/edit a texfile in order to pass it through to Oracle's SQLLOADER which in turn will import the data into a table. The textfile will need to be imported into a clob column inside the first table after which the …  |
| | <? $connect = mysql_connect("localhost", "adamf", "adamf123") or die ("Wrong password, jerk."); mysql_select_db ("adamf"); $insert="INSERT INTO product (product_id, product_name, product_type, product_brand, product_year) VALUES (1, 'Cyber', 1, 1, 2001), (2, 'Motive', 8, 1, 2005), (3, 'Oracle', 8, 2, 2005)"; $results = mysql_query($insert) or die(mysql_error()); $type="INSERT INTO producttype (producttype_id, producttype_label) VALUES (1, 'Heads'), … |
| | i have a doubt.. once i created new user called user1 in oracle database with default tablespace say user1, if i import data from user tablespace, after that the data will occupy space user tablespace only. i want to know how to move data from user tablespace to user1 tablespace. … |
| | Hi, im trying to query an oracle db set up of table is all done and filling it is fine but when i try to send a query to the db using a resultset to store the outcome im getting the error "cannot convert int to ResultSet" ive looked at … |
| | Hi, I'm already using ORacle 11G . The problem is when i'm using System.Data.Oracleclient to pull blob into picturebox it's ok, but when i'm using OracleDataaccess.Client / Types.....there no image appear n comeout error " Parameter is not valid" in this coding :- > Quoted Text Here Dim bmp As … |
 | Hello, I want to change the datatype of a field from Varchar to integer in T-SQL. I tried something like Modify like you use in Oracle. ALTER TABLE tablename MODIFY COLUMNNAME Datatype. But its not working in SQL server.. Any thoughts. |
| | hi friends kinldy suggest me a suitable version of linux os which is suitable for java,j2ee programming ,mysql and oracle thanking you  |
| | |
| | Hello friends, I am working with jsp and oracle database and The problem is after inserting 3 enteries(rows) through form filling into database next enteries are not going in databse.So please suggest me something.  |
| | //Application Forms import java.awt.BorderLayout; import java.awt.Color; import java.awt.Component; import java.awt.GridLayout; import java.awt.HeadlessException; import java.awt.Panel; import java.awt.Rectangle; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.KeyEvent; import java.awt.event.KeyListener; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.Vector; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.JTextField; import javax.swing.table.TableCellRenderer; …  |
| | hello dear members i need some help. i will try to explain the scenario. i am currently working in a office and they want to implement a software which is already designed by the vendor. this software will provide automation of current business needs. this software as per vendor description … |
 | Hi guys, Really need help I have this case i have a sms gateway and php with oracle database runnin my system is filling a leave now if i want to text leave<space>143 from mobile phone it will i can file leave directly from my database really appriciate your smart … |
| | Below is my scripts: <% connstring ="Provider=MSDAORA;Data Source=(DESCRIPTION="&_ "(ADDRESS=(PROTOCOL=TCP)(HOST=cqcmdb1.corp.mot.com) (PORT=1521))"&_ "(CONNECT_DATA=(SID=CQPD2)));User ID=report_ccmpd_ro;Password=report" set con = server.CreateObject("ADODB.Connection") con.open connstring set conn = server.CreateObject("ADODB.Connection") conn.open connstring sqltest = "select T1.screen_failure, DBMS_LOB.SUBSTR(T1.ROOT_CAUSE_ANALYSIS,9000,1) AS RCATT from Submission_Record T1 where T1.dbid <> 0 and (T1.Headline like '%[O2O7]%')" set rs=server.createobject("adodb.recordset") rs.open sqltest ,con,1,3 sqltestonly = "select … |
| | guys am a newbee and starting to use oracle as a database for php i just want to ask on how to connect php to oracle then how to select a particular database is there an equivalent function for this in oci "mssql_select_db" |
| | It's my first time to use oracle and i'm kinda lost :S I'm using netbeans v6.8 and i want to make a connection between Oracle 10g DB and java to make my program insert and retrieve data from the db - i tried searching for oracle's libraries to include it … |
| | hi have a nice time, guys can you provide me a complete list of orcle queries (SQL / PLSQL)  |
| | I installed Oracle9i on my PC which run Win XP. But I can not open "isqlplus" in my web browser. I have some more machines which connect to the server through LAN. And I want to run oracle isqlplus on those system by the IP address of server machine. I … |
 | HI there, I am doing my internship with accenture and i got my first assignment. Basically i first thing with this task is i need to find way to modify the query so that it will pull only the data that has existed/activated more than one hour. This is the … |
| | I have installed the Oracle 10g at the following location : - ***C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN*** But I was trying to ping Oracle Client from Command Prompt. See Below : - c:\Oracle>tnsping SONIA **ERROR IS COMING no listener** MINE tnsnames.ora File : - # tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora # Generated by Oracle … |
| | I want to convert the following SP to SQL, but I am not able to do ::- ORACLE SP create or replace PROCEDURE "USP_TEST" ( p_CURPRODUCTTYPE out sys_refcursor, p_PROD_ID IN TBL_PROD_MASTER.PROD_ID%TYPE :=NULL ) is begin open p_CURPRODUCTTYPE for SELECT PROD_ID, PROD_CODE, PROD_NAME, PRIMARY_UOM, SECONDARY_UOM FROM TBL_PROD_MASTER WHERE TBL_PROD_MASTER.PROD_ID =NVL(p_PROD_ID,TBL_PROD_MASTER.PROD_ID) ORDER … |
| | Hello, I am building a blog - just to shapen my skills. Since leaving college I feel like I have been loosing my programming edge. I work in IT and I primarily work on Oracle databases as a developer. Here is what I am building - a blog. I have … |
| | I new with database and java.I want to show result of the table WHERE USER = USER LOGIN NAME private void query() { try { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@andy-lcoyx7gfw:1521:orcl", "andy", "andy"); String sql = "select * from schedules where (userName = @User) "; //'{$_SESSION['username']}' Statement stmt = con.createStatement(); ResultSet …  |
| | I have 2 queries I have to create but they sound the same. Note: I am just learning the theory behind SQL and not actually working on a DB at this time Directions: 1. Show all the categories for each book with the book number, title, category number, and category … |
 | `select s.sname as stationname , sum(di.quantity) as quantity from demand_information di, demand d, company c , station s where s.sno = d.sno(+) and di.demandno = d.demandno and d.cno = c.cno and c.cname = $P{companyname} and to_char(d.demanddate,'MM-yyyy') = $P{gdate} and di.pno = (select pno from products where productname = $P{productname}) group … |
| | hi how to fix org.hibernate.HibernateException i am using eclipse and oracle 10g thanking you  |
| | I created a JTree and also created a class which implements `TreeSelectionListener` then I pass that object into the JTree's function `addTreeSelectionListener`. In the [JavaDocs](http://docs.oracle.com/javase/tutorial/uiswing/examples/components/TreeDemoProject/src/components/TreeDemo.java), there is an example where they implemented the function `public void valueChanged(TreeSelectionEvent e)` within the main class and passed `this` into `addTreeSelectionListener`. I tried to … |
| | could you please tell me what is high water mark in oracle terminology? Please explain with example. |
| | here is my dilemma I have a database that consists of tables (duh!) for an award nomination project where I have a table for nominees and a table for each category of qualifications for example table 1 (nominees) name ID_NUMBER PK DEPARTMENT NAME PHONE# table 2 (education_information) ID_NUMBER FK DEGREE … |
| | |
| | Hello I am running into an error after creating the jar file. I get a message stating that the main class to my program could not be found when in fact there is a main class. If someone could give me a hand and lead me in the right direction … |
 | [From the Oracle Forum](https://forums.oracle.com/forums/thread.jspa?threadID=451115) Hi all. I'm developing a simple database system that holds staff, customers and booking details for photography service. I've four tables - package, admin, customer and booking. Right now I'm in the process of creating application which has simple forms in it. The form I'm trying … |
| | hi, iam not sure if this is sql question or not. but i just download "sql developer". from oracle website. and i need help setting it up. i want to connection to my localhost (myphpadmin). how can i find these things. connection name: no idea username: using myphpadmin username which …  |
| | Hi, I have c# Application running in my desktop(Windows XP) with Java web services and oracle DB . The Application includes a shipping screen which has a calendar window. When I run the application in my desktop it works fine. Client uses the same application. We access it through CITRIX … |
| | Hi, I am running Java 1.6.0_31 on my machine and would like to have "Nimbus" set as the default look-and-feel for my Java applications. I have followed the instructions obtained from the Oracle java website i.e. by creating a text file named **swing.properties** with the following line of code **swing.defaultlaf=com.sun.java.swing.plaf.nimbus.NimbusLookAndFeel** … |
| | Hello, I'm trying to install 10G on Suse 9 Kernel 2.6. Following the tutorial on Oracle site or the product manual, the memory setting must be done on /etc/SYSCTL.CONF. However, this file doesn't exist on Suse and I don't know where I will put the parameters! Did someone tell me … |
| | can any one help me out i want to make an application using oracle . i want to know evrything from scratch. plzzz tel me i am so eager to make it[COLOR="Red"][/COLOR] |
| | Hi, I have following table structures. # Table1 # link - varchar hlink - varchar top-cap - varchar (FK) sub-cap - varchar (FK) lk - varchar(PK) # Table 2 # cap - varchar(PK) caps - varchar captype - varchar top cap and sub-cap in Table1 are FK. They refer cap … |
| | Greetings to all, I have two functions: Function 1: ImageToByteArray: Is used to Convert an Image into a Byte Array and then Store in an Oracle Database, in a BLOB Field. public byte[] ImageToByteArray(string sPath) { byte[] data = null; FileInfo fInfo = new FileInfo(sPath); long numBytes = fInfo.Length; FileStream … |
| | I have been working all day on sql developer but now i am trying to work again and when i try to connect it is giving me the following error what shall i do? oracle.javatools.db.DBException: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection at oracle.jdevimpl.db.adapter.CADatabaseFactory.createConnectionImpl(CADatabaseFactory.java:66) at oracle.javatools.db.DatabaseFactory.createConnection(DatabaseFactory.java:534) … |
| | Whenever I tried to access Oracle DB from PHP , it shows error Everything is ok, Path is okay. I changed php.ini file to. I am using old version of xampp Warning: oci_connect() [function.oci-connect]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the … |
| | Good day, all! I just joined DaniWeb and I am excited about the community. I am not new to programming (I was using C# when it was called COBOL :-)), but I am trying to update my skills and like the idea of having a "home" online where I can … |
| | Can anyone explain me RR DATE FORMAT in Oracle, its getting pretty confusing for me. Appreciate your time and effort. |
| | I have installed oracle10g but I cannot find any java sample programs for data mining! I could not find any download link on the internet! Please help! |
The End.