-
Hi1. State the order in which the trigger will get fired2.I have an doubt in trigger. I created two trigger. trigger name is only different but structure is same. I want to know the order in which these two trigger will get fired
krishnaindia2007
- Jun 22nd, 2008
1.Firing sequence of Database triggers on multiple rows Before statement trigger Before row trigger for first row After row trigger for first row Befo...
Prashanth
- Apr 24th, 2007
The one that is created last executes first
-
I have a customer table custid,Trade,Amount three fields are there custid dont have unique value, now trade B & S values. I want to Show sum of amount of custid, for both the trade in one line Like cust id,Btrade,Bamount,Strade,Samount1 B 12000 S 5000 This One i tried but problem in thisselect a.Custid,a.TRADEID,sum(a.AMOUNT),b.TRADEID,sum(b.AMOUNT) from custmer a,custmer bwhere a.Custid = b.Custid and A.TRADEID = 'B' and b.TRADEID = 'S' group by a.Custid,a.TRADEID,b.Custid,b.TRADEID
Imran_Javed
- May 9th, 2008
SELECT MIN(b.CUSTID) "cust id", MIN(b.TRADE) "Btrade", SUM(b.AMOUNT) "Bamount", MIN(s.trade) "Strade", MIN(s.amount) "Samount"FROM cust_t b, (SELECT MIN(CUSTID),MIN(TRADE) trade,SUM(AMOUNT) amount FROM cust_t WHERE trade ='s') s WHERE b.trade = 'b';
jamesravid
- Dec 10th, 2006
Hi Try this query,Select custid, 'B' as BTrade, sum(decode(tradeid,'B',amount,0) Bamount 'S' as Strade, sum(decode(tradeid,'S',amount,0) Samountfrom customergroup by custidRegards,James.
-
Where are dropped tables storedCan I have same table with the same name in one tablespace?
madhuk17
- Feb 18th, 2007
Tables once dropped are permanently removed from database and hence they are stored no where in database.
Radhi09
- Feb 15th, 2007
HiAs of now i dont think there is any thing of that sort in oracle 9i ,but 10g provides the option of flash backthanks
-
What is the Difference between stored procedures and external procedures?
sampra
- Feb 26th, 2008
An external procedure is simply a program unit that is not written in Oracle’s SQL or PL/SQL and resides outside of the database. External procedures must be stored as shared libraries at the op...
g_sidhu1
- Feb 21st, 2008
An external procedure is simply a program unit that is not written in Oracle’s SQL or PL/SQL and resides outside of the database. External procedures must be stored as shared libraries at the operating system level. In a Windows NT environment, the procedure would be compiled into a DLL.
-
How many null value a unique key constraint can have?
I think there can be only one null value for a unique key constraint but some say there can be more than one null value.
ammupriyaa
- Aug 22nd, 2008
Can have any number of NULL values, since oracle?maintains internally different values for each?NULL values.
-
How centralized DBMS differs from distributed DBMS .
ambika
- Oct 21st, 2013
Recovery in centralized dbms
su4surya
- Aug 24th, 2009
A centralized database has all its data at one place so there may occur problems of data avalability, and a system crash may lead to whole dataloss. In a distributed database, database is stored on se...
-
How to use "CASE" keyword in SELECT statement?
AVADHESH
- Sep 30th, 2011
Code- SELECT newsid, news,STATUS,
- case STATUS
- WHEN '1' THEN 'Active'
- WHEN '0' THEN 'Deactive'
- END AS fieldnm
- FROM news ORDER BY newsid;
sirisha.hari
- Jan 6th, 2008
hi,select sno,sname,(case when total>50then 'good'when total>35 and total<50then 'average'else 'fail'end)resultfrom student_result
-
SQL Query help
Needed a SQL query for this----------I have table with columns firstname, lastname and phone number and we have 2 entries in that table ...now I want to know the persons with this combination firstname of person = lastname of second person? ln phone----------------------------------john cubick 1223sam course 4556output:john course
geminine79
- Jan 3rd, 2008
I think you can use the cartesian product on the same table and try to get the data out of that. try this and let me know.
naveen.papineni
- Nov 26th, 2007
Select first_name ,last_name ,phone_number from table where first_name in (select last_name from table )I think this will work out.RegardsNaveen.
-
Oracle long datatype
I'm using oracle9i to create a table which stores lyrics in long datatype. But if i store a long string of text and display it from the table, it displays only 80 chars. So someone help me how to store the whole lyrics txt file
ramyaselvi16
- Jun 24th, 2008
Variable length character values up to 2 gigabytes. Only one LONG column is allowed per table. You cannot use LONG datatype in functions, WHERE clause of SELECT, in indexing and subqueries.
-
Constraint and Index
What is difference between constraint and index? How do use them in SQL query?
krishnaindia2007
- Jun 21st, 2008
Constraint is used to restrict invalid and inconsistent data entry into the table.Index is used for faster retrieval of data.Both are entirely different concepts.
srinivasa.dinesh
- Jan 29th, 2008
Constraints are rules applied to Table/Columns of a table. Constraints are one type of restriction which are useful while data is manipulated.Index are ordered list of rows of tables. Index are useful while faster retrival of data.Hope this anwsers to your question.Cheers,Srini.
-
What is a deadlock?
There is a table with Pluks('plk') and Zinks ('zin'). Each Pluk onlyresides on a single Zink and each Zink may contain multiple Pluks. Howdo you find how many Pluks are on each and every Zink? Please provide SQL.What is a deadlock?
krishnaindia2007
- May 16th, 2008
Dead lock is a unique situation in multiuser system that causes two or more users to wait indefinately for a locked resource. First user needs a resource locked by the second user and second user ...
g_sidhu
- Feb 6th, 2008
A deadlock occurs when two or more users are waiting for data locked by each other. When this happens, these users are stuck (deadly embraced) and cannot continue processing. Oracle automatically dete...
-
Retrieve data from two tables
How to retrieve data from two tables of different servers
Sujaya
- Jun 8th, 2012
SELECT Ename, DeptNo, Sal, Emp.DeptNo, Dept.Dname, Dept.Loc, Dept FROM
Emp, Dept
WHERE Emp.DeptNo = Dept.DeptNo;
-
Tune SQL Query
How can you tune the query?
Imran_Javed
- May 8th, 2008
First look at the explain plan if there is any full scan. Then add appropriate index on columns that are used in the query. Basically, always add index on foreign key and the date columns (Most of the application access tables based on dated)
-
DOS command
How to execute DOS Commands from SQL prompt?
vinodsahani
- Apr 12th, 2008
Either you can type HOST to go into DOS prompt, use DOS commands and then type EXIT to return back.OR, if you want to run only one DOS command you can type HOST Hope this will work for u.
-
Export data from SQL to Excel
How to export data from a SQL table to MS Excel?
sameers007
- Apr 6th, 2008
Spooling means just copying what ever we type in SQL prompt rit, I want to know whether any query exists for that
-
Find all tables in a database
How to find all the tables existing in a database?
krishnaindia2007
- Jun 20th, 2008
To view tables in the current schemaSELECT OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TABLE'To view all the tables that you have access SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OBJECT...
Imran_Javed
- May 8th, 2008
SELECT TABLE_NAME FROM All_TABLESOrder by TABLE_NAME;The above query will display all the table names in the database.SELECT TABLE_NAME FROM USER_TABLESOrder by TABLE_NAME;The above query will display all the table names in a particular schema.
-
Difference between nested query,sub query and nested query?
What is difference between nested query,sub query and nested query? explain clearly with an example?
Read Best Answer
Editorial / Best Answer
arpitapatel- Member Since Sep-2008 | Sep 24th, 2008
Query inside the query is nested query.
It is also called as sub query.
Correlated subquery runs once for each row selected by the outer query. It contains a reference to a value from the row selected by the outer query.
Nested subquery runs only once for the entire nesting (outer) query. It does not contain any reference to the outer query row.rams
- Apr 3rd, 2012
Both are same
katgeektalk
- Aug 22nd, 2010
The subquerry is often reffered to as a nested SELECT, sub-SELECT, or inner SELECT statement. The subquery generally excuted first, and its output is used to complete the query condition for the main (or outer) query.
-
Intent Shared Lock
Which one of the following is descriptive of the effect of an Intent Shared Lock on other transactions? CHOICE1: A Read Lock that prevents writes CHOICE2: A Read Lock that prevents other reads CHOICE3: A Read Lock that prevents more restrictive Locks CHOICE4: A Read Lock that allows other reads CHOICE5: A Read Lock that allows writes (Dirty Reads)
manimehra905
- May 18th, 2010
Read lock that allows other read as it has been made the shared lock intentionally.
hmounir
- May 3rd, 2010
A Read Lock that allows other reads Shared (S) locks allow concurrent transactions to read (SELECT) a resource under pessimistic concurrency control.No other transactions can modify the data whi...
-
Display Time in SQL
How to display current system time in SQL.
g.sreemayee
- May 19th, 2010
select to_char(sysdate,'HH24:MM:SS') from dual;select current_timestamp from dual;These two will give the current time of the system.1. ll give the time only.2. ll give the time with the date.
-
Retrieve Rows Without Using SELECT Clause
How can we retrieve some rows from the database without using select clause?
Oracle SQL Interview Questions
Ans