1,488 Topics
 | |
| | Please, could anyone tell me if there is tutorial for this issue? or give me instructions. I have search all day and found nothing. |
| | Hi, 1- When i insert more than 30 datas (at once) into a table, does sequence cache size(20) effect anything because, i use sequence for auto increment in the table. 2-What happens if i increase the cache size from 20 to 50? thanks |
| | Hi Experts! I am professionally working in Oracle Developer 6i and database oracle 10g. but now i want to learn JDeveloper. I have no tutor available in my area. will you give me some tutorials or URL of tutorials... regards Khalid Mehmood |
| | Hi I installed oracle 9i on my system. I am working with sql plus browser. my doubt is how to open iSQL *plus browser. I tried my level best to find out but no use. please any tell me how to open iSQL *plus. Thanks |
| | Hi everyone. Sorry if this question is in the wrong area..I posted it on the VB forum and they advised me to post here also. I have created a visual basic system that is connected to an oracle database. (I connected through data>Add New Data source>New Connection>Oracle Database etc etc) …  |
| | Hi Experts I am trying to develop a web application using Pl/Sql as scripting language. but i cant understand where to start and what i should implement the configuration for this purpose. |
| | I have a program that has a connection to an Oracle database and is supposed to execute an Insert statement. It runs with no problem until the [I]connection.Execute SQLString[/I] command. This causes a crash. The code compiles error free, and I've checked the syntax of the Insert statement and it …  |
| | Hi. I have created a visual basic system that is connected to an oracle database. (I connected through data>Add New Data source>New Connection>Oracle Database etc etc) I am using the system to create new oracle users with passwords etc. I have a form called frmAdd and text boxes txtUser and … |
| | Hi, When i insert data into any table last number of sequnce get increased in all sequences that are listed below. These are for auto incremented numbers. All tables have their own autoincremented coloumns. Can anyone see mistake? Thanks [code] CREATE SEQUENCE FRANC_AUTOINC_SEQ START WITH 1 INCREMENT BY 1 NOMAXVALUE; … |
| | Hi, Here is my mysql sentence: [CODE]select last_insert_id() from pp;[/CODE] and the table pp is created by: [CODE]create table pp(id int not null auto_increment primary key,name varchar(255) not null);[/CODE] Now I'd like to change the above into sentences that are right in Oracle. First I create table: [CODE]create table pp(id …  |
| | Hi, I have just downloaded 10g express edition but there is no user interface like SQL Server has. Does anyone prefer any program because i am new for Oracle and have never used before. Thanks |
| | Hi, Below trigger increments double(2,4,6,8...) not single. I want single. Where is mistake? If you can not help, is there other way to do auto increment? Thanks [code] CREATE TABLE MY_TEST ( IDNUM NUMBER, NAME VARCHAR2(4000) ) ; create sequence test_seq start with 1 increment by 1 nomaxvalue; create trigger … |
| | Hey all, Ok first my problem. I have a database that has an employee table and then also an absent table(for when they are off sick). The problem i have is using sql to find the employee that is off the most! So for my sql on the absent table … |
| | Hi, Could you pls explain me the confusing, diffterece between the views "USER_ " , "ALL_" and "DBA_". On which table query should be executed to get all the list of views like user_constraints, user_sons_constraints, user_source,user_sequences etc. Regards Pointers. |
| | Hi dudes, I desperately like to know the best way for learning Oracle including all accessories with regard to that I am fully familiar with database designing and Mssql into the bargain. Show all ways like all materials,tutorials and so on. All the best!!! |
| | from last thread, I figured it out my tables relationship and they do work i believe. however, i can't successfully get elements from each of the table out. if i do: select b_customer_name, h_customer_firstname, h_customer_lastname, telephone from customers c, business_customers b, home_customers h where c.customer_id = b.b_customer_id and c.customer_id = … |
| | I have to create a trigger having the following database. I'm confused in using the trigger type(row-level,st-type). Please help me out. Consider the relation schema of the COMPANY database given below EMPLOYEE (fname, minit, lname, ssn, birthdate, address, sex, salary, superssn, dno) KEY: ssn DEPARTMENT (dname, dnumber, mgrssn, mgrstartdate)KEY: dnumber. …  |
| | Hi, I have some tables (below), but I'm having trouble entering multiple lines of data. Here are the tables I have created. [QUOTE][B][U]CUSTOMER table[/U][/B] SQL> create table customer 2 (customer_no char(6) not null, 3 name varchar2(30) not null, 4 address varchar2(50) not null, 5 credit_limit number(6,2), 6 constraint customer_customer_no_pk primary … |
 | Hello, I have created a synonym. But later I have dropped the base table which is referenced by this synonym. I thought that the synonym would be dropped automatically. But later I found it exists in all_synonyms and doesnt exist in user_objects dictionary. When i quried the date from this … |
| | I have written the following code to try and run a report that will list customers names and ytd charter costs whose ytd charter cost are greater than the average charter cost for all customers. There are 4 table involved: customer: PK cus_code, cus_fname, cus_lname|| charter: pk char_trip, char_date, cus_code,char_distance,ac_number|| … |
| | I am still pretty new to writing SQL statements and I have mostly used MS Access up until now. My question is I am trying to write a single query based on the sample table below to determine how many orders were all parts orders, how many were all accessories … |
| | can anyone tell if it is the right way to connect these tables? What is the query display customerid, b_customer_id, and h_customer_id... thxxx --customers [code=sql]drop table Customers cascade constraint; create table Customers( Customer_id Number(5) primary key not null, Credit varchar2(20), Street varchar2(20), City varchar2(12), State varchar2(2), Zip varchar2(5), Telephone varchar2(14));[/code] … |
| | Is there any one can explain to me what is the difference between when_validate_item trigger and post_change trigger? In what kind of situation I need to use those triggers? I really feel very confused about it...It makes me stuck in my database assignment... btw, thanks for ur help... :) |
| | Hi, I am developing one website in which i have around 21 table in my database out of which 8 are master tables and rest are secondry tables. I want the data stored in some columns of master table to be displayed as drop down menu in my secondry table. … |
| | Select order_num, order_date, customer_name, description From orders,part,customer Union Select order_num, order_date, customer_name, description From orders,part,customer Where customer_name = 'Johnson's Department Store' or description = 'Gas Range'; I'm getting this error and from my understanding it looks like it should be fine: SQL command not properly ended |
| | I write programs using VB as the front end with Ms Access as the back end( database), and i will love to switch my back end to oracle ( so i think of starting from 9i).Please does anyone have the note or documentation I can read on my own in … |
| | Hi, I am using oracle 9i. I've got hard time rying to rename columns or constraint definition. I use the following for renaming a column: [code] ALTER TABLE table_name RENAME COLUMN old_col_name TO new_col_name; [/code] but I get this error [inlinecode]ORA-14155: missing PARTITION or SUBPARTITION keyword [/inlinecode]. The same thing … |
| | I have using asp.net and oracle (oracle provider) but within some time oracle sessions are full. so it gives error. have any body work on asp.net and oracle. how to handle oracle sessions. Regards. Thanks in advance... ashok salve.  |
| | I am trying to determine a way to create a timeout for a connection attempt to remote Oracle databases. If the connection isn't created in X seconds or less, regardless of the reason, I need to stop the connection attempt and report a message. Below is the relevant bit of … |
| | Hi everyone, I have a third-party application which uses DSN (in this case, only system and user DSNs) to setup database connections. I created a connection using the "Microsoft ODBC for Oracle" driver, but everytime my application needs to access the DB, I'm asked for password. I cannot change the … |
The End.