[oracle] Forum Topics

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 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 …

contiunally getting ORA-00907: missing right parenthesis error when trying to insert data in my star scheme using the code: INSERT INTO account_dim (account_id, account_name) SELECT (acc_seq.nextval, lds_account.acc_name) FROM lds_account; INSERT INTO account_dim (account_id, acount_name) SELECT (acc_seq.nextval, mch_account.acc_name) FROM mch_account; Can anyone make any suggestions?

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 …

Following is my code effort.... I want to read first line of file(comma separated) & then create table in JavaDB but stuck here... Please someone help me how to do next???? public class DatabaseDAO { public void FileRead(String st) throws ClassNotFoundException, SQLException, IOException{ String []tokens=null; try{ try (FileReader fr = …

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

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 …

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> …

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 …

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, …

list details of the departments in which the average salary of the employees is the lowest .

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 …

 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 …

how can I select project from dropdown then execute query catching the value of the project selected I have the follow code using AJAX and JSP pages admin.jsp <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page import="java.sql.*"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; …

'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 …

Hello All, I have a table with column_name as USERNAME where USERNAME is VARCHAR2(20) and I want to display it as **"[email protected]"**. How to write the select query for this. **QUERY**: SELECT USERNAME AS EMAIL FROM STUDENT Thank you.

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 …

Hi What is my misstake? I got error whwn I run my code! DECLARE V_num number := ‘&enter_an_integer’; V_test number; Begin V_test := mod(V_num,2); If V_test = 0 then Dbms_output.put_line(’even number’) Else Dbms_output.put_line(‘odd numbers’); End if; End; The error was 06550. 00000 - "line %s, column %s:\n%s" *Cause: Usually a …

can any one help to find out how to create a oracle app using oracle express edition 10g

Group, I'm extracting some month and year values from dates. I need to ensure they are NUMBERS as I'm going to multiply, add and subtract. I'm assuming I need to DECLARE these as NUMBERs. However I'm not sure how to do this correctly as I'm getting errors preventing me to …

Group, I'm using TOAD to query the Oracle database. My better expertise is in VB.net. I have very little SQL experience. My question: Can I create a variable in TOAD/SQL to prompt for a date(s)? Here is what I want to do: Question 1: Enter Beginning Date (user to enter …

Hi group! I'll be up front and say I'm very new to SQL. I'm just now getting my feet under me in my new job. So I have lots of questions. I'll start simple (I hope). I've created my own tables (2) that have multiple columns of data that looks …

i does not know about store the image in database. what is the datatype of picture in oracle?

I installed Eclipse and it worked for few days and it nolonger openned giving error:- can someone help me ([email protected]) Java was started but returned exit code=13 C:\ProgramData\Oracle\Java\javapath\javaw.exe -Dosgi.requiredJavaVersion=1.6 -Xms40m -Xmsx512m -jar C:\Program Files\eclipse-java-luna-SR2-win32-x86_64\eclipse\\plugins/org.eclipse.equinox.la uncher_1.3.0.v20140415-2008.jar -os win 32 -ws win32 -arch x86_64 -showsplash C:\Program Files\eclipse-java-luna-SR2-win32-x86\\plugins\org.eclipse.platform_4 .4.2v20150204-1700\splsh.bmp -launcher C:\Program Files\eclipse-java-luna-SR2-win32-x86_64\eclipse\eclipse.exe -name …

HI, Am new to PL\SQL. I just want to fetch the 4 fields from employee table. how to do it? employee_ID, First_name, Last_name, total number of employees from employee table. i tried to fetch using count() function. but it is not giving the total number of employees. can anyone please …

Hi, I would like to hear from professionals on this forum who happen to be either technical or functional consultants for a variety of vendors who deal with CRM/ERP such as SAP, Dynamics AX (MS), Oracle, Sage etc. 1. What exactly is the difference between functional and technical consulting? 2. …

I currently wish to write a query to duplicate data in database while modifying one column. First of all, my database structure: table code CURCD NOT NULL VARCHAR2(3) CODE NOT NULL VARCHAR2(2) ITEM NUMBER(1) DSCPT VARCHAR2(20) The unique idx is the curcd,code,item. What I wish to achieve is duplicate data …

Hello All, I have two schema called mater and transaction. In master one table called - BCC_TM_CITY In transaction one procedure called PR_GETCITIES. In this procedure table BCC_TM_CITY used like this select * from mater.BCC_TM_CITY; my problem is, recently I dropped the table and added again in master. After that, …

Eh... I lost recently laptop to Windows, Microsoft made me cost about 700$, and that all in just 2 weeks. And even though I start hating it, I cannot deny the fact that many applications and certain games I rely on are runable only on Windows. Graphics card aren't really …