Oracle administration Questions


Calculation in Oracle 10g
I have created Stud_Transaction table. The code is create table Stud_Transaction ( Student_Id varchar2(10), Account_no varchar2(20), date_of_deposit date, month varchar2(10), year number, Amount_deposited number, Stud_Acc_Balance number, CONSTRAINT fk_PerStud_Transaction FOREIGN KEY (Student_Id) REFERENCES Student (Student_Id) );  i inserted the values into table except Stud_acc_balance column.The Stud_acc_balance column will  update automatically with respect to the Amount_deposited by the [...]

Answer Question   |  March 31, 2012  3:10 PM
Oracle 10g, Oracle 10g administration, Oracle administration
asked by:
5 pts.

oracle explain plan from yesterday
Is it possible to see the explain plan used by Oracle for a select statement that was run yesterday?

Answer Question   |  March 31, 2012  6:08 AM
Oracle, Oracle 11g, Oracle administration, SELECT statement
asked by:
5 pts.

Create date as column name in Oracle SQL?
I WANT TO CREATE A TABLE WITH THE COLUMN NAME AS DATE BUT IT SHOWING THE ERROR.BUT I WANT TO DISPLAY COLUMN NAME AS DATE ONLY CAN ANY ONE HELP i try it SQL> create create table store_information(store_name varchar2(10),sales varchar2(10),date date); create create table store_information(store_name varchar2(10),sales varchar2(10),date date)        * ERROR at line 1: ORA-00901: [...]

Answer Question   |  June 13, 2011  12:39 PM
Oracle administration, Oracle SQL, Oracle SQL Developer
asked by:
25 pts.

Display GIS maps on Oracle forms
I want to integrate the oracle form with GIS aplications. how can i do can u please help me on this

Answer Question   |  March 8, 2011  3:16 AM
GIS, Oracle administration, Oracle developers, Oracle Forms
asked by:
25 pts.

asked by:
5 pts.

COmplex update takes a 90 minutes to run in Oracle
In the following procedure, the update is taking 90 minutes. The client table has 22 million records, the CPDS table has 40 records. It has been written by someone else, I don’t have access to Oracle so can’t check my thinking, but I believe, if we select the data to be updated into pl/sql tables, and [...]

Answer Question   |  February 1, 2011  4:19 PM
BULK COLLECT statement, Oracle, Oracle administration, Oracle Processes, Oracle Query
asked by:
10 pts.

Oracle 10g date column
Hi All, In the below query VALUEDDATE is the date column and REGISTER is the table. wat is the use writing CAST(FLOOR( CAST( VALUEDDATE AS FLOAT ) )AS DATETIME) VALUE_DATE instead of simply column name ie,VALUE_DATE [hr /> query: SELECT CAST(FLOOR( CAST( VALUEDDATE AS FLOAT ) )AS DATETIME) VALUE_DATE FROM REGISTER WHERE VALUEDDATE>’09/30/2009′ —————————————————————————————————–

Answer Question   |  December 21, 2010  10:34 AM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle administration
asked by:
220 pts.

Rename username in Oracle 10g database
Rename username in oracle 10g database without droping it

Answer Question   |  November 24, 2010  12:31 PM
Oracle 10g, Oracle 10g Database, Oracle 9i, Oracle administration, Oracle User Profiles
asked by:
50 pts.

Duplicate data in column in Oracle 10g Express Edition
I hava created a column like:                               create table pen(no integer, name varchar(30)) It contains the following data:             NO NAME              1         reynolds              2 [...]

Answer Question   |  November 25, 2010  11:21 AM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle administration
asked by:
220 pts.

How to set oracle database path with oracle developer
how to set oracle database path with oracle developer

Answer Question   |  November 23, 2010  10:44 AM
Oracle, Oracle administration, Oracle Database, Oracle Developer, Windows Server 2003
asked by:
5 pts.

Invalid credentials in Oracle Database 10g?
I installed Oracle database 10g Express edition successfully and While installing it asked password only. But now it is asking User Name and Password. i know password but i dint gave any username. what it might be.

Answer Question   |  November 11, 2010  11:31 AM
Oracle administration, Oracle Database, Oracle Database 10g, Oracle User Profiles
asked by:
220 pts.

Merging Organizations in Oracle
How is the best way to merge two orgs in Oracle?

Answer Question   |  November 12, 2010  7:34 AM
MERGE statement, Oracle, Oracle administration
asked by:
15 pts.

Oracle Enterprise Manager
Hello there, Does anybody can tell me how to open the Oracle Enterprise Manager? I tried  http://localhost:8888/em but it never works. What else do I need to do?

Answer Question   |  September 1, 2010  6:22 PM
Oracle, Oracle administration, Oracle Enterprise Manager, Oracle errors, Perl
asked by:
5 pts.

Oracle Library cache
What are the steps involved in tuning oracle’s library cache

Answer Question   |  August 12, 2010  6:17 AM
Oracle, Oracle administration
5 pts.

Connecting and disconnecting Oracle sessions through Oracle forms
How to  connect and disconnect oracle sessions through oracle forms?(suppose I need to validate user whose corrently loged on.)   email to :anandan.muthukannan@tcs.com

Answer Question   |  August 10, 2010  1:31 PM
Oracle, Oracle administration, Oracle authentication, Oracle connectivity, Oracle Forms, Oracle User Profiles
5 pts.

Oracle Help?What is the DB dependencies related to object sequencing for DB builds
What is the DB dependencies related to object sequencing for DB builds?

Answer Question   |  August 3, 2010  12:00 PM
Oracle administration, Oracle Database, Oracle development
asked by:
5 pts.

make an id in oracle 8
i m the user of oracle 8i..i want to make an separate account in oracle.. how i can make an account..please tell me if u knoww..  

Answer Question   |  July 6, 2010  2:03 PM
Oracle 8i, Oracle administration
asked by:
30 pts.

Oracle data missing, over 500GB worth.
Instance of Oracle on HP-UX 11.11, Oracle version 9.2.0.8, has lost hundreds of GB of data. Manual/accidental deletion is not possible as the process would take a long time to execute. Error logs do not show much, AUD$ log doesn’t show any user activity during the window of time (roughly 24 hours). an ORA-1650 error [...]

Answer Question   |  July 20, 2010  8:45 PM
Oracle 9, Oracle administration, Oracle errors
asked by:
15 pts.

oracle forms 6i
i need to know the coding for NEXT BUTTON in oracle forms 6i,when the fields are not database items…. i want to fetch next record after pressing NEXT BUTTON…i have applied select query and tried to store the fetched records in fields of the form….but in vain…i got no output in the screen…jst the empty [...]

Answer Question   |  April 30, 2010  11:07 AM
Oracle 6i, Oracle administration, Oracle Forms, Oracle Forms 6i
asked by:
5 pts.

drop down list Oracle 6i
i a creating a login page i which user have to select that he want to log in as admin or as user i want user select from drop down list so plz guide me how drop down list is formed in orcle 6i from builder

Answer Question   |  April 20, 2010  5:39 AM
Oracle 6i, Oracle 6i Reports Builder, Oracle administration
asked by:
5 pts.