SQL statement exceeding 2000 characters in Oracle Graphics Builder
In Developer 6i Graphics Builder, i am not able to write query exceeding 2000 character. i think it is restriction in this version. If I want to write query exceeding 2000 then please suggest me what to do.

Answer Question   |  December 10, 2008  10:27 AM
Oracle Developer 6i, Oracle Developer 6i Graphics Builder, Oracle Developer Suite, Oracle development, SQL, SQL statements

How to perform Unique check in PL/SQL
Hi Experts, I need to perform a Unique check on existing record in table X for combination of field in my PL/SQL block before inserting new record into Table XX Table XX for combination of the following field list (X_ID, St1, St2, City, CP, PS, XNAME, C_ID) AND DISPLAY MODE = 0 How can i [...]

Answer Question   |  December 10, 2008  9:05 AM
Oracle development, Oracle SQL, PL/SQL, PL/SQL block, PL/SQL Unique Constraints, Procedural Language/Structured Query Language

How to make or check the attribute (location) in PL/SQL block?
Hi Experts, How to make check the attribute (location) not taking the value same as city(attribute) or country(attribute) in Pl/SQL block Thanks for the help

Answer Question   |  December 16, 2008  7:49 AM
Oracle development, Oracle SQL, PL/SQL, PL/SQL attributes, PL/SQL block, PL/SQL Table, Procedural Language/Structured Query Language

Bulk Collect vs Cursor in Oracle
Hi, I have to process some records in some work table. The no. of records in work table may vary from 100,000 to 4,000,000. To process records in this work table i have to loop through it 1 by 1. So please tell me which is the better option out of these two: 1. Create [...]

Answer Question   |  April 18, 2013  3:38 PM
BULK COLLECT statement, Collection Loop, Cursor Loop, LOOP statement, Oracle Cursors, Oracle development, Oracle queries

Error(7,30): PLS-00103: Encountered the symbol “OUT” when expecting one of the following
I am getting this eror when i compile my procedure with OUT Parameter ,it has got several OUT param ,but only this particular line pops up err msg Error(7,30): PLS-00103: Encountered the symbol “OUT” when expecting one of the following: := . ) , @ % default character The symbol “,” was substituted for “OUT” [...]

Answer Question   |  February 1, 2011  5:16 AM
Oracle development, Oracle SQL, PL/SQL, PL/SQL error messages, PLS-00103

Error(31,19): PLS-00103: Encountered the symbol “INTO” when expecting one of the following
I got this error while compiling a select stm and it s my pckg body however package parameter hav OUT as well IN .. Error(31,19): PLS-00103: Encountered the symbol “INTO” when expecting one of the following: . ( , % from The symbol “from was inserted before “INTO” to continue. Anbody able to help me [...]

Answer Question   |  February 6, 2012  5:12 AM
Oracle development, Oracle SQL, PL/SQL, PL/SQL error messages, PLS-00103

SQL select
SELECT obj.object_type FROM apps.opt_log_issue log, discov.opt_changed_database_objects obj WHERE –(UPPER(log.resolution(+)) like ‘%’||obj.object_name||’%’ – and trunc(log.resolution_date(+)) – trunc(to_date(substr(obj.last_ddl_time,1,11),’dd-mon-yy’)) <=5 – and trunc(log.resolution_date(+)) – trunc(to_date(substr(obj.last_ddl_time,1,11),’dd-mon-yy’)) >=0) OR (UPPER(log.resolution(+)) like ‘%’||obj.object_name||’%’ and log.resolution_date(+) is null) /

Answer Question   |  December 1, 2008  11:09 PM
Oracle development, Oracle SQL, SELECT statement, SQL Query, SQL statements, WHERE statement

Oracle Forms
how to show oracle form at run time full screen

Answer Question   |  February 24, 2012  5:24 AM
Oracle Developer Suite, Oracle development, Oracle Forms, RunTime

FND_RESP_FUNCTIONS
Is there an API or a script I could use to make massive inserts into FND_RESP_FUNCTIONS?

Answer Question   |  November 7, 2008  11:23 PM
Database API, Database programming, FND_RESP_FUNCTIONS, Oracle development

Searching using Oracle Forms
Hi to all.I am tauqeer.I am using oracle 10g forms developer I want to search some data in the tabular form style in the form based on a query on a text item.I want when i press enter button which is under that text item the data will be displayed in the tabular saction.the text [...]

Answer Question   |  February 20, 2009  4:01 AM
Oracle 10g, Oracle development, Oracle Forms

Develop Oracle application by 4GL
I am a good developer in 4gl under Informix under platform UNIX. I want to transfer to Oracle 10g under Windows 2003 Server. Would you please give me tools to write my own 4gl program in using Oracle database under Windows.

Answer Question   |  November 9, 2012  9:29 AM
Oracle 10g, Oracle Database, Oracle development

IN PL/SQL how to declare and use ‘STATIC DATA TYPE like C’
Hi All, Can anybody help me to declare a variable having the similar propery of ‘STATIC DATA TYPE IN C’. Means declare a variable and initialize it inside the procedure and called the procedure recursively but each time it is initializing the variable. I want any mechanism in PL/SQL that will make the variable like [...]

Answer Question   |  July 24, 2009  10:47 AM
Oracle Application Server, Oracle database replication software, Oracle developers, Oracle development, PL/SQL

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 ?

Answer Question   |  September 23, 2008  1:16 PM
Forms 6i, Oracle development, Oracle Forms

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.

Answer Question   |  September 9, 2008  9:50 AM
Oracle development, SQL*Loader

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.

Answer Question   |  September 2, 2008  3:40 AM
Oracle development, Oracle PL/SQL, SQL

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.

Answer Question   |  August 25, 2008  5:01 AM
BLOB, Oracle development

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 return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << [...]

Answer Question   |  July 18, 2008  2:59 PM
ORA-06550, Oracle development, Oracle error messages

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????

Answer Question   |  July 18, 2008  11:52 AM
ComboBox, Oracle database design, Oracle development, VB.NET

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 [...]

Answer Question   |  July 16, 2008  3:48 PM
Oracle development, Triggers

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

Answer Question   |  July 1, 2008  10:09 AM
Developer 2000, Oracle 9i, Oracle Developer 2000, Oracle development