How to add a new column to specified position in a existing table.I have using the oracle database 10g.This below code is not working in oracle 10 g
example:
ALTER TABLE EMPLOYEE ADD DEPT NUMBER FIRST:
ALTER TABLE EMPLOYEE ADD DEPT NUMBER AFTER JOB:
Say, a table has existing columns of A, B, D, and E.Now I want to add a new column C. But I want this column appear between B and D. I found that the newly added column always goes to the end of the table, i.e., A, B, D, E, C, instead of, A, B, C, D, E.
View 6 Replies View RelatedTo branch & scroll to a specific position within a page (upon initial page load), is using a named anchor still the recommended/modern way to do this or is there some jQuery plugin goodness that does a better job?
View 2 Replies View Relatedhave a column cstomer_ts from table customer, which contain records like:
"cstomer account"||"PRIVATE"||"foundation"
"cstomer account"||"PRIVATE"||"foundation of money"
"cstomer account"||"PRIVATE"||"Moneycost"now i want to fetch the third record from the column cstomer_ts which starts with 'Foundation'
i mean i want to fetch only 3rd postion frm the column cstomer_ts and tht should starts with 'Foundation'
I'd like to know if it is possible to track DML actions issued on a specific table by a specific user, for example , i tried :
AUDIT SELECT on SCOTT.DEPT by HR by ACCESS;
I get an error, where is my syntax error ?
i want to know if it's possible to do it without trigger ?
In details table i am having loc is column in which data is like this(Jones,180),(US,host name),(job, company),(id,0122)
output should be it should take only first value from ().
I want my query to return the rows of the table where a column contains a specific values first in a certain order, and then return the rest of the rows alphabetized.
For Example:
Country
ALBANIA
ARGENTINA
AUSTRALIA
....
CANADA
....
USA
....
Now i want USA and CANADA on top in that order and then other in alphabetized order.
There are four columns as follows, but I need to delete those rows from the third column only where the second letter of the word appears as vowel. For example, I want to delete the rows having the words, 'Ramu' and 'Ravi' only.
A B C D
xx y Ramu xx
yu ut Ameer uui
rtt iw Ravi iwoow
fgsg isd Intel jjuiw
i have IR report page and download column as blob,how can security applied in specific column wise?e.g. Report page have more rows, and applied query in condition.
Select ID,dbms_lob.getlength(Blob_file) Download from Document_master
where Created_by=UPPER(:APP_USER)
OR
(exists (select '' from apex_workspace_group_users awgu
where awgu.user_name =:app_user AND awgu.GROUP_NAME='EMPLOYEE_GROUP'
)
)
Now all the rows with Download column to see EMPLOYEE_GROUP users,but i need control the download column only except Created_by=UPPER(:APP_USER) ,this case how can do the security.
I have a database which consists of various orders and various field.
I have a variable called createddatetime . I want that whenever i should run the database it should display records from
Yesterday 06:00:00 am to Current Date 05:59:59 am
Now to implement this i tried to put this syntax
and to_char(Createddatetime,'dd/mm/yyyy HH24:mi:ss') between 'sysdate-1 06:00:00' and 'sysdate 05:59:59'
But nothing comes up
where as definitely there are records between times because when i do and Createddatetime between sysdate-1 and sysdate I see valid records coming up.
I have included a calender control in my form and its working fine.Now, my problem is how can I automatically place the calender next to the text-item (for example, "block.invdate")if the push button is pressed to call a calender.
View 1 Replies View RelatedSQLserver in stop condition when i play it. it again stop
View 1 Replies View Relatedsuppose i have a file named chk.txt and I have write 10 line in that file and i just want to write some text at line 5 or line first then how we can do this ?
View 3 Replies View RelatedI have to convert string 1234567 as 123,456,7 .
note 1234567 is a string.
I am having a table with content_id and content_data , content_data is of XMLTYPE
Content_data field in table is like below
<Content id="123234354" version="3">
<Definition>
<Code>ABC</Code>
[Code].....
i want to find in how many rows <Title> tag is after <XYZ> tag in the content_data field of the table?
I want to get current mouse cursor position dynamically,what should i do.
View 3 Replies View Relatedi am trying to adjust the position of a button as below but i realized it gets a bit uneasy as i thought ,
style="position: absolute; left: 100px; top: 100px; "
I am working on Oracle apps. I have developed a custom screen. On the screen, if the user press 'F4' on final step, it will ask the dialogue..Do You want to save changes?
Yes No Cancel.
Even the user press the "Yes" , I want to check my own validation and commit when my validation get perfect.
I am using Oracle developer Suite 10g, and i want to customize the position of ALERT message on the screen as per requirement.
View 4 Replies View RelatedI need to copy some text value in to a multi-line text item on the current cursor position.
View 8 Replies View RelatedHow the people in production counts the exact position of the data in fixed format of Sql*loader? Isn't it critical especially in a critical and having many column to be inserted.
View 6 Replies View Relatedwhat name is used to reverence the mouse cursor in Forms. I am trying to state that if the user reaches the last record in a file and clicks the mouse on the empty record below that they will get a message saying they are at the last record (basically so it means they have to manually click an add record button before they can add a new record)
I currently have this:
IF :SYSTEM.LAST_RECORD = 'TRUE'
THEN
<something here> := :SYSTEM.LAST_RECORD;
MESSAGE('You are at the last record.');
ELSE
DOWN;
END IF;
Where i have <something here> is where i assume the refence for the mouse cursor should go, of which i dont know the name, am i correct?
Another thing is that I have a checkbox that is originally NO but when set to YES cannot be turned back to NO.
I have accomplished this by putting the following code in the WHEN_CHECKBOX_CHANGED trigger and it works fine. However it also updates the checkbox to NO and then back to YES, , as a result this brings up my Are you sure you want to update message. I originally thought that if i took out the :in_active := 'Y'; the FORM_TRIGGER_FAILURE would stop the checkbox being changed in the first place but this didnt appear to be the case. how to accomplish this without letting it update at all (perhaps put something in the WHEN_VALIDATE trigger?
DECLARE
return_alert number;
BEGIN
if :in_active = 'N' THEN
return_alert := SHOW_ALERT('checkbox_alert');
:in_active := 'Y';
RAISE FORM_TRIGGER_FAILURE;
END if;
END;
i have one project about school system.there is one column of total marks.and other one is position column.i want a trigger that system genrate the position against total marks. problem is this when total marks become equal for example 101 and 101 than position also same.but dont now what a trigger i write for this.here some example
if total marks 100 than position is 1stand if total marks 99 than position is 2ndbut third person is also same number in total marks column i mean 99 than in position column must write the 2nd
I would like to Center Align application login page(Syslogin) oracle froms 11gr2. The below code is not working in forms 11g2, it's working in Forms 6i
PROCEDURE CenterWindow (win_name VARCHAR2) IS
w_mdi NUMBER;
h_mdi NUMBER;
w_win NUMBER;
h_win NUMBER;
[code]...
I want to insert only specific number of columns into a table by using Bulk collect and Forall.
SQL> create or replace procedure bifa_proc
2 is
3 type etab is table of emp%rowtype index by binary_integer;
4 erec etab;
5 cursor c is select * from emp;
6 begin
7 open c;
[code]...
Warning: Procedure created with compilation errors.
PLS-00382: expression is of wrong type
PLS-00436: implementation restriction: cannot reference fields of
BULK In-BIND table of records
How to insert specific number of columns without declaring multiple table type definitions for each column by using bulk collect and forall.
Can we do a specfic word count in sql. Requirement is there is a string "I am very very poor in sql" the word "very" occurs two times, so the result should be 2.
View 16 Replies View RelatedI have a requirement with source table has duplicates so i need to select a row based upon the below condition.
Source table
EMP_NO ENAME SALARY CODE EMP_ID
1 TOM 1000 1 10
1 JOHN 2000 A 20
1 SAM 3000 A 30
2 TOM 500 1 40
2 SUNG 1500 1 50
Desired Output
EMP_NO ENAME SALARY CODE EMP_ID
1 TOM 1000 1 10
2 SUNG 1500 1 50
I tried with MAX and DENSE_RANK but its not getting me the first row.
I am using oracle11g. I want to truncate subpartition on specific partion.
I have partition on statewise. Each state partion has 7 day sub partition.
For intance,
Partion TX
Sub partition MON, TUE, WED, THU, FRI, SAT, SUN
Partion CA
Sub partition MON, TUE, WED, THU, FRI, SAT, SUN
Partion IA
Sub partition MON, TUE, WED, THU, FRI, SAT, SUN
Now i want to perform following tasks.
1. Need to truncate TUE sub partiion on TX partition.
2. Need to truncate WED sub partiion on CA partition.
3. Need to truncate SUN sub partiion on IA partition.
How do we do this?
The below statment truncate all TUE partition on all the partitions.
ALTER TABLE TRX_TABLE
TRUNCATE SUBPARTITION TUE;
How do i tuncate specfic sub partition on specific partition?
query only specific date only. example: '06-MAY-2010'.
1.from the statement below, it will display out more than 06-mAY-2010.
2.if i want more the date from 03-MAY-2010, 04-MAY-2010 and 05-MAY-2010.
select * from PNG_ORA_SERVER_PERF where SERVER_NAME = 'MLYDESPINTF1' and DATE_TIME >= TO_DATE('06-MAY-2010','DD-MM-YYYY');
I need to check if a small collection contains a specific value. I know I can use the .exist method to let me know if the nth element exists. But is there a similar syntax for checking if an actual value exists?
So the below collection has 6 values (300,301,310,320,400,410) after the cursor values are fetched. I want to use something similar to the below exists syntax in order to search the collection for a value (rather than position) within an IF statement.
The below code shows the kind of thing I want to do. Currently, unless my test value (310) is in the range 1 to 6 the test will always return FALSE. But is there a similar syntax for testing against the value?
The example I have given is a simplification of what I need. In reality there will be more than one test value... returned by another cursor.
DECLARE
CURSOR c_type_id_usg
IS
[Code]....
-- get the list of sms type id usg values
OPEN c_type_id_usg;
FETCH c_type_id_usg bulk collect into l_type_ids;
CLOSE c_type_id_usg;
-- the above returns value 300,301,310,320,400,410
IF l_type_ids.exists(310)
then
dbms_output.put_line('I have found an entry ');
else
dbms_output.put_line('I have NOT found an entry ' );
end if;
END;