logo for asktheoracle.net
leftimage for asktheoracle.net

Questions about Oracle databases? SQL?  PL/SQL?

This is the place to ask.

Are you stuck with an Oracle problem? Do you have a question about how the database works?  Need some advice on writing SQL or PL/SQL? Then ask your questions here and we'll answer as quickly as we can.


There are 4 ways you can get help on this page:

  • You can use the search box to help you to find the  information you're looking for quickly
  • You can use the form to ask us a question
  • You can read the questions other developers have asked along with the answers
  • And you can subscribe to our ezine - if you're not already a subscriber to Oracle Tips & Tricks you're missing out on a myriad of valuable tips and techniques. Subscribe now and ignite your career.
Search AskTheOracle.net for an answer to your question.


Have A Question About Oracle?

Do you have a question about Oracle databases? Or do you meed help with SQL or PL/SQL? Or maybe you're looking for some advice on the best way to resolve an issue? Whatever it is, just AskTheOracle!

We give our best answers but maybe you know of a better way to solve a problem or can improve an answer, or maybe you can recommend a book/web page/article which will help. In which case, feel free to add your comments and share your expertise.

[ ? ]

Upload 1-4 Screenshots (optional)[ ? ]

 

Click here to upload more images (optional)

Author Information (optional)

To receive credit as the author, enter your information below.

(first or full name)

(e.g., City, State, Country)

Submit Your Contribution

 submission guidelines.


(You can preview and edit on the next page)

What Other Developers Have Asked

Questions other Oracle developers have asked ...

Oracle query to find the maximum of total 
I have the below student table with rows like this Hide Copy Code student_id subject_id Mark 1 1 60 1 …

Need to add one more column with seq 
Hi, Below is my table and data create table t11 (id number,property varchar2(20)); insert into t11 values(1,'p1'); insert into t11 values(1,'p2'); …

passing parameters from PL/SQL to dynamic SQL statement 
Could not find a way either in a package or otherwise to do a simple dynamic sql via an array. declare --l_deptnos varchar2(100) := 'I0157967'; …

Can we pass parameters in triggers like in procedures? 
Can we pass parameters in triggers like in procedures and Triggers?

sqlplus.exe - how to know if an error occured during file execution script  
Hi everybody! I have a program that run automatically some script files using sqlplus.exe. For some reasons the customer want to run all statements …

Correction: ctas is not dml 
Oracle 12c New Features For Developers you state ctas is DML - wrong - it commits JOHN orcl >select count(*) from emp; COUNT(*) ---------- …

Insert the possible combinations of two arrays in to another array in PLSQL 
I have two arrays Course and time. I am trying to create another array with all the possible combinations of these two arrays. For eg: DECLARE type …

using loop for input vales from user....help needed 
i m new with pl/sql...just started learning... my problem is that as in c or c++ we can accept vales from user as many times by usin loops, i want to …

get max count joing 2 tables 
I have 2 tables 1 STUDENT (ID, NAME , COURSE_ID) 2 COURSE(ID, NAME) I need to get the COURSE.NAME and Count of students for the course …

create a function that calculate tax 7% of salary & return it in main pl/sql code subtract that tax from salary. 
I cant understood this question.Exactly what to do here please give answer of this question.

Varchar2 column with a date and time listed as YYYY/MM/DD-HH24:MI:SSFF3 
I am more of a beginner in Oracle yet I do some querying on my job. I need to calculate the date only out of this date time varchar2 format(YYYY/MM/DD-HH24:MI:SSFF3). …

DB2 integer string to date conversion 
I am extracting an integer from a DB2 table that serves as a date, for example 20140101 is how it is stored. we want to see it as 01/01/2014. Problem …

it is posible to use math operations between together 
I mean, its way to use something like this: SELECT (1+1) AS S1, (2 + S1) AS S2, (2 + S2) AS S3 FROM DUAL

how to change the password to running user 
hi... i need to know about some of my queries.. please tell me 1. how to change the password to running user? 2. how to increase the width of the column? …

how to delete duplicate rows in the table? 
hi... i have lot of confusion in queries.. please tell me 1. how to delete the duplicate rows in the table? 2. display the dept no, dept name and manager? …

Obtain logged on user in a PL/SQL trigger 
I have a trigger created against our address table to capture data manipulation transactions in an audit table as follows: CREATE OR REPLACE TRIGGER …

How to handle precision of number data type 
Hi, I have a table with a column VOL which is a number data type NUMBER(7,3). The value in the column gets populated with the code MAX (NVL (0.493039/1000, …

the difference between in,out,inout modes when passing parameters to PL/SQL procedures and functions with examples. 
Could anyone explain the difference between in,out,inout modes when passing parameters to Oracle PL/SQL procedures and functions with examples and also …

how to show differences between sets of data in Oracle 
I am learning Oracle Pl/Sql and have a scenario as follows which I can't seems to figure out: I have a legacy table of application settings i.e. see table …

a single query where the ename starts with or contains 'paul' 
I need to write a single Oracle query without using AND/OR where the ename may starts with or may contain 'paul'.

How to delete all the rows in a table in an Oracle database leaving just the first 2 rows. 
There is a table with 100 entries. I want to delete all the rows except first two row. How should I do it? This is a very good question and one that …

I would like to know the SQL coding to total records into a new field based on a string in a different field? 
I have a contributor table with amounts listed for several contributors. Each contributor has an ID associated with them. Some have made one payment, …

I am beginner. i like oracle more & want to develop software web based enriched latest technology. 
I am beginner and have no knowledge about oracle database & sql/pl. i like oracle more & want to develop software web based enriched latest technology. …

Click here to write your own.

The difference between Merge and Update 
What is the difference between Merge and Update in SQL?

How can I get NUMBER data with mentioned precision value 
Hi All, I have a table test1 with following columns create table test1( col1 NUMBER(10,4)); I am using ORACLE11g I have inserted following data …

create a PL/SQL trigger which implement check constraint i.e commission of an employ is never greater than salary? 
How do I create an Oracle PL/SQL trigger which implements check constraint i.e commission of an employee is never greater than salary?

Need to add a unique row count for every repeating variable 
It will be easier if I demonstrate what I am talking about: I have a table with the following layout: Emplid term Major 123 1992 abc …

triggers 
is the information about triggers stored in oracle DD?

question about oracle performance 
for performance issues, which is better for server configuration: less processor many cores (ex single processor quad cores) or many processor less core …

how excel data can b inserted in my new oracle inventory manaement software? 
i make a software for the organization and they want to convert their excel data in new oracle software. i make their inventory management system in …

Help me to find the certification path for oracle developer OCP 
Hi, I have completed OCP DBA in oracle 9i. I have answered 1Z0-007 Introduction to 9i SQL Exam, 1Z0-031 Oracle9i Database: Fundamentals I Exam, 1Z0-032 …

Newbie SQL developer question 
I am new to SQL and am trying to install SQL developer on mac. I have followed your youtube tutorial. When i go to test the connection i get an error …

what is performance tuning 
what is performance tuning

Grant access to different schema's 
A user want to have select access to all schema's. How can we add him to all schema's. we don't want to give him dba role to him.

REF CURSOR 
In which scenario we can use ref cursor in Oracle?

insert a row into an Oracle table having 2 columns only  
hi guys, I want to seek your help. I have two tables- table1 and table2 namely having columns as col1 and col2 in both the tables table1 …

I have salary 800 and want to output as eight hundred which function is helpful for this in Oracle? 
I AM HAVING SALARY 800 IN MY EMP TABLE I WANT TO DISPLAY THE OUTPUT LIKE THIS EIGHT HUNDRED WHICH FUNCTION IS USEFUL FOR THIS

using trigger on one table to update another table in Oracle 
My problem is the following: For my Oracle application, at the time when P_delivery_date changes in P_ORDERS I want to transfere P_delivery_date to …

is oracle banifical for me after my b.tech is cmplted 
I WANT TO ASK ABOUT oracle ..i.e how much of package given to me by any company

data pump network import 
I have to import table data from a remote database to my own database. i was able to set up a database link and now i want to use data pump to import some …

How to save the Oracle queries like we can save in sql database? 
How to save the Oracle queries like we can save in sql database? Depending on what you want, there are a few ways to save queries in an Oracle database. …

What are the disadvantages of indexes in Oracle? 
WHAT ARE THE DISADVANTAGES OF INDEXES IN ORACLE? That's a very good question to ask in general of any feature in your database or system because every …

Beginners courses in Oracle 
I have no background about Oracle and I do not know how to start learning oracle. My interesting filed in business is marketing specifically CRM. Can you …

advantages of composite datatypes in oracle 
Whhat are the advantages of composite datatypes in oracle?

Can't understand warnings in this simple PL/SQL function 
uestion: I am using Oracle 10g with SqlDeveloper. When I execute the following code, it says "FUNCTION wafadar compiled Warning: execution completed …

can we use more than one constraint on perticuler column? 
is it possible to gave more than one constraint on particular column?

Help on retrieving null values in SQL 
SELECT Distinct persmain.IDENTIFIER ClientNo ,initcap(nvl(ltrim( persmain.FIRST_NAMES||' '||persmain.FAMILY_NAME) , 'Not Recorded')) NAME ,REPLACE(BOF_first_add(T …

What is the answer of 100 added to null in SQL? 
Question: I want to know the answer of this question: 100+null=? in sql Answer: This is a question that goes to the heart of SQL. What is NULL? Null …

Click here to write your own.

In my Oracle database I have a table with more than 100 columns, what would be the impact of adding more columns? 
Hi, I am using Oracle database and i want to upgrade my table with more than 150 columns in it, will you please articulate me that what would be the …

Oracle database index types 
What are the different types of indexes in Oracle databases? Please give examples for all indexes. There are several types of indexes available in …

Take backup of Oracle database without SYSDBA and SYSOPER login in system? 
I have question about taking backup of database in ORACLE 10g. In my project I created one application in my mobile which only accepts user name and password …

Capturing column value through returning clause while inserting data into a table in Oracle 
Question: I have a table in my Oracle database defined as follows: create table my_tab( a number primary key , b varchar2(10) , c date default …

connecting to different databses in oracle? 
Question: I am using Oracle DBCA for creating a new database. While creating new database it asks for hostname & SID. The hostname of my system is empmngt …

Content Management Systems for Oracle 
Question: Any pointers on cost effective content management software, which can be easily integrated with Oracle EBS R12 1.3 and its key features. Client …

What are Oracle Utilities? 
What are Oracle Utilities?

How can I print the value of a variable declared in an outer Oracle PL/SQL block from an inner one?  
I have a variable, (say 'A') declared in a pl/sql block. In an inner pl/sql block I declared another variable 'A'. Now how can i print the value of outer …

Help with using Oracle SQL MERGE statement 
Can you please provide advice on the following: I am trying to update the table wn_termlist so that it contains all termid's from the table sa_term against …

Is there any way to determine if the ORA_ROWSCN number in a table in Oracle is corrupted? 
I have found that the ORA_ROWSCN number for some of the records in a table in my Oracle database is showing as 1, but when I ran a query with the condition …

Can I use an Oracle exception like dup val on index to detect if the record exists within the table? 
Can I use an Oracle exception like dup val on index to detect if the record exists within the table? I'm loading a fact table in a data mart and I …

what is ref cursor? 
What is a PL/SQL ref cursor? What is the purpose and where the situation we use Ref cursor in our application? A ref cursor in Oracle PL/SQL is …

Can we use BREAK ON and COMPUTE within an Oracle stored procedure 
Is it possible to create a pl/sql package like the following? CREATE OR REPLACE PACKAGE CONS_REP1 AS    TYPE CUR_TEMP IS REF CURSOR; …

How to count how many 'm's exist in a row in my table in Oracle 
This is the table definition and a sample of data. create table newtable( SAA varchar2(30), s1 varchar2(1), s2 varchar2(1), s3 varchar2(1), s4 …

Can you provide some interview questions for sql and pl/sql? 
Could you provide a link or a file that contains sql and pl/sql interview questions with answers? I'm going for an interview next week for a sql support …

What are the advantages of using joins in Oracle? 
I'd like to know what are the advantages or disadvantages of using joins over sub queries in Oracle To answer this question let's first define a subquery. …

How to convert more than seven digit to words using sql ? 
I want to convert total salary received during the year into words. How do I do this using SQL? You won't be able to do this in pure SQL. You would …

How do indexes work internally in Oracle? 
There are several types of index available for use in Oracle databases, the most common ones (in our experience) are B-tree (balanced tree) indexes, function-based …

Problem connecting to Oracle "as sysdba" from Oracle SQL Developer 
I have an Oracle 10g XE database running on Windows Vista and I want to connect "as sysdba" from Oracle SQL Developer. When I test the connection I …

What will happen if we do not close a cursor in PL/SQL 
From Jamuna, Hyderbad - With Oracle pl/sql if an explicit cursor is opened and we do not close the cursor what will happen? Will the programme run? …

How to run an executable from an Oracle Trigger 
From: Sean - Hi, is it possible to run an executable file from an Oracle trigger? I haven't been able to find any documentation on how to do this - …

Iin Oracle how can I display the LENGTH of the last_name for all employees whose names start with the letter "A" "J" "M"  
From Ayah, Port Harcourt I am working with Oracle 11G and want to display the last name of an employee from the employees table,with the first letter …

How can I get the 2nd or the 3rd highest value from a table in an Oracle database? 
For example, using the emp table in the sample schema in Oracle, how would I retrieve just the 2nd or 3rd highest salary? There are a couple of ways …

I require assistance with an Oracle SQL query 
Record name is TREE. The two fields are PARENT & CHILD. It's a tree structure i.e. PARENT = 0001 CHILD = 2000 CHILD = 3000 PARENT = 2000 CHILD …

The command create or replace PACKAGE ... is not being honored. Not rated yet
The command create or replace PACKAGE ... is not being honored. I have had numerous times where if I use @ command in a driver file on a Package Body …

Click here to write your own.

DBMS-pipe.unpack-message returns 65280 error Not rated yet
Any idea on why dbms pipe unpack message returns 65280 value. Is this 65280 oracle error or user defined error. Please suggest what are the different …

How to send Flat File from 1 IP Address to another IP address Not rated yet
Hi Team , I have send Flat file from my PC to one of the location of another PC . How can i send using PL/SQL procedure or is there is any other …

how to develop Oracle pl/sql knowledge Not rated yet
I need to develop my skill in Oracle pl/sql in depth my total IT experience 4.2 years. Can you help? If you have any programming experience at all …

Which process is inserting a record in a table Not rated yet
Which process is inserting a record in a table, as I am getting some confusing results. Is there any way I can put a check on table property where I can …

how to create database in oracle 10g XE? Not rated yet
i am new in oracle 10g XE i dont know how to create database and schema ? and also connect with visual studio 2008? Oracle 10g XE comes with a sample …

How to create a PL/SQL trigger to update a value of column in another table Not rated yet
Hi all, I have two tables in my Oracle database 1.students(rollno,name,batch_code) 2.batches(batch_code,timing,count) I have to create a trigger …

Different types of cursors in pl/sql Not rated yet
Can anyone say me the difference b/w cursors? Oracle supports 3 different types of cursors in PL/SQL implicit cursors explicit cursors and ref …

Getting "Non supported SQL92 token at position: 3477: S" error after running the jsp report Not rated yet
Hi, I am getting the following error after running the jsp report. Query Tag:doAfterBody(),0,Non supported SQL92 token at position: 3477: S …

how to save blob images from oracle table to jpeg into local pc Not rated yet
hi.., i want to download all the images stored into oracle table as BLOBs. These are to be uploaded into SAP system. But i don't know the query/procedure …

how to add a column in required position in the table in Oracle without using on fly table creation? Not rated yet
Before considering any method of adding a column in the required position in the table without using on fly table creation you should be asking a more …

working with date and time Not rated yet
i need a query that will display time as wednesday the 19 of august 2012 13:44:13 The DATE datatype is stored internally by Oracle in 7 bytes in a …

how to delete data in oracle? Not rated yet
what are the steps in deleting data in oracle? There are 3 ways of deleting data in Oracle that a developer is likely to use (and probably another …

How to retrieve a dropped package Not rated yet
hi, i have not enabled any flashblack options. Is there any way to retrieve the dropped package. The easiest way to restore a dropped package …

How do u get the element previous to nth element of a PL/SQL table Type variable m? Not rated yet
How do u get the element previous to nth element of a PL/SQL table Type variable m? Oracle PL/SQL actually has 2 table types - associative arrays …

Do comments change how a PL/SQL program executes? Not rated yet
Comments change how a PL/SQL program executes, so an unsuitable comment can cause the program to fail. True or False? As with every other program …

How to insert values in to tables.in Oracle Not rated yet
I have two tables in my Oracle database, having a relationship. My tables are Employee, and Job. The employee table have JobId foreign key. So how …

Oracle XE Database Connection Test "Status : failure -Test failed: IO Error: The network adapter could not establish the connection" Not rated yet
I would like to know how to configure oracle sql developer database connection? I tried the following: connection name: hr_orcl username: hr Password: …

Problem with auditing trigger on Oracle db Not rated yet
i create trigger on oracle DB for auditing insert or update, when i check nre value if exists it gives error that is null REF. select case item_no …

WHAT IS ORACLE MATERIALIZED VIEW? Not rated yet
What is a materialized view? Since Oracle 9i there are 3 types of views available in Oracle - normal/standard views, object views and materialized …

Redo log recover Not rated yet
Plz... send me redo log recover command...

Query taking long time Not rated yet
Hi I am not able to find out what is the problem with the query it takes a very long time to respond. Following is the data in the tables Table …

How to write trigger code on emp? Not rated yet
I have one requirement. In emp table i have added direct_ind. before 5 clock i want to update this direct_ind = 'Y' and after 8 clock i want to change …

Please help me writing 3 - 4 basic queries Not rated yet
Hi There, I am new for sql and i wrote few basic queries but i need to write few more queries and im finding it difficult. I would be very helpful …

PLSQL Tree structured query - expression build and display Not rated yet
select * from ( (select A.rule_id, A.expression_id, A.operator,a.parent_expression_id, B.section_id, B.field_id, B.attribute_name, C.expression_value …

How to find out the last name of employees that have third letter starts with a? Not rated yet
How to find out the last name of employees that have third letter starts with a? I used this query because single underscore used for one character …

Click here to write your own.

if i have data from an oracle form and i want to get the table which contain by sql (toad) Not rated yet
if i have data from an oracle form and i want to get the table which contain by sql (toad)

executing sql query in regular interval of time Not rated yet
I want to execute a sql query in a regular intervals of time such as updating a table data in regular interval of time automatically? please suggest me …

Problem with Oracle SQL Developer Not rated yet
could not make database connection ... Pleas for Help could not make database connection ... Pleas for Help Assuming you have successfully installed …

Need to automate date value in the equal to statement  Not rated yet
Hi I am currently running a query that looks at the jobs that ran and sees if they completed. It currently looks at the jobs for todays date like this …

difference between Aggregate and Analytical function Not rated yet
what is difference between Aggregate and Analytical functions?

what is the use of parameterize cursor? Not rated yet
hi, pls help this question what is the use of parameterized cursor? The point of parameterized cursors is to offer more flexibility to the designer/developer …

Converting the row data into column data in Oracle Not rated yet
In my Oracle database I have a table of student results with data like this, Name Marks Subject _______________________ Hari 25 ENG Banu …

How do I create an Oracle PL/SQL function FUTUREDATE which accepts 4 parameters - first one is a date, rest are integers - to calculate the new date? Not rated yet
Here is the PL/SQL function: create or replace FUNCTION FutureDate (   p_date IN date,   p_year in int,   p_month …

installation oracle on linux Not rated yet
How to install oracle 10g on redhat5. pl reply asap on my email id asha4aug@gmail.com,if someone can help me out in this ..its urgently required. …

What's the difference between a trigger and a constraint in Oracle?  Not rated yet
What's the difference between a trigger and a constraint in Oracle? To a certain extent there is only a subtle difference between a constraint and …

How to convert local PL/SQL table to table I can select from Not rated yet
Question: I am trying to figure out how I can convert an Oracle PL/SQL local table (of numbers) to a table that I can select from. I want to pass …

While inserting 10 rows into an Oracle database using a procedure, if the 3rd entry has an error, what will be the output? How can we handle that error? How can we restart from the 4th record? Not rated yet
While inserting 10 rows into an Oracle database using a procedure, if the 3rd entry has an error, what will be the output? How can we handle that error? …

How to use utl_file to read and write to OS from Oracle Not rated yet
How use utl_file to read and write to OS? UTL_FILE is a package supplied with Oracle PL/SQL so the short, flippant, and not very helpful, answer …

Explain Plan (How to Say Query is Bad by seeing the Explain Plan Statastics) Not rated yet
Hi We are facing some performance issues in few reports .This is making huge impacts on the servers going down. We have been recommended not to execute …

What is the difference between nested queries & set theory in SQL? Not rated yet
If we can write SQL queries in nested way what is the need to go complex way of relational calculus. One more thing - which one is faster? It seems …

Need to upload and download PDF using Oracloe Forms Not rated yet
Hi All There is a new requirement for my application based on Oracle forms 10g, users need to to upload and download PDF documents into database using …

What is difference between the truncate and delete statements in SQL? Not rated yet
The biggest difference between issuing a delete statement and issuing a truncate table statement against a table in Oracle is in what happens if you …

Problem using SQL Rollup clause in Oracle Not rated yet
Question: I am using the employees table in the HR schema in the sample Oracle database and I want the data to display in this format: Deptno …

Oracle PL/SQL and Oracle Forms Developer Certification Not rated yet
I am working with ASP.Net and Oracle database, so I have decided to go for Oracle certification i.e Oracle PL/SQL and Oracle Forms Developer. I would …

Oracle certification help  Not rated yet
I have experience with mysql but I am new to Oracle so I am thinking of taking the Oracle certification. I heard that there is : Oracle Database …

Possible issues while snapshot is refreshed and then trigger is called which is inserting million records in delta table Not rated yet
Problem is At data warehouse end , fast snapshot is getting refreshed and about a million records will be deleted. Based on snapshot , there is …

Oracle Forms Tab Canvasses Query Not rated yet
Is it possible in Oracle Forms 10g to create a tab-based form and have these dependent on the User? i.e. If four different tabs are created in one form …

How to add caption to a table in Oracle using sql? Not rated yet
We have no idea what captions are in relation to Oracle. A search on http://www.oracle.com and on the Oracle Technology Network (including all the …

What's the difference between a trigger and a procedure in Oracle PL/SQL? Not rated yet
To answer this we need to start with the definitions - a procedure (or function) in Oracle may be written in PL/SQL,Visual Basic .NET, Visual C# or Java …

Is there a limit to the number of tables we can join in Oracle? Not rated yet
Question: How many tables can we join in Oracle? There is no hard limit on the number of tables that you can join in a single query in Oracle. There …

Click here to write your own.

How to generate more than 1 blank space between 2 variables in Oracle plsql Not rated yet
The following Oracle pl/sql code set serveroutput on declare v_nam employees.last_name%type; v_sal employees.salary%type; cursor emp_cursor …

What are PL/SQL triggers? Not rated yet
What are triggers? Why do we use before and after in triggers? Oracle PL/SQL triggers are named and (usually) small pieces of code that are run (fired) …

stop trigger Not rated yet
In this PL/SQL trigger I want when stock.quantity=0 to stop inserting into the purchase table in the Oracle database CREATE OR REPLACE TRIGGER f_trig …

How to insert existing data to another table in Oracle Not rated yet
Hi I have two tables in my Oracle database: CREATE TABLE product ( product_id INT, product_name VARCHAR2(25) NOT NULL, product_price NUMBER(4,2) …

I need a sample schema please help!!!! Not rated yet
I need a sample schema for my database with tables, indexes, sequences etc. all queries in it in .txt(.doc,.pdf etc.). Can you help? Thank you. The …

What is Oracle Performance Tuning? Not rated yet
Please explain about Oracle Performance Tuning Oracle Performance Tuning is a very big subject (whole books have been written on it) so we can't possibly …

What are user defined data types in Oracle? Not rated yet
In short, user defined types in Oracle are more complex data types based on the built-in (standard) data types and can be used in both Oracle PL/SQL and …

How can I select a primary and secondary row from the same table in Oracle? Not rated yet
In my Oracle database I have a table with county codes that has columns of county code and description. Each county has 2 rows. One has county_code as …

I need a sample Oracle database for practice Not rated yet
I am new to Oracle and I want to learn sql and pl/sql programming. Is there a sample database that I can practice on? You can download the small …

How do I load data from Excel into an Oracle table? Not rated yet
I have a compressed Excel file and I want to extract the file and load the data in to an Oracle table. Is there any utility or package available in pl/sql …

What is the difference between a normal query and a subquery in SQL? Not rated yet
What is the difference between a normal query and a subquery? The difference between "normal" queries and subqueries is just semantics. A subquery …

Data conversion functions in oracle? Not rated yet
QUESTION: What are the data conversion functions in Oracle? ANSWER: Oracle has a large number of conversion functions (for example) to convert dates …

What is Oracle metadata? Not rated yet
From Neelima - what is metadata? The short answer is that metadata is data about data. In other words Oracle needs to store data to keep track of …

How will we know that all the records have been inserted into our Oracle database table? Not rated yet
Question: We will be inserting 10 million records into a table in our Oracle database. How will we know that all the records have been inserted into our …

Oracle performance tuning Not rated yet
From Jamuna, Hyderbad - what are the performance tuning steps in Oracle? Oracle performance tuning is a very big subject - there have been whole books …

What is view in Oracle? Not rated yet
Question: what is a view and how many types of views are there in Oracle? We'll answer the 2nd part first to make it easier to answer the 1st part. …

How can I change the defult date format in oracle10g enterprise? Not rated yet
Question: I use alter session & NLS_DATE_FORMAT, but it's not working. The ALTER SESSION command in Oracle only affects the current session (as …

Question about using foreign key constraints in Oracle Not rated yet
From Apoorva - I am doing SQL / PLSQL course for Oracle. Right now, I am doing SQL and have came across a problem. Following is the SQL statement : …

Problem with Oracle SQL performance Not rated yet
From: Paramesh in Singapore - We are using Oracle and I have a problem with SQL. We are retrieving data from 6 tables using joins (returning approximately …

Do you have any tips on Oracle performance tuning? Not rated yet
I have been doing large inserts on a couple of tables in my Oracle database and the performance has been degrading by the minute. The performance …

Please tell me about constraints in oracle Not rated yet
What are the various types of constraints in oracle (table level and column level) and what is the difference? There are 6 different types of constraints …

Oracle export problem  Not rated yet
QUESTION: We have a table (Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production) with following data: 2 137 ebpreiss 3 …

Click here to write your own.


Return to home page