2,627 Topics
 | |
| | Please explain to me what execution plans and index creation is in Oracle SQL. An example would be great also. Thank you!!  |
| | I'm getting this (errorORA-00936: missing expression) when I input this into the sql commands: select || 'The promotion began on the' || to_char(start_date,'ddth')' of 'to_char(start_date,'Month YYYY') from f_promotional_menus where code=110; I tried googling for answers but came up with nothing. Can someone help me figure out what I am doing …  |
| | 1. Crystal Reports SAP Crystal Reports is known as a robust production reporting tool. With SAP Crystal Reports, you can create powerful, richly formatted, dynamic reports from virtually any data source, delivered in dozens of formats, in up to 24 languages. SAP Crystal Reports turns almost any data source into … |
| | Hello All, I am fairly new to Vb.net. I have experience in MS Access and VBA. I am trying to connect a remote Oracle Database through vb.net but getting the below error. But, the same Oracle database connecting with the help of SQL Developer. Can any one please help me? … |
| | I'm running xp pro with outlook express version 6. When I receive emails in the inbox and choose to delete them they just stay there. I can shift delete but just delete does nothing. When I right click and go delete that also doesn't work. Can you please assist. Thanks.  |
| | I need to transform between two different database schema the same data. For example i have one table in old schema looking like this: OLD EMPLOYEE TABLE USER_ID - NUMBER (PRIMARY KEY) FIRST_NAME - VARCHAR(50), (NOT NULL) LAST_NAME - VARCHAR(50), (NOT NULL) CITY - VARCHAR(50), (NOT NULL) and i need …  |
| | I wan to call oracle database function I tried this but i am getting error `ORA-06550: line 1, column 7: PLS-00221: 'F_GET_DESC' is not a procedure or is undefined ORA-06550: line 1, column 7: PL/SQL: Statement ignored` public void Get_Desc() { string oradb = "Data Source=source;User Id=myuser;Password=ss;"; string CommandStr = …  |
| | hi..... i am searching for the query for retrieving the deleted data from the table.From the web i got "flashback" method to get the dropped table.Any one has any idea pls,help me thanks in advance |
| | I'm working on shopping mobile application. The application is similar to ebay it have customer and seller. When user create account they can either create account as seller or customer. The payment will be by paypal each user need to provide their paypal account (Seller Paypal & customer PayPal) so … |
| | I have tried to display the names of table in oracle database in visual studio 2012 in combo box but i am not sure why it is not displaying private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { try { con.Open(); OleDbDataAdapter oda = new OleDbDataAdapter("SELECT table_name FROM tabs where table_name Like … |
| | I am using digital persona fingerprint reader which is U.are.U 5100, c# programming language and oracle database. The problem i faces was it was stated FMD created successfully during enrollment, but this only will be saved temporarily. Can i know what solution will be suggested to the code in order … |
| | Hi, I'm writing code to connect to Oracle through ODP so I added a reference to the Oracle.DataAccess dll on my machine. Trouble is I'm writing a 64 bit app and I appear to have both x86 and 64 bit versions of this dll on my machine. No matter which …  |
| | <select id="keyEquipmentShiftAutomatedModelData" parameterType="java.util.Map" resultType="java.util.Map"> SELECT ID, SUM(VALUE1 + VALUE2) Total FROM tableName GROUP BY ID </select> Returns below result in sql ID, Total 1 (null) But when returned in Map result in myBatis returns {ID=1} where as Total is missing. How to get the column with null into the result … |
| | Aslam o alikum, I create a report in Crystal report 9 with add command using Oracle 11g as Database with OLE DB (ADO) (Microsoft OLE DB provider for Oracle). It works fine in crystal report. I want to call this report from vb6 form. I m not using any server … |
| | I am trying to create a registration form in Bootstrap and then connecting it to the Oracle Database but the data entered by the user isn't sending any value to the database. Please suggest what editing I should do. <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta … |
| | Hi guys, I am trying to add a new component to my window by clicking on a clickable jLabel. Better said, with mousevent. Unfortunately, it does not work, at least for what i tried with. Can you help me here? My code: package test_1; import java.awt.BorderLayout; import java.awt.Color; import java.awt.Cursor; …  |
 | HI guys, as mentioned in my revious post, I'll redo my wordCount application using the GridBagLayout approach. The functionality of the application hasn't changed at all: I've only removed the various Jpanels and, for simplicity, used only the JFrame and attached all the comonents to the JFrame. I've had a … |
| | Hi, Can you guys reccomend me some good oracle sql journals? Thanks |
| | Hello, What are the different areas of databases I can focus on for my project? Thanks, |
| | Hi all, If I have two table of cod-desc, T1 and T2, and I need to create all possible combination, other than using cartesian product, is there another way more optimal to do that? Suppose every table has 1M rows. RDBMS= Oracle 11G. Thanks sandro |
| | Help me :) I want to display the text file in JTextArea but how ? and i want to attach this is searching button.  |
 | Hi. In August I built a PC using a second hand Biostar TA990FXE "Extreme Edition" motherboard and AMD FX-6100 six core CPU @3.3 GHz at the core of it. I recently installed the Oracle Virtualbox VM on Windows 10 and tried running a couple of Linux and BSD OS instances, … |
| | FROM: ORACLE 9i Give the SQL statements that determine the following: 1. Which customers lives in New Jersey? SELECT * customer FROM customers WHERE state = 'NJ' 2.Which orders were shipped after April 1, 2003 SELECT * FROM orders WHERE shipdate to_date('01/04/2003', DD/MM/YYYY') 3. Which books are not in Fitness … |
 | i have this problem about the betting system of my game. Here's the scenario: Your money: 300 Your bet: 300 JOptionPane appears: "you have insufficient money to bet" Here's the code for the main program: /* * To change this license header, choose License Headers in Project Properties. * To … |
 | Hi I have written a procedure in PL/SQL to get values from user and then I am updating the same in a table. This worked fine 1st time but its just not showing the new values inserted by the user. The field which should be updated with the user value … |
| | Hi! Just want to ask if it's possible that within a select statement, there has a loop. Have this sample query but when I run this it says missing expression after <column2> Select <column1>, <column2>, FOR Lcntr IN 1..12 LOOP CASE WHEN Lcntr THEN .... END END LOOP; FROM <table> … |
| | /* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package my.GeographyQuiz; import java.awt.*; import javax.swing.*; /** * * @author K00190164 */ public class GeograpgyQuiz extends javax.swing.JFrame { …  |
| | I need some help with creating a simple search engine for website. Basic idea is that user will enter a string in search bar, which will compare in database key_word and get the reuslts. Lets say I have the following table on sql server database. |----|----------|----------------------| | ID | URL …  |
| | I am using CodeIgnitor and oracle db at model function add_new_emp_test( $x, $y) { $conn=$this->db->conn_id; // Execute the call to the stored procedure $stmt = "BEGIN emp_pkg.add_account(:x1,:y1); END;"; $lob = oci_new_descriptor($conn, OCI_D_LOB); $lob = oci_new_descriptor($conn, OCI_D_LOB); $stid = oci_parse($conn, $stmt); oci_bind_by_name($stid, ':x1', $x, 100); oci_bind_by_name($stid, ':y1', $lob, -1, OCI_B_BLOB); $lob->writeTemporary(base64_encode($y)); … |
| | hi all, I m developing a software in vb6 as front end and oracle 11g as backend (i.e. as database) I have desinged some reports with oracle reports builder, how i can call in vb6 program/how to add the oracle reports in vb6 programe. Thanks in advance for help. |
 | We have a WCF web service hosted on Windows 2008 SP2/IIS 7 accessing an Oracle database. Usually data access works fine but during load testing, it often times out and logs an exception saying: Error occurred when processing XXXXXXXX Web Service Oracle.DataAccess.Client.OracleException Connection request timed out at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection … |
| | I'm doing a quiz game using netbeans. I've already done the randomization of questions. The problem is, how do i keep a question from repeating itself? ex: chose correct answer --> questionrandomizer comes in --> next question appears but it's the same question earlier here's my code: package kiddiequiz.scienceforms; import …  |
| | Hi, i have form in my jsp , which when submitted ,calls javascript which will inturn submit the form , this is working fine in IE. but when i submit from chrome , i get below error. -version:2.5]] Servlet failed with IOException weblogic.utils.NestedRuntimeException: Cannot parse POST parameters of request: '/integration/r5/wfsworklist/WFTaskUpdate' … |
| | **I'm using netbeans btw if you notice the long code for the GUI** I'm doing a quiz game. The questions are randomized. My problem is, the randomized questions do not appear on the questionLabel (JLabel Variable). I don't know what to do. Help? /* * To change this license header, … |
| | |
| | I have a oracle query and i would like to run it by powershell using ODP.Net. Below is the query. set pagesize 100 set linesize 200 break on report compute sum of free_mb on report compute sum of act_size on report compute sum of used_mb on report col %used format … |
| | I got a requirement. i have a tabular form with some records, for example i have a department table in a tabular form, if i check first record that means department 10 and then if i click any button we need to show the list of employees whose department is … |
 | Hello to all! I made a small project using Netbeans8. I named my project smallCalcApp. And then i add a new JFrame File in my project and in that file I handled events of components which i put on form. When I run that file , it ran successfully and … |
| |  Im wondering to solve the given task but ended up in nothing.. Can someone help me on this !? Do click here for the image file for the elobarted question . [Click Here](https://onedrive.live.com/redir?resid=70CCAC35D1F2DEFA!693&authkey=!AOy2XqxgwvxJ8yM&v=3&ithint=photo%2cpng) |
| | Okay so let me start by saying I have a pretty decent c++ base and very advanced logic skills. So whatever help you will have to provide will probably be minimal. So here's my problem: I've been trying to figure out the best way to organize all my Magic: The … |
| | im make program using vb6 n tried to get data from msaccess database ,display it in vb6 and save the data to oracle table database.. The table name in oracle is testcoba. Now i can save the data from vb6 to oracle table. But i want is the data will …  |
| | Hi guys. I am looking for a software tools that can analyse data from several sources like databases: Oracle,Mysql,Access,MsSql e.t.c and draw graphs,dashboards or other data visualisation objects. The software should also be able to read excel sheet and analyse the data and give output in variuos graphs/pie charts. It … |
 | 'database connection class file '------------------------------------------------------- Imports Oracle.DataAccess.Client Imports System.Data Public Class DataBaseConnection Private con As New OracleConnection ReadOnly Property connection() As OracleConnection Get Return con End Get End Property Sub New() con.ConnectionString = System.Configuration.ConfigurationManager.AppSettings("DBconnection") con.Open() End Sub Sub closeConnection() con.Close() con.Dispose() End Sub End Class '////////////////////////////////////// 'staff class file '-------------------------------------- …  |
| | Hi, I am new in pl/sql programming and I need your help. I would like to make a procedure. To be more specific, I have tables like the folowing TABLE1 ================================================ |COL1 | COL2 | COL3 | COL4 | COL5 | COL6 |COL7| =============================================== |600 | 140 | 2 | … |
| | Hello, I am `Inserting` the data into table1 where c1 is new column and data is from table2. but c2 data type is `varchar2` and c1 datatype is `Number format`. ` INSERT INTO table1 (to_number(USER_ID)) SELECT EMP_ID FROM table2 WHERE USER_NAME IN (SELECT UNAME FROM table1); ` Here `USER_NAME` column …  |
| | Can anyone help me out ?....... I have written a code for a form. the first five fileds in the form must be filled automatically by capturing the user id from login page. I have been able to capture the data and print it on the screen But, Iam not …  |
 | Hi I got this error ORA-01403 "no data found" and ORA-06512: at line 8 however I'm sure that there is date in my table dept!!! Declare v_deptid dept.deptid%type; v_deptname dept.deptname%type; v_location dept.location%type; v_employeeid dept.employeeid%type; begin select deptid, deptname, location, employeeid into v_deptid, v_deptname, v_location, v_employeeid from dept where deptname = … |
 | Hi group, I'm getting an "single-row subquery returns more than one row" error when running my routine. Looking through the table I'm querying, it is listing a date twice for some reason. Since I'm not able to remove this one row, is there a way to return the first instance … |
| | Hi Why I got error ? CREATE TABLE customer_table( KNR INTEGER(10) FN VARCHAR2(10) NOT NULL, EN VARCHAR2(10) NOT NULL, Mobil NUMBER(10) NOT NULL, Tell INTEGER(10) NOT NULL, constraint knr_pk primary key(KNR) ); Error report - 00907. 00000 - "missing right parenthesis" *Cause: *Action: |
| | Hello All, I want to know how to sort ascending or descending varchar values. This is my field and values Filling_s_no varchar2; Table: Id Filling_s_no name 1 1.1.1 X 1 1.1.10 X 1 1.1.5 X 1 1.1.2 X 1 1.2.1 X 1 1.2.0 X Now I want to sort my …  |
The End.