1,135 Topics
| |
Can any one give a useful link to learn oracle report server and also how to connect it with java application.... Thank you. | |
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 … | |
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 … | |
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. | |
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, 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 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| … | |
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 | |
| 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 … | |
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 … | |
| |
| Thanks so much guys! That solved my problem.. I have another question.. Find the names of all restaurants together with the names of diners who visit the restaurants on 24 April 2011. IF no diner visited a restaurant on the day, include a name of restaurant with no value in … |
Hi Guys, I'm not good in Oracle, I need a help in Oracle Developer Suit 10g, I got stuck at the beginning of this project & expecting a help from you all. I need to create a Wedding Event Planner & to design forms for that. Before designing that I've … | |
Hi, I need to know more about oracle database. 1)Introduction. 2)Importance. 3)Advantages and disadvantages. 4)Effects. 5)Diagrams. 6)Features. | |
| I have to: Find the distinct names of all diners who ordered 2 or more portion of the same foods on the same day in the same restaurant. [CODE] SQL> select * from foodorders order by diner; DINER RESTAURANT ODATE FOOD ------------------------------ ------------------------------ --------- ------------------- ALICE BEST FOOD 09-APR-11 BAKED … |
The End.