Search results for query: *

BJCooperIT, There are no triggers at Block-Level When i navigates out of dept_mas(table) block and comes to dept det block at runtime. It flashes the message "Do You want to save records" If u are not able to understand that what i am saying then in a form which has some records then...

SantaMufasa, This was just an example But Pls tell me how to do it in a single form with 3 tables Thanks

Hi, I was working in oracle-8i In my all forms on all List Of values field i Have written a hint "PRESS F9 FOR HELP" in Text-Item Property-Pallete Now i have started Working in Oracle-9i Now can I change my hint on all fields to "Press CTRL+L FOR HELP" by not changing in...

Hi, I have Three tables 1) create table emp( emp_id varchar2(6) constraint pk_emp_id primary key, emp_name varchar2(40)); 2) create table dept_mst( emp_id varchar2(6), dept_code varchar2(40) constraint pk_dept_code primary key, constraint fk_dept_mst_Emp foreign key(emp_id) references...

HI, I WANT TO MAKE A ZIP FILE OF A FOLDER FROM FORM AT RUNTIME Example FOLDER FOR WHICH BACKUP TO TAKE-'C:\LOGIWWW' NAME OF ZIP FILE -'LOGIWWW_0104' STORE ZIP FILE IN PATH -'C:\LOGI_BKP' I HAVE WRITTEN THIS ON TRIGGER (WHEN-BUTTON-PRESSED-TRIGGER) DECLARE DRP VARCHAR2(300); BEGIN...

HI. I want to run a winzip wizard through oracle forms and also want to make a zip file of any directory This all work i want to get it done through forms at Runtime I have tried to do this by HOST command HOST(WINZIP32); But it doesn't open a wizard of winzip Pls. tell me how could i do...

Actually I didn't have enough idea about it But i Just know that now my table is in invalid or ORA-12986 my columns are in partially dropped state and when i query from branch table then system ask me to write a command "alter table branch drop columns continue;" i have done this...

thanks Kocheace it works I Will vote for u

Try also FORMS_DDL COMMAND AS IT ISSUES AN IMPLICIT COMMIT EG. FORMS_DDL('CREATE USER A IDENTIFIED BY A'); FORMS_DDL('GRANT CONNECT,RESOURCE TO A');

Hi I Have issued a command to database through sqlplus command is Alter table branch drop(&column_name) checkpoint 10; There are atleast 20 columns are in this script This commmand is running for more than a day and it has also lock the branch table.I am not able to view the records from the...

Hi How can i import the data from oracle tables to microsoft access tables Both have them same table structures Which utility can be used to sort out my problem and pls. also give a example of doing that thanks in advance Wish u a Merry Christmas "Have a nice time"

Thanks for ur reply.it seems to be working but when i try to insert a row in sqlplus it only stores number(7,2) but in microsoft access it stores full value but doesn't show decimal in between instead it shows comma in access datasheet eg 1234567893,34 could u tell me why it show like this...

Yes, u are right and i want to create a table in sqlplus by connecting Ms access database so pls tell me how to do this and which datatype will store number(14,2) field like we do in oracle eg 123456789234.23 i have tried float,double,number but they only store number(7,2) pls. answer me as...

HI i am new to microsoft access so kindly bear with me I have create a ODBC CONNECTION named "TEST" TO MICROSOFT ACCESS WITH ORACLE now i have opened sqlplus connect A/A@ODBC:TEST I HAVE WRITTEN A CREATE TABLE STATEMENT CREATE TABLE NN( NAME CHAR(30), AUTO_NO NUMBER(10,2))...

hi. can a oracle report background engine get hide or can we change it to traffic lights or spinning wheel thanks in advance

HI what are datatypes we can use in microsoft access for character,date,time,numeric and pls. do tell their syntax eg create table aa( name char(30), e_date date, amt number(10,2)); showing a error invalid create table statement thanks in advance

Hi. can a script be runned in microsoft access just as we do in oracle sql eg. sqlplus connect system/manager @c:\all\alter.sql This alter.sql has three tables creation script I want to do same in Microsoft Acess Thanks in advance.

Hi. can a script be runned in microsoft access just as we do in oracle sql eg. sqlplus connect system/manager @c:\all\alter.sql This alter.sql has three tables creation script I want to do same in Microsoft Acess Thanks in advance.

could u pls explain by a small example

TO LEWISP THANKS A LOT U ROCKS.