<< < 1 2 3 4 5 6 7 8 9 10 11 > >>   Sort: Rank

What happened to SQL*Menu?
What happened to SQL*Menu? From Forms V4.5, SQL*Menu is fully integrated into Oracle Forms. Application menus can be added to your application by creating Menu Modules (*.MMB) and generate it to Menu Module Executables (*.MMX).
2011-04-26, 3640👍, 0💬

Why doesn't my messages show on the screen?
Why doesn't my messages show on the screen? Regardless of whether you call the MESSAGE() built-in with ACKNOWLEDGE, NO_ACKNOWLEDGE, or with no mode specification at all, your message may or may not be displayed. This is because messages are displayed asynchronously. To display messages immediately, ...
2011-04-19, 3523👍, 0💬

Can one change the mouse pointer in Forms?
Can one change the mouse pointer in Forms? The SET_APPLICATION_PROPERTY build-in in Oracle Forms allows one to change the mouse pointer. Example: SET_APPLICATION_PROPERTY(CURSO R_STYLE,BUSY); The following cursor styles are supported: * BUSY - Specifies a busy symbol * CROSSHAIR - Specifies a crossh...
2011-04-19, 6045👍, 0💬

Can one execute dynamic SQL from Forms?
Can one execute dynamic SQL from Forms? Yes, use the FORMS_DDL built-in or call the DBMS_SQL database package from Forms. Eg: FORMS_DDL('INSERT INTO X VALUES (' || col_list || ')'); Just note that FORMS_DDL will force an implicit COMMIT and may de-synchronize the Oracle Forms COMMIT mechanism.
2011-04-12, 5245👍, 0💬

Can one issue DDL statements from Forms?
Can one issue DDL statements from Forms? DDL (Data Definition Language) commands like CREATE, DROP and ALTER are not directly supported from Forms because your Forms are not suppose to manipulate the database structure. A statement like CREATE TABLE X (A DATE); will result in error: Encountered the ...
2011-04-05, 3993👍, 0💬

Can one bypass the Oracle login screen?
Can one bypass the Oracle login screen? The first thing that the user sees when using runform is the Oracle logon prompt asking them for their username, password, and database to connect to. You can bypass this screen or customise it by displaying your own logon screen. Eg: -- ON-LOGON Trigger decla...
2011-03-22, 4793👍, 0💬

What tools can do a 'diff' to discover the differences between 2 versions of an FMB file?
What tools can do a 'diff' to discover the differences between 2 versions of an FMB file? Use an Object List Report. File > Administration > Object List Report This generates a text file of the form. Compare these to find the difference easily. FORMS API Master -- This will help us to compare two Fm...
2011-03-15, 3262👍, 0💬

What is Oracle Forms and what is it used for?
What is Oracle Forms and what is it used for? Oracle Forms is a 4GL Rapid Application Development (RAD) environment. Forms Builder is used to create applications to enter, access, change, or delete data from Oracle (and other) databases. The Forms Runtime environment is required to execute compiled ...
2011-03-15, 4556👍, 0💬

Oracle PL/SQL Questions
1. What is normalization. 2. Difference between procedure and functions. 3. Oracle 9i Vs 10g. 4. how to improve the performance of a query. 5. %type vs %rowtype. 6. regression testing. 7. deleting the duplicate records without using rowid in oracle. 8. Row chaining. 9. types of cursors.
2008-11-05, 6039👍, 0💬

How To Turn On or Off Recycle Bin for the Session
How To Turn On or Off Recycle Bin for the Session? - Oracle DBA FAQ - Managing Oracle Database Tables If you want to control the recycle bin feature in your own session, you can use the ALTER SESSION statement to turn on or off. Here is an example SQL script: SQL> connect HR/fyicenter Connected. SQL...
2007-05-04, 4503👍, 0💬

How To List All Tables in Your Schema
How To List All Tables in Your Schema? - Oracle DBA FAQ - Managing Oracle Database Tables If you log in with your Oracle account, and you want to get a list of all tables in your schema, you can get it through the USER_TABLES view with a SELECT statement, as shown in the following SQL script: SQL> c...
2007-05-04, 4357👍, 0💬

How To View the Dropped Tables in Your Recycle Bin
How To View the Dropped Tables in Your Recycle Bin? - Oracle DBA FAQ - Managing Oracle Database Tables You can look what's in your recycle bin through the predefined view called RECYCLEBIN. You can use the SELECT statement to list the dropped tables as shown in the following script: SQL> connect HR/...
2007-05-04, 4401👍, 0💬

How To Empty Your Recycle Bin
How To Empty Your Recycle Bin? - Oracle DBA FAQ - Managing Oracle Database Tables If your recycle bin is full, or you just want to clean your recycle bin to get rid of all the dropped tables, you can empty it by using the PURGE statement in two formats: PURGE RECYCLEBIN - Removes all dropped tables ...
2007-05-04, 9510👍, 0💬

What Is an Oracle Data File
What Is an Oracle Data File? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files An Oracle data file is a big unit of physical storage in the OS file system. One or many Oracle data files are organized together to provide physical storage to a single Oracle tablespace.
2007-05-04, 4186👍, 0💬

What Is an Oracle Tablespace
What Is an Oracle Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files An Oracle tablespace is a big unit of logical storage in an Oracle database. It is managed and used by the Oracle server to store structures data objects, like tables and indexes.
2007-05-04, 4252👍, 0💬

How To Turn On or Off Recycle Bin for the Instance
How To Turn On or Off Recycle Bin for the Instance? - Oracle DBA FAQ - Managing Oracle Database Tables You can turn on or off the recycle bin feature for an instance in the instance parameter file with "recyclebin=on/off". You can also turn on or off the recycle bin feature on the running instance w...
2007-05-04, 4737👍, 0💬

What Is a Recycle Bin
What Is a Recycle Bin? - Oracle DBA FAQ - Managing Oracle Database Tables Recycle bin is a logical storage to hold the tables that have been dropped from the database, in case it was dropped in error. Tables in recycle bin can be recovered back into database by the Flashback Drop action. Oracle data...
2007-05-04, 4258👍, 0💬

How a Tablespace Is Related to Data Files
How a Tablespace Is Related to Data Files? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running.
2007-05-03, 4157👍, 0💬

How a Database Is Related to Tablespaces
How a Database Is Related to Tablespaces? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files A database's data is collectively stored in the datafiles that constitute each tablespace of the database. For example, the simplest Oracle database would have one tablespace and one datafile. Ano...
2007-05-03, 4186👍, 0💬

How To Recover a Dropped Table
How To Recover a Dropped Table? - Oracle DBA FAQ - Managing Oracle Database Tables If you accidentally dropped a table, can you recover it back? The answer is yes, if you have the recycle bin feature turned on. You can use the FLASHBACK TABLE ... TO BEFORE DROP statement to recover a dropped table f...
2007-05-03, 4284👍, 0💬

How To View All Columns in an Existing Table
How To View All Columns in an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables If you have an existing table and want to know how many columns are in the table and how they are defined, you can use the system view USER_TAB_COLUMNS as shown in the following tutorial exercise: SQL> C...
2007-05-03, 7047👍, 0💬

How To View the Tablespaces in the Current Database
How To View the Tablespaces in the Current Database? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you want to get a list of all tablespaces used in the current database instance, you can use the DBA_TABLESPACES view as shown in the following SQL script example: SQL> connect SYSTE...
2007-05-03, 4173👍, 0💬

What Are the Predefined Tablespaces in a Database
What Are the Predefined Tablespaces in a Database? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files When you create a new database, Oracle server will create 4 required tablespaces for the new database: SYSTEM Tablespace - Every Oracle database contains a tablespace named SYSTEM, which ...
2007-05-03, 4963👍, 0💬

How To Delete a Column in an Existing Table
How To Delete a Column in an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables If you have an existing column in a table and you need that column any more, you can delete it with ALTER TABLE ... DROP COLUMN statement. Here is an example SQL script: SQL> CREATE TABLE emp_dept_90 2 AS...
2007-05-03, 4345👍, 0💬

<< < 1 2 3 4 5 6 7 8 9 10 11 > >>   Sort: Rank