Explain about ur projets on teradata???673
what is checksum in sql server.........???
how to retrieve data from different tables ,place this data in different excel worksheets.1 620
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it351
What is AUTH_ID and AUTH_USER in pl/sql ?651
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A407
----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 63 996
how to write customizations in po430
Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL1 1276
what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL360
What is Lock table in SQL?311
when MSQL8.0 is in market
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
if i want to display the name of students such that to which city they belong must have count greaer than two
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
WHAT KIND OF TOOL BO IS?
london school of science and technology has a software development unit,known as lsst solutions,which is responsible for developing and implementing software throughout the collegejames tristan keeps a record of all student details in the college including student id,name,and start date and phone number.There are many courses offered by LSST. For example MBA, MSc, BSc, BABS, DF, English etc. Each course id identified by course id, description, duration. Each course has many semesters. Each semester takes place during a particular term. Semester details and term details are required to be stored in the database. Each course has many subjects and same subject may be offered in many courses. For each subject many details such as Subject code, name, result and attendance are required to be stored. Every subject has mainly two assessments; one assignment and one exam. Assignment is worth of 30% and exam 70% respectively. You have been appointed as a database designer. Your job is to provide ERD with all possible entities and relationships. Note: Feel free to make necessary assumptions 3: Assignment Tasks. 1. Create an ERD for the above problem 2. Translate the ERD to Relational Data model (RDM) 3. Implement the RDM by creating the tables 4. Populate the database with your own data. 5. SQL Queries for the following tasks a. List all student details in each course along with course details b. Count and display number of students in each course. c. List student name, course name, assessment description, marks for all students.
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage
what is difference between sql plus and sql*plus? (not sql and sql plus).
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
Explain Capacity planning to create a database? and how to monitor it?
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
where the connection string store in the database
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?