1,135 Topics
 | |
| | Hi, Where is the mistake? It doesn't work. thanks [CODE] CREATE OR REPLACE TRIGGER A_ACCOUNT_EKLEME BEFORE INSERT ON A_SIPARIS CURSOR CURSOR_TARIH IS SELECT TARIH FROM A_ACCOUNT where TARIH = SYSDATE; FOR EACH ROW BEGIN IF CURSOR_TARIH%NOTFOUND THEN INSERT INTO A_ACCOUNT (TARIH, PRICE) VALUES (SYSDATE, '1'); END IF; END; [/CODE] |
| | When I'm attempting to tnsping my database from the server it is stored on, I keep getting error code 3509, however I can ping my database from clients. I've checked naming in tnsnames.ora and all is as it should be. Any ideas??? |
 | Hi Guys... i'm not so good at oracle, sql and related stuff.. but i do need to write some simple query's from time to time and i do need to understand that which all tables get updated by a particular transaction. I can do that by going through the code, … |
| | Hi friends, i got this err while executing this procedure. err is like this:- ----------------------------------------------------------------------------- 9/3 PL/SQL: Statement ignored 9/13 PLS-00201: identifier 'DATEADD' must be declared 11/3 PL/SQL: Statement ignored 11/13 PLS-00201: identifier 'DATEADD' must be declared ------------------------------------------------------------------------------ Please have look my stored procedure CREATE OR REPLACE PROCEDURE GReptExprtCompliTestRelt(EntityFolderCode number, … |
| | Hi, I can not use below code in stored proc in oracle; [code] IF (SYSDATE = '04-MAY-08') THEN ... END IF; [/code] This doesn't work either way (true or false). Is there any other way to check it? thanks |
| | Hi, I need a trigger; - to find number 1 from "ID" column and - update "AVAILABILITY" column from Yes to No in "PRODUCT" table. Thanks |
| | 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. |
| | 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... :) |
| | 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 … |
| | 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.