Can any one guide me how can i import and export schema using SQL and OEM

Shaik Kareem

 Profile Answers by Shaik Kareem Questions by Shaik Kareem

• Jun 6th, 2011

Exp file=fullprd.dmp logfile=fullprd.log full=y

luzaolai

 Profile Answers by luzaolai Questions by luzaolai

• Apr 27th, 2009

In db2 three different format (ixf,del,asc) to export data:Export to tablename.ixf of ixf select * from tablename. When do import we can define if the original data should be kept or cleaned. Insert ...

Answer Question  Select Best Answer

I have a column in a table with names.Now i want to select that names like first name,second and third.I/p like this----- names Chandu Kannaka prasad Rama krishna Kiran kumar Kora Balaji Chandra sekhar pottaO/p I want------ Firstname Secondname Thirdname ...

skcwebworld

 Profile Answers by skcwebworld Questions by skcwebworld

• Aug 7th, 2015

"tsql declare @Name NVarchar(MAX), @FName NVarchar(MAX), @MName NVarchar(MAX), @LName NVarchar(MAX) select @Name = SAURABH KANT CHAKRAVARTI --select @Name = SAURABH KANT s...

farhanbaig

 Profile Answers by farhanbaig Questions by farhanbaig

• Jun 7th, 2011

I am guessing you are looking for initcap function which are as follows:select initcap(first_name||' '||second_name||' '||third_name) from employees;

Answer Question  Select Best Answer

display the second lowest salary from emp table without using min & all

Pendo

• Jul 17th, 2021

SELECT Top (1) Salary FROM Employee ORDER BY Salary

Code
 

satyam singh

• Apr 22nd, 2020

"HAVING" clause is required. It works with "GROUP BY" clause

Answer Question  Select Best Answer