How to insert/delete/update data into VIEW using forms 6i
i have created a view like create or replace view emp_dept as select emp.empno,emp.ename,dept.deptno,dept.dname from emp,dept where emp.deptno=dept.deptno; how to insert/delete/update data into the view emp_dept using forms 6i ?
i have created a view like create or replace view emp_dept as select emp.empno,emp.ename,dept.deptno,dept.dname from emp,dept where emp.deptno=dept.deptno; how to insert/delete/update data into the view emp_dept using forms 6i ?
5 pts.
Commit during loader replace ?
Hi. I would like to know if sql*loader commits after it deletes the rows when executing loader option replace. Is it possible to make it commit only after everything is done, so that there is no second when the table is empty. Thanks for your help.
Hi. I would like to know if sql*loader commits after it deletes the rows when executing loader option replace. Is it possible to make it commit only after everything is done, so that there is no second when the table is empty. Thanks for your help.
Duplicate Sql
Hi, I want to know in a given PL/SQL Procedure or PL/SQL Function How to find the duplicate(i.e., Repeated) SQL Statements. regards, aditya.
Hi, I want to know in a given PL/SQL Procedure or PL/SQL Function How to find the duplicate(i.e., Repeated) SQL Statements. regards, aditya.
Using the BLOB datatype
IT HAS BEEN CLEARED THAT TO INSERT THE IMAGES INTO ORACLE DATABASE, A COLUMN WITH DATATYPE BLOB HAS TO BE CREATED IN THE TABLE, PLEASE TELL ME HOW TO INSERT AND RETRIEVE THE IMAGE INTO AND FROM THE DATABASE RESPECTIVELY. THANKS, SIMRAN.
IT HAS BEEN CLEARED THAT TO INSERT THE IMAGES INTO ORACLE DATABASE, A COLUMN WITH DATATYPE BLOB HAS TO BE CREATED IN THE TABLE, PLEASE TELL ME HOW TO INSERT AND RETRIEVE THE IMAGE INTO AND FROM THE DATABASE RESPECTIVELY. THANKS, SIMRAN.
Oracle coding error ORA-06550
Hi, I get the following error on compiling my code - *********************************************************** ORA-06550: line 16, column 1: PLS-00103: Encountered the symbol "ELSE" when expecting one of the following: begin case declare end exit for goto if loop mod null pragma raise...
Hi, I get the following error on compiling my code - *********************************************************** ORA-06550: line 16, column 1: PLS-00103: Encountered the symbol "ELSE" when expecting one of the following: begin case declare end exit for goto if loop mod null pragma raise...
Syntex for storing combobox & redio button in oracle using VB.NET
How can i save combo box value & redio button in database using VB.NET form. For example as text value we write TEXTBOX1.TEXT????
How can i save combo box value & redio button in database using VB.NET form. For example as text value we write TEXTBOX1.TEXT????
How to create a trigger for updating a table for a quantity decrease?
How do you create a trigger to take care of the process of updating a table, to reflect a change downward in the quantity column? 1. The trigger needs to be an AFTER INSERT trigger on the above table so the trigger will not fire in case of exceptions. 2. The trigger must fire for each row that...
How do you create a trigger to take care of the process of updating a table, to reflect a change downward in the quantity column? 1. The trigger needs to be an AFTER INSERT trigger on the above table so the trigger will not fire in case of exceptions. 2. The trigger must fire for each row that...
how to access fields of table along with their datatypes in oracle
Dear Oracle gurus I am using oracle 9I. i want to access fields of table along with their datatypes at runtime.. to see structure of table 'desc' command i used.. but at runtime how i can know datatypes or fields of a table. Thanks in advance Shailesh
Dear Oracle gurus I am using oracle 9I. i want to access fields of table along with their datatypes at runtime.. to see structure of table 'desc' command i used.. but at runtime how i can know datatypes or fields of a table. Thanks in advance Shailesh
Update deactiviting and throwing ora-600 error
ORA-00600: internal error code, arguments: [25012], [5], [524], [], [], [], [], [] Current SQL statement for this session: UPDATE "JEST" SET "INACT" = :A0 , "CHGNR" = :A1 WHERE "MANDT" = :A2 AND "OBJNR" = :A3 AND "STAT" = :A4
ORA-00600: internal error code, arguments: [25012], [5], [524], [], [], [], [], [] Current SQL statement for this session: UPDATE "JEST" SET "INACT" = :A0 , "CHGNR" = :A1 WHERE "MANDT" = :A2 AND "OBJNR" = :A3 AND "STAT" = :A4
Nested SQL with multiple table join does not work with wildcard searches
Dear sir(s): Currently I am working with iBatis with Oracle 10g as the backend. I have a number of jsps or Web pages which take various input parameters in the format of #xxxxxxxx# where xxxxxxxx represents the dataitem from the Javascript. In my sqlmap, there is a complex join involving...
Dear sir(s): Currently I am working with iBatis with Oracle 10g as the backend. I have a number of jsps or Web pages which take various input parameters in the format of #xxxxxxxx# where xxxxxxxx represents the dataitem from the Javascript. In my sqlmap, there is a complex join involving...
How to exclude certain hours and certain days in a date range in oracle sql
hello, This is the table schema that i have: CREATE TABLE TEST ( COL1 NUMBER NOT NULL, START_TIME DATE NOT NULL, DURATION NUMBER, COL2 NUMBER, CONSTRAINT PK_TEST PRIMARY KEY ( COL1, START_TIME ) This is the query i have to select all the rows within a time range: SELECT ...
hello, This is the table schema that i have: CREATE TABLE TEST ( COL1 NUMBER NOT NULL, START_TIME DATE NOT NULL, DURATION NUMBER, COL2 NUMBER, CONSTRAINT PK_TEST PRIMARY KEY ( COL1, START_TIME ) This is the query i have to select all the rows within a time range: SELECT ...
connecting to oracle database and push the data into the mail client Inbox
we have java application,that inbox data will be stored in oracle database,i want get handle of oracle database and push the newly created document in to the mail client inbox of domino
we have java application,that inbox data will be stored in oracle database,i want get handle of oracle database and push the newly created document in to the mail client inbox of domino
date functions using Oracle
Hi, I need to display the benefits paid for the current year using SQl,but the year is filtered using the year which is previous year for the current year.the date is in 'yyyymm' format. ex, select year_mnth,benefits_paid from tablename where year_mnth in ('200603','200602','200601') note:it is...
Hi, I need to display the benefits paid for the current year using SQl,but the year is filtered using the year which is previous year for the current year.the date is in 'yyyymm' format. ex, select year_mnth,benefits_paid from tablename where year_mnth in ('200603','200602','200601') note:it is...
Oracle Installation on Portable Media
Hello Friends, I am working on Oracle 9i (Rel - 2). I am thinking of developing an application in which I can install Oracle on a portable media (Eg. Portable Hard Disk) and create a databse on the same. First of all, I want to know whether it is possible to install the Oracle on a portable...
Hello Friends, I am working on Oracle 9i (Rel - 2). I am thinking of developing an application in which I can install Oracle on a portable media (Eg. Portable Hard Disk) and create a databse on the same. First of all, I want to know whether it is possible to install the Oracle on a portable...
SQL (Oracle) Date Constraints
Can someone tell me how to create a constraint to prevent entering a date prior to 1 Jan 2007? I am tryin g to do it in a create script. Thanks Lock
Can someone tell me how to create a constraint to prevent entering a date prior to 1 Jan 2007? I am tryin g to do it in a create script. Thanks Lock
automatic go next field without enter keyboard key oracle form 6i
hi , i facing problem with oracle 6i form ,what is the code for automatic go next field without enter keyboard key (not build in like go_item(xxx) or next_item) my code is working only when ENTER key pressed but i don't want press key, i using form for get external data from other database it...
hi , i facing problem with oracle 6i form ,what is the code for automatic go next field without enter keyboard key (not build in like go_item(xxx) or next_item) my code is working only when ENTER key pressed but i don't want press key, i using form for get external data from other database it...
LEFT JOIN vs. LEFT OUTER JOIN
I've been googling for 2 hours trying to find if there is a difference between LEFT JOIN and LEFT OUTER JOIN, and of course I didn't find anything. Is there a difference? Is the word 'outer' optional, since a left join is an outer join by default? If this is the case, I don't understand the usage...
I've been googling for 2 hours trying to find if there is a difference between LEFT JOIN and LEFT OUTER JOIN, and of course I didn't find anything. Is there a difference? Is the word 'outer' optional, since a left join is an outer join by default? If this is the case, I don't understand the usage...
Using SELECT statements
Can we get the number of saturdays in any month using a SELECT statement(i.e without creating a table or function)? If so, can you give me the logic?
Can we get the number of saturdays in any month using a SELECT statement(i.e without creating a table or function)? If so, can you give me the logic?
