2,627 Topics
 | |
 | just installed SQL Developer 4 and I'm using Oracle Database 11g. I want to execute multiple insert into statements in the worksheet at once. That works fine if I copy paste via command line of SQL but in Develop 4, only one row is being inserted at a time. Is … |
 | Java vulnerabilities have hardly been out of the news during the last year. Here at DaniWeb we've covered a number of the stories as they surfaced: [Java in the cross-hairs: the security debate rolls on](http://www.daniweb.com/software-development/java/news/445532/java-in-the-cross-hairs-the-security-debate-rolls-on), [Is Java 7 still insecure? Oracle Patch doesn't fix underlying vulnerability](http://www.daniweb.com/software-development/java/threads/432479/is-java-7-still-insecure-oracle-patch-doesnt-fix-underlying-vulnerability), [Update my insecure Java … |
| | i am using the below code for creating the connection to database. connectionURL = "jdbc:oracle:thin:@//testdsfsdfgs:1521/TEST"; conn = DriverManager.getConnection(connectionURL, userName,Password); i want to set the transaction time out. How can i do that. Please some one help. Thanks in advance |
| | hi I had a question in an exam that asked for the code of a trigger that cancels a transaction if a query result doesn't meet a condition in oracle database. is it possible? I am googleing but I can't find an answer thanks |
| | hi all i want to select data base of the value of the cursor but i donot know how to do it . thanks in advance |
| | I am trying to read all the files in a folder, if the file name == that of the name the user entered, the text of a button (that when on clicked will open the file) will be set to the file name. But my code for some reason doesn't … |
 | Hello everybody, Its been long since i last posted on DaniWeb. The organization i work for is shifting to a new system and for this, our database is running on Oracle 11g 11.2.0.2.0 We increased the size of one of the partitions existing in the HP 3PAR Storage which is …  |
| | Ok, here is one that we are strugglling with to find a potential source of "slowness" (as defined by the users). We have 4 staff that have new, Windows 7 machines connected to a Cisco 3750 Access Switch (connection is 1 GB, and connected through a Cisco 7975 phone). Connections …  |
| | Is it possible to use Kohana ORM with MySQL AND Oracle DB? More wider questions is is it possible to use two different databases (RDBMS) with Kohana? |
 | update mytable set mycolumn = trim(mycolumn) I am using above query where mycolumn is of type char. It trims the leading blank but not trailing. I tried update mytable set mycolumn = TO_CHAR (trim(mycolumn)) But it didn't help either. Can anyone help here?  |
| | Hi, I have some hijacking virus that I can't get rid of. I've tried Malwarebytes, tdsskiller, Skybot, AdAware and Superantispyware, cleaned some things, but it persists. Can anyone help? Below is the hijackthis log. Many thanks for any input. Logfile of Trend Micro HijackThis v2.0.4 Scan saved at 9:00:16 PM, …  |
| | Hi all, I have recently been give a project to create an invoicing system for a small business. The system needs to be able to easily add new customers and store them for usage within invoices. There also needs to be a form to enter invoice data and invoices need … |
| | I am working on a Java to C# conversion project. In this project, my custom java library uses `java.net` packages [`DatagramPacket`](http://docs.oracle.com/javase/1.4.2/docs/api/java/net/DatagramPacket.html) and [`DatagramSocket`](http://docs.oracle.com/javase/1.4.2/docs/api/java/net/DatagramSocket.html) classes. Are there similar classes in .NET C# with similar functionalities?  |
| | Hi, I am using windows 7 sp1 32bit, try to install "Oracle 11g release 2" I am getting below errors and not properly installed help me to solve this errors thanking you file not found C:\app\I\product\11.2.0\dbhome_1\oc4j_applications\applications\em.ear file not found C:\app\I\product\11.2.0\dbhome_1\oc4j_applications\applications\em\em.war file not found C:\app\I\product\11.2.0\dbhome_1\ctx\admin\dr0ulib.sql.sbs file not found C:\app\I\product\11.2.0\dbhome_1\ctx\admin\dr0ulib.sql.sbs file not … |
| | Hi, I am trying to generate a spool file through below anonymous block in order to find out views on a particualar table. declare cursor c1 is select view_name,text from users_view; rt c1%rowtype; begin open c1; loop fetch c1 into rt; exit when c1%notfound; dbms_output.put_line(rt.view_name || '|' || rt.text); end … |
| | |
| | A friend asked me to rewrite a program for him. Though the problem is it s using a rdb database, i am assuming this is a dec/oracle rdb database. Which i honestly never used and have no knowledge of. So i was wondering if there is any way to convert … |
 | Dear All, I am in the mid of my career, I am Computer Graduate, I have equal experience in Networking, Oracle Developer and Oracle DBA as well, as my previous two experiences have a kind that I had to deal all of these very closely, now I am at the …  |
 | [This](http://docs.oracle.com/javase/tutorial/essential/concurrency/deadlock.html) is the example i was looking at. The docs say that trying to access the bowBack() method is creating the deadlock , but im new to threads , and i really dont understand why this is happening. In need of some guidance here...  |
| | i want to ask you when i execute the following sql statement SELECT account_identifier,least(to_number(part_1)),least (to_number(part_2)) FROM TEST5 ; i get the following error ORA-01722: invalid number 01722. 00000 - "invalid number" you should know that when i execute the following sql statement SELECT account_identifier,to_number(part_1),to_number(part_2) FROM TEST5 ; it works fine |
| | I have created four tables in apex oracle and I also need to create four statements which display information from all four tables or just a few of the tables, I have tried writing up advanced statements myself but they are not advanced enough, can someone please help? |
 | weather oracle forms language is usefull in mnc's... how will be its job openings |
 | Hi, Guys! Actually I want to ask about servlet and ajax. Sorry if I post in wrong room, I have search the room that suitable for my question, but the most suitable is here. I'm developing a push notification for web using servlet + ajax. I have done an tutorial … |
| | How do you create lists in an APEX form which allow many checkbox selections? How do you store these in database? |
| | Here i am trying to load data from TABLE1 to TABLE2. The requirement is to consider those records in the TABLE1"where TABLE1.COL1=TABLE1.COL1 (OR) TABLE1.COL2=TABLE1.COL2" As a single group and insert into TABLE2 with COL3 with a unique value for each group thus identified. TABLE1 ~~~~~~ COL1 | COL2 1 | … |
| | [this](http://docs.oracle.com/javase/tutorial/uiswing/examples/components/TextComponentDemoProject/src/components/TextComponentDemo.java) is the code i was looking at.Its about how to use JTextPane and related swing text Components along with actions and keymaps. my question is that in this part textPane = new JTextPane(); textPane.setCaretPosition(0); textPane.setMargin(new Insets(5, 5, 5, 5)); StyledDocument styledDoc = textPane.getStyledDocument(); if (styledDoc instanceof AbstractDocument) { doc … |
| | I have desided to go in database line... many people suggested to go for oracle developer course(sql,pl/sql,oracle forms) and do DBA after getting placed in a company as a oracle developer.. weather oracle developer course will be usefull to get a job as a fresher... else what will a better … |
| | Dear Experts, I am facing following problem with oracle 11g while programming. ORA-12505: TNS:listener does not currently know of SID given in connect descriptor System has four database is connecting through sql developer successfully but ohters are not connected. When i am again creating same database for correcting error it … |
 | I am stuck on the final part of the query, I know that this thing is easy, but I am out of ideas now, so sorry for this. I have prepared a query like this: SELECT A.projectName as PARENT, (select COUNT(*) from PSPROJECTITEM WHERE PROJECTNAME = A.PROJECTNAME) parentprojecount, B.ProjectName as … |
| | I have been working on a conversion project for last few days where I need to convert a Java library to C#. At one point I came to java's certain feature called [Exceptions Thrown by a Method](http://docs.oracle.com/javase/tutorial/essential/exceptions/declaring.html). Here is a little glimpse of it: public boolean isRequest() throws NullPointerException { … |
 | i'm new to web designing. i'm planning to create the website which will store user information in oracle database. my questing is is it possible to connect oracle 10g to web page(form)? need tips.. |
 | Hello DBAs, Can any one guide me how can i get the last modified date(insert/update/delete) of a table? Regards, B. Mantri |
| | Hi, I typed the below code in oracle 10g express edition. [CODE]SELECT emp_id, last_name, salary, dept_id FROM employees WHERE emp_id = &employee_num [/CODE] I get an error; ORA-01008: not all variables bound Can you pls help? Thanks. |
| | Hi everyone, I'm in the middle of a project, and I've been asked to partition the letter where Oracle is going to be installed. This is my first time doing any kind of partition, can someone help me. Thanks |
| | Hello, I need description about ORA error 26759, i tried to check decumintation for cause or action but with no luck, would anybody help me diagnosing why i saw this error on my 11g Oracle DB. Thank you in advance. |
| | Hi, I am new to oracle. I have this following query : SELECT TYP_CD, SUM( INVC_AMT), trunc(ALLOC_RUN_DT) as "Alloc_Date", MIN(ALLOC_RUN_DT) as "Minimum_Time", MAX(ALLOC_RUN_DT) as "Maximum_Time" FROM allocation_header group by TYP_CD, ALLOC_RUN_DT order by TYP_CD, "Alloc_Date" and the sample output I get is : TYP_CD INVC_AMT ALLOC_RUN_DT Minimum_Time Maximum_Time 01 20520232.31 … |
| | I'm not sure if this is the right place to ask , but is this erd valid? Or is it unacceptable? Thank you for any help. |
| | I have created a application which connection to sql server database as well as oracle database The application is working fine at my end And to connect to oracle i used following namespace using Oracle.DataAccess; using Oracle.DataAccess.Client; But when i run the application on user end It gives following exception … |
| | Am trying to add a constant column to the select query which is quering an inner query. Need your help with the query. select *,'1' as flag from ( select ROW_NUMBER() OVER (PARTITION BY e_id ORDER BY birth_date DESC) as rn,wh.birth_date,e.*, xy.m_id from employee e inner join table2 xy on … |
| | what is the SQL command (Query) to create category and subcategory in oracle thanks for your time. |
| | Hey everyone I need some urgent help please. I don't know how but I need make a Time Dimension of an Oracle Table using c#. What needs to happen is: -I want to use Order_Table's Date Column to Create a new table Time_Dim with columns OrderID, Year, Month, Week, Day. …  |
| | - Please how is possible (probably dirty hack) to create [How to Create Translucent and Shaped Windows](http://docs.oracle.com/javase/tutorial/uiswing/misc/trans_shaped_windows.html) - undecorated container (returns *java.awt.IllegalComponentStateException: The frame is displayable.*) - change Look and Feel for (returns *AWT-EventQueue-0" java.awt.IllegalComponentStateException: The frame is decorated*) - by using code from linked official tutorial . import java.awt.*; … |
| | Hi everyone I need help please. I need to create a Time Dimension of an Oracle Table using C#. I have no idea how to do it. Any Suggestions? Thanks in Advance |
 | With the constant growth of NoSQL databases, wouldn't it be convenient if Daniweb had a nosql forum? Maybe not specialized forums like MSSQL, MySQL or Oracle, but a general forum for NoSQL database systems.  |
| | Hi All, I have two machines, one Solaris and another Linux. On my Linux machine , i have Oracle10g installed and have one instance(say firstInst). I have Oracle 10g installed on Solaris also. When i try to connect to this firstInst, from Solaris , i get error like *sqlplus sys/sys … |
 | hey there, I have created this simple app that makes use of a Robot instance. It is a network app that I control using telnet. I have tried it in two different computers. It works fine. However, in one of my computers, I manage to start my robot app through … |
| | Hi, I am currently working on joining 2 tables, however those tables have different number of columns thats why I have difficulty on joining them. I tried to use FULL OUTER JOIN, close result but still not my expected output. You can kindly see my attachment to see the scenario. … |
| | How to convert oracle forms to php, is there an easier way to do that. |
 | Hello, I want to create tables in database (using SQL) and add foreign keys to each table refering to the other one. For example: CREATE TABLE ONE( ID INT NOT NULL, NAME VARCHAR(20) NOT NULL, TWOID INT NOT NULL, PRIMARY KEY (ID), FOREIGN KEY (TWOID) REFERENCES TWO (ID) ON DELETE … |
 | I am making an examination system desktop application in Java Swing. I have a frame named 'show_class_question' frame. This frame is used to display questions and four options from database. Whenever user clicks 'Next' button I am calling this same frame (show_class_question) again and agian from itself (self - refrencing) …  |
The End.