-
What is the result of the fallowing code?PieceInsert into table A value(a1):CREATE TABLE B AS SELECT * FROM A;ROLLBACK;A. Table B gets created with the row inserted in the first statement.B. Table B is not createdC. Table B gets created, but no row gets inserted into Table AD. Rollback throws up an exception.
Guest
- Jan 4th, 2007
hian empty table table (B) will be created there is a mistake un the first statementno need to commit a Create instruction, so the rollback will have no effectgood luck
-
Changing column name
How we can change the name of the column for a existing table?
ushalakshmi
- Apr 16th, 2008
The Column Can be changed by using the following commandsp_rename 'Tablename.OldColumnname', 'new columnname', 'COLUMN&#...
ravinder.pathania
- Feb 5th, 2008
The coloumn name can be changed by issuing the following commandalter table rename column to The feature is available after oracle 9i version
-
What is Partitioning in SQL ?
venkat82.k
- Mar 19th, 2008
Hi guys partitionings nothing but a huge table is divided into some meaningfull parts to do manipulations ,for easy maintainwe divide partitions while creating tables.mainly 3 types of par...
-
How to execute a sql*plus script from pl/sql block.
My script contains sql plus set commands. how to execute that script in a pl/sql block i.e. either anonymous ,procedure or function or trigger
hemant.agarwal03
- Mar 17th, 2008
First you need to save your file in .sql format, suppose you create set.sql and saved it on c: drive then follow below command.SQL> @C:SET.SQL and press ENTERyour script has been executed. :-)
Susil Kumar
- Feb 20th, 2008
Let me reframe the question as follows: How to execute pl/sql block in sql*plus environment?If I am on the right path, I'll be able to give th...
-
SQL Time Functions
How to calculate the time variation between two different time sessions?
Sudhir Sorout
- Feb 4th, 2008
Select t1- t2 from dualwhere t1 and t2 are dates then this query will return no of day not hrs.Sudhir Sorout
gbansal4
- Dec 15th, 2007
Select t1 - t2 from dualwhere t1 & t2 are dates. It will give output in hours.
-
How to test the complex view using manually testing?
Sudhir Sorout
- Feb 4th, 2008
We can update a view using instead of trigger..... see example on url..http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls365.htm
gemini burj
- Nov 18th, 2007
Complex view means that no DML statement could be executed for this view, to test it you may descrive or select the columns from the views.
-
C Null and SQL Null
what is the difference between the null in C and one in SQL?
Sudhir Sorout
- Feb 4th, 2008
Null is a special marker used to indicate that a data value is unknown in the sql. But in case of ‘C’ A "null statement" is a statement containing only a semicolon; it can appear...
-
SenatorSID Name Year Service Party CID1 Jerry 5 Rep 22 Mary 2 Dem 33 Barry 12 Dem 1CountyCID Name Democrats Republicans1 Evergreen 75,000 70,0002 Marsh 12,000 25,0003 Hilltop 9,500 8,000A) List each county in alphabetical order with the senator that serves the county
anugrah17
- Jan 9th, 2008
above solution is also correct, but a join is always better :)--------------------------------------------------------------------------SELECT Country.Name AS Country, Senator....
rajakumar_na
- Nov 22nd, 2007
Try this,SELECT c.name county, s.name senatorFROM county c, senator sWHERE s.cid = c.cidORDERY BY county; Result;COUNTY &nbs...
-
Provide brief explanation of following SQL code
This is one of the questions I have on my interview exam. It is a take home exam and I have not learned SQL but the employers want to know my know my skills to find answers using any means possible. Question: Review the following SQL code and give a brief explanation SELECT 'AD', B.AccountID,'Change' FROM (SELECT DISTINCT A.sAMAccountName As AccountID from (select AG.sAMAccountName...
ajith007
- Dec 6th, 2007
Use of distinct, not in keywords make this code altogether complicated. But what I discern from this code 'catch' lies in FULL OUTER JOIN since it retreives all the data including your null values.The union here returns the cross product of query mentioned that includes your null values.
-
What is pipeline function? How it is used?
gemini burj
- Nov 18th, 2007
Pipelined functions are useful if there is a need for a data source other than a table in a select statementFor more details, following link is available.http://www.adp-gmbh.ch/ora/plsql/pipeline.html
-
Explain usage of TRANSLATE function in SQL
gemini burj
- Nov 18th, 2007
the translate function replaces a sequence of characters in a string with another set of characters. However, it replaces a single character at a time. For example, it will replace the 1st chara...
-
-
What is the main difference between the IN and EXISTS clause in subqueries??
The main difference between the IN and EXISTS predicate in subquery is the way in which the query gets executed.IN -- The inner query is executed first and the list of values obtained as its result is used by the outer query.The inner query is executed for only once.EXISTS -- The first row from the outer query is selected ,then the inner query is executed and , the outer query output uses this result...
gemini burj
- Oct 23rd, 2007
In case of a big number of list from the select list IN operator should not be used but the exists shall be used with the proper condition this will definetely make the query optimal query.
Mahesh
- Jul 24th, 2007
In operaor scan all the values inside the IN block where as EXIST quit after 1st occurrence.
-
What is the output of the following query?
SELECT TRUNC(1234.5678,-2) FROM DUAL;1200
gemini burj
- Oct 23rd, 2007
if the -ive parameter is passed under TRUNC function truncation will be used to below decimal place i.e-1 means Trunc to 10th (1234 becomes 1230)-2 means trunc to 100th (1234 becomes 1200)-3 means tru...
thumati_nagaraju@yahoo.co.in
- Nov 17th, 2006
This is -ve no given so it remove the digits before decimal point ... and replace it by zero if want to check it just try with -1 or -2 or -3 ok seeu byeee
-
-
How do find that your global temporary table is defined with "on commit preserve rows" or "on commit delete rows"?
meenakvasulochanan
- Aug 17th, 2007
The column "duration" in all_tables will tell us whether the temporary table is defined with "on commit preserve row" or "on commit delete rows"The values :SYS$TRANSACTIO...
-
-
-
How do you declare a variable with BLOB as datatype? How can you use BLOB data type? What size can be given to its variable?
intelmental4
- Jul 23rd, 2007
BLOB is Binary Large ObjectWhen you declare any variable as image, text, ntext ... they would be BLOB data typesText = 2^31-1text = 2^30-1ntext = 2^31-1-Each text, ntext, image colum can in a table ca...
-
What is normalazation,types with examples. with queries of all types?
rangunagaraj
- Jul 6th, 2007
NORMALIZATION is a body of rules addressing analysis and conversion of data structures into relations that exhibit more desirable properties of internal consistency,minimal redundancy and maximum stab...
Ranjeev
- Apr 26th, 2006
Normalisation can be defined as a process to minimize, infact eliminate redundancy of data within the database. It first requires that redundancy is detected through the proper use of FD's( Functional...
SQL Interview Questions
Ans