1,488 Topics
 | |
| | 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 … |
| | Can i insert data from mssqlserver to oracle using select statement |
 | 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 am new and i need to call from a push button (in forms builder ) a report that i had made it using report builder thanks in advance |
| | 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 … |
| | Hi all, I was trying to write a query to List all manager's names and how many employees they are managing. all the employees and managers in the same employees table and have a id number and and manager id number. can any body help with this? |
| | Hi, I want to get the count(*) from all tables under a schema. How to can do this using a loop? I'm a noob at PL/SQL. I'm unable to find how to use the loop variable in the select statement. Here is what I've tried so far: [CODE]spool $DD/get_oid_dump.log; SET … |
| | I am learning C/C++/oracle/Unix? I am thinking of developing some application on my own, but I have no Idea what else is required. If you take an example of C++.I have very basic knowledge of it(data types, oops concepts,vectors,file handling,exception handling etc) I am not an expert though. I have … |
| | Hi Guys, Can you please let me know if there is a sql command to list PK , Child and Parent of an identical table in oracle? Lets say I have a table called City , how can I get those information using SQL? Thanks |
| | An application called DBMS Copy is giving me an error every time I try to connect to an ODBC database. ERROR #1552 : ODBC, Connect Error -> [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Please help me. I already browsed the internet, there are … |
| | Hi Can you please let me know if I execute several sql query with one open connection? For example if I have a code like following: [CODE] using System; using System.Data; using Oracle.DataAccess.Client; class OracleCommandSample { static void Main() { string constr = "User Id=scott;Password=tiger;Data Source=oracle"; OracleConnection con = new … |
| | Hi every body, Can you please let me know how can I modify following SQL algorithm to Disable/Enable all constraints existing in an specific table? [CODE] alter table (table name) disable constraint (constraint name) [/CODE] For example if I have a table called "GIS_Data" how I can disable all constraints … |
| | Hi Guys I have to merge(insert)data from source database into target database(over 600 tables).The good thing is the both source and target tables have exactly same structure and constrains but I have to transfer only data that are not existing in target database/table.Right now I am using this code but … |
| | Hi All; I have developed a portal using Oracle Portal Application Server. I have to publish it to internet. What are steps involved in this? How the server should be managed? Regards Famous16 |
The End.