How does dropping a table affects its view?

sivaraj6389

 Profile Answers by sivaraj6389 Questions by sivaraj6389

• Sep 7th, 2011

Msg 208, Level 16, State 1, Line 1
Invalid object name 'Table Name'.
Msg 4413, Level 16, State 1, Line 1
Could not use view or function 'view Name' because of binding errors.

infa_dev

 Profile Answers by infa_dev Questions by infa_dev

• Sep 4th, 2011

Oracle will throw following error

ORA-04063: view "viewname" has errors

Answer Question  Select Best Answer

How to remove redundant rows without any distinct columns in the table itself ?

smonroy

 Profile Answers by smonroy Questions by smonroy

• Sep 27th, 2011

Hi my Friend this is the best way to you issue DELETE FROM table_name where camp1 in (SELECT camp1 FROM table_name GROUP BY camp1 HAVING Count(camp1)>1) Example: DELETE FROM ubication where serial...

Allan Hunter

 Profile Answers by Allan Hunter Questions by Allan Hunter

• Sep 22nd, 2011

You're question is vague, but from what I understand it to mean is to remove duplicate rows wihle keeping the columns in tact. The easiest way I know is to make your query based on what makes the dat...

Answer Question  Select Best Answer

How can i retrieve uncommon fields from two different tables along with the data??? say i have table A and table B and Tbl A has x,y,z fields and Tbl B has x,a,b fields and i have to retrieve y,z,a,b fields from two tables along with the data.

Divya

• Jun 5th, 2017

You can try below example query using the 2columns in this query : Select ContactName,FirstName from Customers C, Employees E where C.ContactName not in( E.FirstName)

Ade

• Jun 27th, 2016

Code
 

Answer Question  Select Best Answer

I have a table with 20 columns and I have to retrieve 19 except one.
Is there any way easier then giving
SELECT Col1,Col2,Col3,..........Col19 from table1.

dan

• Jul 31st, 2015

No, cant be done.

bhanu

• Nov 23rd, 2011

If we are dong select top 33* from table, we will get topmost 33 records but not the all 33 columns except 1 column in a table.

Answer Question  Select Best Answer

I have a scenario like Have 7 tables. All these 7 tables have same metadata structure and also all have 2 columns. In that, One column is same in all 7 tables (Joining column, But not a primary column) and another column has different values.

Below have a example for 2 tables. How can we achieve for 7 tables?

Tab1
====
loc_name mem_name
HYD ...

Tmas

• Nov 3rd, 2016

Use outer join

Code
 

Pavan

• Oct 1st, 2016

Hi use sub-query with left join

Answer Question  Select Best Answer

Answer :DESC has two purposes. It is used to describe a schema as well as to retrieve rows from table in descending order.Explanation : The query SELECT * FROM EMP ORDER BY ENAME DESC will display the output sorted on ENAME in descending order.

anuraganu100

 Profile Answers by anuraganu100 Questions by anuraganu100

• Jul 9th, 2010

DESC is used with ORDER BY clause i.e.SELECT * FROM usermaster ORDER BY userid DESC

rekhask

 Profile Answers by rekhask Questions by rekhask

• Sep 11th, 2007

DESC[RIBE] is a SQL*Plus command It is used to describe an Oracle Table, View, Synonym, package or Function.Note that because this is a SQL*Plus command you don't need to terminate it with a semicolon.Syntax: DESC table DESC view DESC synonym DESC function DESC package

Answer Question  Select Best Answer

SELECT TRUNC(1234.5678,-2) FROM DUAL;1200

gemini burj

 Profile Answers by gemini burj Questions by 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

Answer Question  Select Best Answer

LIKE operator

pujavipin

 Profile Answers by pujavipin Questions by pujavipin

• Jun 4th, 2009

LIKE operator can be used in a WHERE clause to search for a particular pattern from columns in a table.Syntax: SELECT column_name(s) from table_name WHERE column_name LIKE pattern.

mehraban_b

 Profile Answers by mehraban_b Questions by mehraban_b

• Mar 15th, 2007

%

Answer Question  Select Best Answer

TRUNCATE is a DDL command whereas DELETE is a DML command. Hence DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back. WHERE clause can be used with DELETE and not with TRUNCATE.

psingla

 Profile Answers by psingla Questions by psingla

• Mar 16th, 2010

SQL Sever:Truncate:Delete all the records from the table.Do not keep the deleted record in the log file.Reset the identity column to 1.Use fewer locks with table level locking.Tollback is not possible...

saravanan p

• Dec 5th, 2006

Hi,1. For truncate command, trigger will not get fired, but for Delete Command, Trigger will get fired.2. Truncate Is the DDL command whereas Delete is the DML command3.Once the truncate command ...

Answer Question  Select Best Answer

malapati

 Profile Answers by malapati Questions by malapati

• Oct 9th, 2008

To copy a table along with records create table  as select *from ;if we want to copy only structure   create  table < new tablename> select *from  where ;

ravi

• Jun 12th, 2006

Yes , we can copy the table structure. create table as select * from where 1=2;

Answer Question  Select Best Answer

Rakesh

• Feb 7th, 2012

Normalization--To Reduce or to remove the redundancy in table we used Normalization and the normalization we can achieve by breaking of tables by this table is in Normalized.

prabu

• Jul 13th, 2011

0NF "sql CUSTOMER ORDER (CustName, OrderNo, ProdNo, ProdDesc, Qty, CustAddress, DateOrdered) 1NF - remove multivalued attributes "sql CUSTO...

Answer Question  Select Best Answer

farhad1

 Profile Answers by farhad1 Questions by farhad1

• Sep 24th, 2008

Select * from global_name;

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 5th, 2008

SQL> select name from v$database;NAME---------ORCL

Answer Question  Select Best Answer

rangunagaraj

 Profile Answers by rangunagaraj Questions by 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...

Answer Question  Select Best Answer

rajneeshbajwa

 Profile Answers by rajneeshbajwa Questions by rajneeshbajwa

• Dec 22nd, 2006

Hi Frienz...According to me WHERE and HAVING both are equally important..WHERE is used for condition on a single row and it comes before group by clause...whereas HAVING is used with GROUP BY alwayz.....

mamathi

• Oct 27th, 2006

we can use where clause for single function only. haveing clause we can use more then one function in a clause.exselect * from table namewhere salary > 10000;ex havingselect *from table namehaving sa...

Answer Question  Select Best Answer

kirandba

 Profile Answers by kirandba Questions by kirandba

• Apr 1st, 2010

Use below query to know index usage in SQL ServerSELECT   OBJECT_NAME(S.[OBJECT_ID]) AS [OBJECT NAME],          I.[NAME] AS [INDEX NAME],   ...

atdhdrolla

 Profile Answers by atdhdrolla Questions by atdhdrolla

• Jun 12th, 2008

sp_helpindex works for SQL server 2005

Answer Question  Select Best Answer

Lesley Ruzvidzo

• Nov 3rd, 2016

Theta join combines tubles from different tables(relation) provided they satisfy the theta condition.
Given R1(A1,A2,A3,...,An) and R2(B1,B2,B3,...,Bn) such that they have no common attributes i.e
R1 intersection R2 (R1 n R2) = Theta.
Theta can use all kinds of comparisons like =,>,< ...e.t.c.

sivaprasad

• Apr 10th, 2015

Theta join is nothing but not equi join, i.e.,it is a principle to join two tables with out any common column of both tables.

Answer Question  Select Best Answer

B

sivaganeshb

• Aug 14th, 2007

Here, you are de-referring an un-intialized pointer(segmentation fault). A file called?"core" will create and it contains the "images of that program"

sabeena

• Apr 20th, 2007

I want to know what Core Dump means.

Answer Question  Select Best Answer

jpundalik

 Profile Answers by jpundalik Questions by jpundalik

• Dec 30th, 2009

Below are the few difference between Stored Procedure and TriggersBoth are stored objects and stored in data base dictionariesStored Procedure- Can pass parameters- Manual execution requiredTriggers:- No parameters can be passed - Automatical executed when the event occurs

chennoju

 Profile Answers by chennoju Questions by chennoju

• Aug 3rd, 2006

Stored procedure and Trigger both will be in the database in precompiled formate which ready execute, the main difference between these two isto execute the stored procedure programe need to type...

Answer Question  Select Best Answer

CREATE TABLE temp(eno NUMBER CONSTRAINTS pk_eno PRIMARY KEY,gender CHAR(1) CHECK (gender IN( 'M','F')));INSERT INTO temp VALUES ('01','M');INSERT INTO temp VALUES ('02','M');INSERT INTO temp VALUES ('03','F');INSERT INTO temp VALUES ('04','M');INSERT INTO temp VALUES ('05','M');INSERT INTO temp VALUES ('06','F');INSERT INTO temp VALUES ('07','M');INSERT INTO temp VALUES ('08','F');COMMIT;UPDATE temp...

Pallavi g rao

 Profile Answers by Pallavi g rao Questions by Pallavi g rao

• Apr 22nd, 2011

Update emp set gender=case when gender='f' Then 'm'else 'f'end

Elena

• Nov 8th, 2007

Update   set gender=(case gender when 'F' then 'M' when 'M' then 'F' end)

Answer Question  Select Best Answer

srinu.oracle99

 Profile Answers by srinu.oracle99 Questions by srinu.oracle99

• Sep 1st, 2010

Equi Join is cartisan product of two tables and result is matching values of these tow tables but
both have common column.Union is just append two tables and restricts the duplicate rows and both tables have same number of columns.

sunil_ronanki

 Profile Answers by sunil_ronanki Questions by sunil_ronanki

• Nov 11th, 2008

Eqiui join is totally differene from unions Equijoin depends on a condition involving columns of both tables but where as in Union you can specify a condition based on a columns of the individual tables

Answer Question  Select Best Answer