Hi, Is there a way in Oracle APEX to use a list of values or select list but do not force the user to select an item and allow them to enter different items? The basic functionality which I require is similar to a combo box where you can optionally select an item from the list or enter a completely new. Thanks Mark ...
hi i want to install oracle 11g on a very weak computer for learning. what is the most lightweight oracle version ? is it the express edition ? thanks in advance ...
I want to build a utility that can import data from excel sheet(columns are fixed but sheets can be any number) to oracle db. Can you suggest how should I: Read excel sheets(n number)?(Best way) Validate data? Bulk insert into DB? My concern is performance here. Each sheet can have 200,000+ rows. PS - please remember I am a complet...
I have a little DB, for academic purpose only, and I have object tables at most. I've created a entity-relationship model (ERM) in Power Designer and the program, by default, creates index for the serial id's for each table. I want to know how do I use a index like that on a query.Say I would want to find a product by its id, but using...
I have created sequence in database like, CREATE SEQUENCE seq INCREMENT BY 1; How can i assign the current value of seq in $t; <?php $t=?; ?> ...
I would like to export data from a Oracle table into *.dbf file (like excel) through PL/SQL scripts. Are there any codes available? ...
Hi there, I have this big code where I want 3 things in my search: 1- look for all the orders (delivered and not) that match the search: 2- look for all the pendent orders that match the search; 3- look for all the delivered orders that match the search; create or replace function search_order(search IN VARCHAR2, a_option NUMBER) R...
i'm trying to create a trigger that sets the id from a predefined sequence. CREATE SEQUENCE seq_list_status START WITH 1 INCREMENT BY 1 ; CREATE OR REPLACE TRIGGER trg_list_status_insert BEFORE INSERT ON list_status FOR EACH ROW select seq_list_status.nextval into :new.id from dual; / i'm getting the error...
Oracle seems to have a reputation for being more scalable than other RDBMSes. After working with it a bit, I can say that it's more complex than other RDBMSes, but I haven't really seen anything that makes it more scalable than other RDBMSes. But then again, I haven't really worked on it in a whole lot of depth. What features does Ora...
I've tried to do that. HasManyToMany<YechidotDoarInGroup>(x => x.Col_yig) .Table("PigToYig") .ChildKeyColumn("YIG_GROUP_RECID") .ParentKeyColumn("PIG_GROUP_RECID"); but I've got ORA-00942: table or view does not exist I am trying to establish HasManyToMany conn...
How can I return from float/decimal value with the following: SELECT 210 FROM DUAL ...to get: 210.00 ...instead of 210? Using pl/sql oracle 10g ...
I need to select rows where a field begins with one of several different prefixes: select * from table where field like 'ab%' or field like 'cd%' or field like "ef%" or... What is the best way to do this using SQL in Oracle or SQL Server? I'm looking for something like the following statements (which are incorrect): select ...
I have a table which represents a line-by-line dump of the data read from a particular text file format. Each line may represent a "master" or a "detail" line, indicated via rec_type code. I'd like to write a query that gets the "master" lines alongside the associated detail lines. I've come up with something that does the job, but it se...
I have a table for orders and it has 2 column with DATE types: delivery_date and order_date. In my sqldeveloper, all the dates I've inserted via Java or by hand are in the format 10.01.25 for the 25th Jan of this year. When I try to see the the total_price for orders between one date and another, I force the format like this: create...
I have a huge table to work with . I want to check if there are some records whose parent_id equals my passing value . currently what I implement this is by using "select count(*) from mytable where parent_id = :id"; if the result > 0 , means the they do exist. Because this is a very huge table , and I don't care what's the exactly num...
I am using Weblogic Server em console to restart a webserver, URL looks like this: http://localhost:7001/em/ AdminServer is named 'AdminServer', I wish to restart this server instance, I click on server in EM console then user menu option like this: (Weblogic server>Control>Shut Down...) I get this error: 'No Machine associated with ...
I need to create a table every morning based on overnight generated data from a massive table. This will then be accessed by a handful of users form Excel. My initial approach was to use a materilazed view and when this was rejected (for political reasons) to used Managed XLL but this was rejected for other reasons. I don't want to get ...
Hi,I want to import excel data to oracle DB. I got enough help for Excel part, can you guys help me in Oracle side? Is it possible to import to oracledb with filehelpers? Please provide some sample code for reference. Thanks Dee ...
I had a strange problem in one of our production databases. Long story short, simple query: select id, trunc(stdate) from table_name where trunc(stdate) = '05-FEB-09'; returned no rows. However, select trunc(stdate) from table_name where id = sought_after_id; returned '05-FEB-09'. Only after I tried: update table_name set stdate...
For our database development we have on one hand a full schema DDL script, for scratch installs, and on the other a set of sequential "delta" scripts, for upgrades (each script is recorded as executed or not in a special database table). To test this we have an ant target that install an older version, upgrades it and compares the schem...