As per my knowledge we cannot use Regular Expressions with drop stmt. You can delete multiple tables in a single statement by separating them with a comma.Ex:mysql> show tables;+--------------...

There is no way to delete multiple table at a time.
You can just drop a single table at a time.

Syntax:

table name.

Its a DB link which is used to access tables which reside on another server.
From the above query you are trying to access emp table which is in "WING" schema.
WING being on other server.

It is connection string

Hi shravanam,
Wht is this u r wrong?
Non-Euqijoin : Join more than one table with other than equlity operator (i.e. BETWEEN ... AND....)

Join is a query which retrieves related columns or rows from multiple tables. Self Join - Joining the table with itself. Equi Join - Joining two tables by equating two common columns. Non-Equi Join - ...

i. YOU CAN NOT DELETE A PARENT TABLE WITHOUT DELETING CHILDREN TABLES. BUT VICE VERSA CAN TAKE PLACE.II. IF YOU HAVE ITEM CATEGORY THEN U CAN HAVE GROUP BY EXPRESSION ON ITEM_CATEGORY.III. DELETE FROM...

(1) use cascade option in query

See, in oracle to maintain read consistency oracle keeps a copy in undo section of database for the data which is under modification by some transaction. And so readers do not wait for writers and ca...

In before update/delete trigger if we use select statement for fetching the records.in this scenario will wet mutating trigger error.using row level trigger we can avoid instead of statement level trigger. we can accurate results.

NO YOU CANNOT WRITE A FUNCTION WITHOUT RETURNING A VALUE.
IT SHOULD RETURN ATLEAST ONE VALUE.........


WITH REGARDS,
SHARAT

No, we can not write a function witout a function

Regards

Pawan Ahuja

TRY THIS

SELECT ENAME||' ' ' '||'S' FROM EMP:

Hi

You just need to do this: ename||'''||'s'.

If ename := 'Scott', the output is Scott's.

Regards

Jos Baptista 

SELECT TEXT FROM USER_SOURCE WHERE NAME='PROCEDURE/FUNCTION/PACKAGE/PACKAGEBODY'
/

USER_SOURCE data dictionary view describes the text source of the stored objects owned by the current user wether it is procedure or function. Its columns (except for OWNER) are the same as those in All_source data dictionary view .

Thanks

Subasini 

select e_name,e_salary from emp where e_salary=(select min(e_salary)  from (select e_salary from emp order by sal desc )where rownum<4; 

I think we can also use this:

select emp_name from from where rownum=3 order by salary desc

SYNTAX:

INSERT INTO VALUES('&COLUMN1'(STRINGS,DATES),&COLUMN2);


EXAMPLE:

INSERT INTO EMP VALUES('&ENAME',&EMPNO);

SYNTAX

insert into table_name &column1,..... values (.......);

e.g:

insert into emp (emp_name,emp_id) values('&emp_name','&empid');

what harsha said is right.
in addition to the above reports there are 3 more triggers
1. VALIDATION TRIGGERS
2.FORMAT TRIGGERS
3.ACTION TRIGGERS

Report Customization means taking the orginal oracle report and modifing ( changing layout, query- by adding some more field....) according the user requirement.There are 5 types of report triggers1)B...

1. When you create more indexes on a table , for example  table A has 10 columns and you have create 8 indexes on that table. Then whenever you r going to retrieve data from that table each row o...

3.If we have the null values in the column then we can not create primary key trigger on that column.

4. It is an event that raised implicitly when you update the table.

Regards,
Sushma

procedure wont retrun any value but it can return many values on condition. but function always returns a values

A procedure is used to perform a specific task. It can also return a value but its not mandatory.

But a function is used to perform some calculations and it is mandatory to return atleast one value.

Dual is default table in oracle .it contains single row and single column.All the Character functions and number functions and date functions execution done in this Dual table.

Dual is a dummy table which has one row and one column but can't make the DML opertions.

create table emp as select * from student where 1=2;

select * from faculty where rownum=0;

In varchar u can store upto 2000 bytes
In varchar2 u can store upto 4000 bytes
In Oracle  even if u declare a variable with varchar it takes varchar2 into consideration and creates that variable with varchar2

Varchar and Varchar2 is different.
Varchar and varchar2 store is 2000 char.

varchar2 size is automatically reduce. It will take on using char size based.

You can remove a column but first of all you should see that column doest have any values and it should not be a primary key

ALTER TABLE DROP COLUMN

To drop a Column from a Table.The command is.

Sql>Alter table

.

User Panel

Register

Login

Lost Password

Get Activation Code

Categories

Engineering

Interview Coaching

Interview Questions

Tech FAQs

Interview Coaching

BPO Career for BTech Graduates

Has anyone asked you for help? What did you do?

What do you do when things do not go as planned? Cite an example.

What are my options when I do not get a job after graduation?

Career Options for BCA Graduates

What is the role of a mechanical engineer in the Software Industry?

Have you gone above and beyond your job description?

Describe a time when you had to work under pressure.

How to Overcome Employment Gap during interview.

What was the most important decision you ever had to make?

Interview Question

 Ask Interview Question?

 

Career Counselling

 Have Career Question?

 Ask Chandra

 Ask Only Career questions.

Follow us:

 

GeekInterview

• About Us,
• Privacy Policy,
• Terms and Conditions,
• DMCA,
• Contact Us

Popular Sections

• Code,
• Learn,
• Online Testing,
• Geek Talk,


• Propose Category,
• Ask Question,
• Site Updates

Copyright © 2013 GeekInterview.com | All Rights Reserved
NH