1,487 Topics
 | |
| | Can anyone suggest me how to create web pages using PlSql?? |
| | below is my oracle procedure [code] DECLARE TYPE r_cursor IS REF CURSOR; c_emp r_cursor; er PLAN_T%ROWTYPE; BEGIN OPEN c_emp FOR SELECT * FROM PLAN_T WHERE ROWNUM < 5; LOOP FETCH c_emp INTO er; EXIT WHEN c_emp%NOTFOUND; dbms_output.put_line(er.OBJ_ID || ' - ' || er.NAME); END LOOP; CLOSE c_emp; END; [/code] it … |
| | Hi All, Assist me on how to insert and retrieve images to an oracle database with ordimage data type. Any help will be highly appreciated. |
| | I have DB Oracle table User include : ID,USERID,MONEY,TIME . I was select a record (The time : 4/11/2009 5:52:55 PM ) [icode]select time from user where user ='John' and money>300 [/icode]. Now i have value : time = rscon("time") Now i want calculate number day from now to the …  |
| | In Oracle its showing ClusterId for every table and View.Can anyone tell how to set ClusterID's.Thanks in Advance.  |
| | I need to know how to access two tables which has some reference values within the table.I need the Java Code to Fetch Both the tables values which are same and have to display it  |
| | 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, … |
| | Hello, i have to export a column in vb.net to Oracle database. only one table. How to start? |
| | Hello, I am trying to run my tables in the Sql Workshop using the Sql Commands option in Oracle, and I get this error - "ORA-00922: missing or invalid option". I read that this is somehow related to the NOT NULL option, but I think this is how my table … |
| | 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 …  |
| | I am using VB6 and Oracle in my project.When I open an .exe one session gets created. If the application is doing some insert or Update to my Datatbase then, I want a Session to be created and after completing that transaction(DML Statement) ,I want that sesssion to be destroyed … |
| | 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. … |
| | Can any body mail me the codes with snapshots for connectivity between oracle and CMP(EJB 3.0) . Can anybody suggest me the book for Java Enterprise Edition 5 with examples using Netbeans 6.1 or later. Mail me at <EMAIL SNIPPED> |
| | Hi Alls, I'm try to send value from textbox in vb.net to other textbox in oracleform....how to do yaaa?....or the best way i using cursor location to put in the data?...can anyone help me plzz.. |
 | 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 |
| | Heya, Not sure this is the best place to post but can't see a better forum :P Not 100% sure I've done this right so looking for some clarification. Thankies Steph -------------------------------------------------------------------------------- CreateTables.SQL [code] DROP TABLE student; DROP SEQUENCE student_counter; CREATE SEQUENCE student_counter INCREMENT BY 1 START WITH 1 NOMAXVALUE … |
| | 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 … |
The End.