2,627 Topics
 | |
 | For these whom may be interested in new stuff about Java 7 here is web broadcast from few days back [URL="http://www.oracle.com/us/corporate/events/java7/index.html"]Java 7 Celebration Webcats[/URL] PS: Didn't watch it yet so have no idea if any good :D  |
| | |
| | Hi, I am trying to find out list of employees who have no dept_id. Below code works. [B]select e.emp_id, e.last_name, e.dept_id from employees E where dept_id IS NULL[/B] Below code does not work. i want to rewrite the query using NVL to replace the value by 0. does not work. … |
| | hey guys, i have a query wherein one table has the same id as the other using inner join.. SELECT c.cat_name, g.maxscore, g.description FROM grp_performance INNER JOIN category ON g.cat_id = c.cat_id Is it possible to use inner join when deleting a row? like.. DELETE FROM grp_performance INNER JOIN category … |
 | Imagine my surprise when I logged onto Daniweb and saw a scrolling advert for IBMs Informix database. I've been using Informix for years and it is an incredibly elegant bit of code, and the object extensions you can use are totally unique. I'd always thought of Informix as a secret …  |
| | Can anybody tell me the difference between a Primary key and a Unique Key ?Kindly let me know the idea.Any help would be highly appreciated. |
| | I have VS 2008 on Win 7 Professional 64bit system and database is Oracle 11g r2 installed on the same machine. In Data Source Configuration Wizard --> New Connection Data Source: Oracle Database (Oracle Client) When I click Test Connection after entering Service name, username, and password I get the … |
| | Is there an easy way to go through an entire directory recursively to find all CSV files? In python, there's os.walk and I see that Java has FileVisitor, but I have no idea how to use it correctly ([url]http://download.oracle.com/javase/tutorial/essential/io/walk.html[/url]). What I want to do is something like this (pseudocode): [CODE] … |
 | Can any one give a useful link to learn oracle report server and also how to connect it with java application.... Thank you.  |
| | Can any one give a useful link to learn oracle report server and also how to connect it with java application.... Thank you. Require second question answer.... |
| | |
| | I have an application in which user will put the query in text box and will get the output in gridview and i need to keep track that which user has run which query. for that i will be taking query from textbox and store in one variable I need … |
| | im creating a website that deals with the monthly reminders (extracted from Oracle) for my members for a school project. Should I create a login page using JSP or servlets? I am unfamiliar in both the languages. Will I need to establish my connection for each page if I use …  |
| | i just installed a oracle virtual box to enable virtual machines. i discovered through a software that computer does not allow hardware virtualisation and i need to install a windows server 2008 in d virtual partition. Please is there any way out?  |
| | hi i already have oracle virtual box installed on my system , i need to find out if i could install vsphere client on it , or i have to install vmware? Thanks |
 | Dear all, Can any one tell me how can i take bakup on Every minute and hourly and complete whole day backup using VB.NET i.e i want to know the coding example Thanks in advance |
| | Hi, Could you please let me know if we can install Oracle 11 g R2 on Ubuntu Desktop 11.04? If + , can you please introduce me a tutorial which I can follow that? Best Regards, |
| | Hi Guys, This looks a little bit silly question but I really have problem with unzipping the oracle Oracle Database 11g Release 2 downloaded files. I am trying to install oracle on my Windows Vista and according to the Oracle download webpage : [CODE]Directions 1. All files are in the … |
| | Hi, I have four tables tab1,tab2,tab3 & tab4 [CODE] #contents of tab1: Id dataname 222 perl [/CODE] [CODE] #contents of tab2: Id data_desc 222 perl is a scripting language [/CODE] [CODE] #contents of tab1: Id other_desc 222 Regular expression [/CODE] [CODE] #contents of tab1: Id date 222 22-33-1964 [/CODE] I … |
| | Hi, my name is robin das and we are currently running small question answer site. Can any one please tell me how much a technology question answer site with different technologies like asp.net. java, sap, sas, oracle can earn and what are the adverting option site can take. like which … |
| | Hi, I'm having a problem getting the auto generated ID immediately upon commit. I have an entityBean mapping like this: [CODE] @GeneratedValue(strategy=GenerationType.AUTO, generator="SEQ_SETTLEMENT_TRANS") @SequenceGenerator(sequenceName="SEQ_SETTLEMENT_TRANS", name="SEQ_SETTLEMENT_TRANS") @Id @Column(name="SET_TRANS_ID") private long setTransId; [/CODE] and I am trying to get the Id like this: [CODE]setEntityManager(PersistenceManager.getEntityManager()); getEntityManager().getTransaction().begin(); getEntityManager().persist(settlementTrans); getEntityManager().flush(); getEntityManager().getTransaction().commit(); System.out.println("ID :: "+settlementTrans.getSetTransId()); [/CODE] … |
| | I create a procedure to update table but when I execute to test the procedure with PRINT :g_name_pd show nothing as been change .. Can you guy's help where I m doing wrong Thanks Agaba[code]CREATE OR REPLACE PROCEDURE update_name_pd (p_name IN bb_product.productname%TYPE, p_id OUT bb_product.idproduct%TYPE ) IS BEGIN UPDATE bb_product … |
| | Hi, I want do pagination per page show only 25 records. Here is fetching data is too large and there I can't use rownum for that. in fetching data there is no any unique column. so tell me how can do it? Thnaks in advance. |
| | Question about Vista Home Premium SP2 ... I use Oracle VirtualBox, and saved VM snapshots are big (from 100's of MB to multiple GB at times). These are getting saved in both my username directory and in username.V2, and that's taking a lot of space. There's a lot of other … |
| | Hi, Im using Oracle 11g, and i have a query like select * from test where ID_PRIVILEGES = 'ADMIN'; but in database ID_PRIVILEGES is stored as Admin, I want case insensitive search to be done. I cannot change my query as select * from test where ID_PRIVILEGES = 'Admin'; Can … |
| | Can nay one tell me how can i set user permissions on form level to control user i.e i want to allow user1 only add permission and uer2 should have both add and edit permission how to do it on form level. Thanks in advance. |
| | I have an application which updates some files overnight from an oracle server. the application runs fine until at the very end when it closes. Then I get the message "Application has encountered a problem and needs to close. We are sorry for the inconvenience." when I click on the … |
| | I am getting data by view but there is too large data. so I want to select data in particular slab (i.e. 25 rec) but in my resulting data there is no any unique record in column for fetching. so please give me solution. selection records like rows 1 to … |
| | Hi This post is more for information purposes rather than help. I have just been tasked to investigate the upgrade for our applications to run on Windows 7. Oh, yes - easy one might say... Not!! We have a few applications running on a central Oracle server. To upgrade the … |
| | hi, can someone please give me any links for getting free Oracle notes online. I have tried to get but in vain. |
| | Hi, in oracle 10g express, I logged in system/HR. I typed: CREATE USER SHIPU IDENTIFIED BY SHIPU1. click Run. Then I typed, GRANT SELECT, INSERT, UPDATE ON EMPLOYEES TO SHIPU WITH GRANT OPTION click Run. I logged out and logged back in as SHIPU/SHIPU1 I typed SELECT * FROM EMPLOYEES. … |
| | I am trying to update a column of a view in a DB. It throws up an error saying the column i am trying to update is a virtual column. I want to know the SQL statement to find out the base tables of th view and also the base … |
| | Hi, Can anyone pls suggest me how to configure autoreconnect option in oracle 11g as in mysql. Thanks, |
| | 1. employees table- emp_id is the primary key 2. department table-dept_id is the primary key. 3. Create or replace View emp_dept AS select e.emp_id, e.last_name, d.dept_id From employees e, department d 4. update emp_dept set last_name = 'munir' where emp_id = 11 ORA-01779: cannot modify a column which maps to … |
| | |
 | I need urgent Help plz. scenario: Oracle Database and Client 10g are installed on same system. I want to connect my website with database ( i am new to oracle and ASP.Net) ORA-12514: TNS:listener does not currently know of service requested in connect descriptor My web.config file contains code [code] … |
| | I have an application which use SqlBulkCopy to copy data from csv to respective table in SQlserver which works fine but the same i have to do to dump to oracle which cant be done by sqlbulkcopy class Is there any similar way to dump into Oracle table |
| | OK I have a project due tonight at midnight and I know I should have posted sooner but it seemed like such simple things that I just knew I could do it on my own. I was wrong. I need your help. I have a program that essentially makes a … |
| | |
| | I am using oracle 9i database with VB.NET when i am trying to insert record in my PR_REC table it gives me error "ORA-01722 Invalid number" here is my insert statement and the structure of the table [CODE]com = New OleDbCommand("INSERT INTO PR_REC(pr_no,item1,price1,qty1,item2,price2,qty2,item3,price3,qty3,item4,price4,qty4,item5,price5,qty5,item6,price6,qty6,item7,price7,qty7,item8,price8,qty8,item9,price9,qty9,item10,price10,qty10,Pur_reason,pr_date,Status) VALUES ('" & Me.txtprno.Text.Trim & "','" & … |
| | Hi all, I have a problem in creating a matrix table using a PL SQL select query. The table should look like: [CODE] |---------------------------------------------------------| |--|-1-|-2-|-3-|-4-|-5-|-6-...-----------------------|100 | |---------------------------------------------------------| |A |A1 | A2| A3| A4| A5| A6|.........................|A100| |B |B1 | B2| B3| B4| B5| B6|.........................|B100| |.........................................................| |Z |Z1 | Z2| Z3| Z4|.................................|Z100| … |
| | I have a big problem and i'm not even sure if solution exists for my problem... So the problem is: I have a xsd file, and I need to create xslt which will create html table with 2 columns: the first column is <xs:documentation> for all elements names (4 example …  |
 | I have this file that contains an instance of some Machine object. When I compile the file I have, it says that the class uses a deprecated API, meaning the Machine object. I tried looking for it in [URL="http://download.oracle.com/javase/6/docs/api/"]this[/URL] link, but I find nothing. I was wondering if anyone who … |
| | Hi, I want to know , how to retrive the table name from multiple tables from a database which having the maximum number of rows.... As i am new to oracle can anybody help me as fast as possible... Thanks Ashish |
| | Hi to all, How can i connect VB.NET with oracle i am using following connecting string for connecting VB.NET with SQL Server [CODE]Public ConnectionString As String = "Data Source=%server%; Initial Catalog=Inventory; Integrated Security=SSPI; Trusted_Connection=True;"[/CODE] And Class for sql server [CODE]Imports System.Data.SqlClient[/CODE] What class should i use for oracle. |
| | Hello, I need help with a query. I need to find the Sum of Distance of T# 1 But there isn't Adelaide -> Melbourne So I'll have to take the value of Melbourne -> Adelaide which is 400 How can I handle this problem? I can do them in a … |
| | hi. Im connecting to a oracle network database using power builder 6.0, but I get the following error when I display the window containing the datawindow: [CODE]Predefined message "pfc_dwderror" not found. message arguments: 1)A database error has ocurred Database error code: 942 Database error code message: select error: SQLSTATE=S0002 [microsoft][ODBC … |
| | |
| | I am sure many have seen this problem before (yes, it is for a class ) I have started it and think its "close" But I am not sure about the relationships, any help would be greaty appreciated. Below is the problem disreagrd the attached word doc our regional Oracle … |
| | Hi All, I tried to install Oracle 11g in my local machine. Every step is successful. At final step during installation process at 98% it stopped and giving me an error attached below with name error1.bmp. When I click on Next its giving me an error. The screenshot of the … |
The End.