1,135 Topics
| |
In Oracle its showing ClusterId for every table and View.Can anyone tell how to set ClusterID's.Thanks in Advance. | |
Hi friends I have written my first code using dynamic SQL which is as follows [code=sql]CREATE OR REPLACE PROCEDURE Insrt_Chld_Dtl AS CURSOR_ID INTEGER; V_FORMAT_ID NUMBER(20):=1; COL_NM VARCHAR2(50); VLS VARCHAR2(50); V_COL_NO VARCHAR2(20); SEARCH_STRING VARCHAR2(20); --ID VARCHAR2(100); PRNT_VL VARCHAR2(100); COL_CNT INTEGER; V_SQL VARCHAR2(200); CURSOR FETCH_MST_DTLS(V_FORMAT_ID VARCHAR2,V_COL VARCHAR2) IS SELECT WHETHER_COMBO, ABV, DESCRIPTION, … | |
hi, this is saif from pakistan. i have get a project to make a database on library management system.could u tell me that how many entities i can add in this data base.if u know pls reply me wid the names and how. thank u. | |
Im trying to run a query like this: Display the names of pairs of customers who have booked the same room together with the details of the location and room. I did try like this: [CODE]select cust_name, room_name, cost_per_day, capacity, loc_name, avenue_site.address from customer, aroom, booking, avenue_site WHERE aroom.room# = … | |
I am a 3rd year student.this is my minor project.i have to make a project using vb as front end & oracle as back end.In this i have to design a form in vb which contains company information.The companies which are coming in campus for selecting students have some criteria.these … | |
PARTITION ROTATION PROBLEM CASE - Once a day application pupulates table which is used during the day. Next day the data are purged and replaced with the fresh set of rows. The table is relitevly big - about 1GB of data. Application does truncate the table and repopulates it anew. … | |
Good Morning all, I need some help with loading a file into a sybase IQ table with the "LOAD INTO" statement. I have never used it before and I cant seem to get myhead around how I am supposed to implement it in my java app. I have a stateless … | |
I'm looking forwards to attend such course: [url=http://unex.uci.edu/certificates/it/oracle_db/courses.asp]http://unex.uci.edu/certificates/it/oracle_db/courses.asp[/url].. look at the dates and time. Its quite intensive, my question: will i have a chance to write notes, because obviously i can remember all what i'm going to learn in one class, there must be my reference to review. Otherwise, it … | |
I am trying to use this syntax to no avail: [code=sql]SELECT C_Name, ORDERS.O_ID, SUM(ITEM_ORDERED.QUANTITY*PRODUCT.P_PRICE) AS TOTAL_PRICE FROM CUSTOMER, ORDERS, ITEM_ORDERED, PRODUCT WHERE CUSTOMER.C_ID=ORDERS.C_ID AND ORDERS.O_ID=ITEM_ORDERED.O_ID AND ITEM_ORDERED.P_ID=PRODUCT.P_ID GROUP BY ORDERS.O_ID;[/code] My 4 tables would look like this: [U]customer[/U] [U]order[/U] [U]item_ordered[/U] [U]Product[/U] PK C_ID PK O_ID PK,FK O_ID PK P_ID C_Name … | |
Please how can I write a query to select list of building its building code and number of rooms in each building. | |
SQL QUERY [code]if ($_SERVER ['REQUEST_METHOD'] == 'POST') { if ($_POST['mylist1'] == 'm2') { $sql="SELECT Products, TABLE 1"; $rs=odbc_exec($conn,$sql); odbc_result_all($rs); echo 'With this package you can registar for any of our domains'; } elseif ($_POST['mylist'] == 'm3') { $sql="SELECT Products, Table2"; $rs=odbc_exec($conn,$sql); odbc_result_all($rs); echo 'With this package you can registar for … | |
Hi I entered http:\\mandar\isqlplus on the address bar but I,m getting Invalid syntax error. mandar is my computer name. Pls help me out Is there any way to solve this error | |
Hi I'd like to know if is possible update a record when load a table. The update must be over a record with a primary key. For example: I have a record with: id|date_begin|date_end|data 2|02/03/2009|NULL|0 and I want that line to be update when a record like 2|02/03/2009|10/03/2009|56,7 comes. Is … | |
I have written my simple query using update and in a file with a .sql extension. However, I cant seem to update my table and yet at the end of the input it shows me 1 row updated I would also want to know how I can do 2 updates … | |
Hello everybody My problem is that I'm quite new in oracle admin/dev so I need some help pointing me how to limit the number of days of data stored in a table. I have some datasources that come in files periodically. I'd like to limit the days stored for each … | |
hello all.. im a newbie..in both complex database design and oracle pl/sql ,and im very unsure/confused about the structure of my tables and how to normalize some info. ok so heres the situation. i have a company,employees are distributed according to dept and section and category.each category has number of … | |
Hello, I am somewhat of a SQL newbie. My question is how would I go about creating a query that searched for things like: 1. users who have collected a complete set of promo items 2. users who have purchased every movie from actor X 3. users who have purchased … | |
hi, what is the diffrence between delete and truncate command in sql. plz send me tutorials of oracle also. waiting for your reply. <URL SNIPPED> | |
I want to find duplicate names from my database I wrote the following query. But it is displaying more that existing records. I guess it is taking cartesian product. select a.name from emp from emp a,emp b where a.name=b.name; can anyone correct this query. I want to display all the … | |
hi i am looking for a jiob as a junior Oracle DBA can any one please advice me on how to get an Oracle DBA job. i have beeen looking for where to startup my career but everywhere i go to they are asking for 3 or more years real-time … | |
Hello everyone I need a solution for my problem. The solution can be a simple PL/SQL block or a trigger I have a table called T_SBSTTN_VLTG_MSTR with following data SBSTTN_CD VLTG STTS DT_ENTRY FK_TM_ID 10111111 11 Existing 2/9/2009 19:32 10144 10111111 33 Existing 2/9/2009 19:32 10144 10111111 132 Existing 2/9/2009 … | |
Hi, Could someone please tell me how to get all the tables in one program/file so that i can run them as one. Please very important..thank you | |
I want to write an sql statement in c# where I want to pass a "true" or "false" value basing on some condition... can we pass true to sql statements Ex: [CODE]select * from emp where (empid=1234 and true); select * from emp where (empid=1234 and false); [/CODE] This true … | |
I am new to Oracle and SQL. I need to write a select statement for a student extract at a college. For ex: select ss_id from id_table This will return all id's from this table and they are a length of 9 digits, i need to return just the last … | |
I have two tables, say t1 and t2. t1{ txn_id varchar status varchar } t2{ txn_id varchar date Date } I want to built an update query which will update t1.status='X' with join condition t1.txn_id = t2.txn_id and t2.date < sysdate. Please let me to build an update query. | |
i ve 1 table named 'A',it contains many attributes in 1 attribute the values are stored like this [COLOR="Red"]"Q108:5380;Q208:5380"[/COLOR] this data present in table 'A' should be entered in table named 'B' in two fields named B1,B2 as B1 B2 Q108 5380 Q208 5380 like this in two columns this … | |
I am doing the following report. Write a report for a large bank on the benefits that cloud computing can bring to their database system (Oracle). Could anyone tell me I can find informaion to help me do this report? | |
Hi Guys I have designed reports in Discoverer Plus and the users are viewing the report using viewer. My need is that suppose there is a report which is made. Now if some user views the report by changing the layout and save the changes. Now problem is the change … | |
hello! How can I display if the query results more than one value? For example, how can I do a query that produces all pairs of salespeople who are living in the same city. Thanks in advance. | |
Hi folks, I want to access Oracle 9i table "emp" in Java... I do not know what driver to use .. The name of the Oracle database under which "emp" falls is "Oracledb" I do not know what the connection string is? Pls help... |
The End.