sql oracle commands
Posted: Tue May 24, 2022 8:29 am
sql oracle commands
First of all must screen shot the all command .together on program -Create Table with Name :customer Email_name CustomerN Custome City ame rID Faisal 1 Makk ah Faisal_m96@gm ail.com Jubail [email protected] Gasan 2 om Your email Your name 3 Riyad h Taif Name 4 Email another student another student The email column must be by your name like:Email_Raghad - Create Table with Name : Order
Wirte the command to create like Table- Bill_name OrderDate CustomerID OrderID another student 6000 2022-3-3 3 101 6500 2022-3-2 1 102 7000 2022-3-21 4 103 7500 2022-3-19 2 104 The Bill column must be by your another student name name like:Billl_Raghad Must be the tow table have primary key and create foreign key from order to customer and -(show me all data(0.5 .(Apply :left join all data (0.5- Create view with(your name) to select CustomerID,Bill(0.75). Show me view (0.25).- Create function (name another student) to get maximum bill(0.75). -.(Apply function (0.25
- Sql Oracle Commands 1 (65.17 KiB) Viewed 15 times
- Sql Oracle Commands 2 (82.37 KiB) Viewed 15 times
Wirte the command to create like Table- Bill_name OrderDate CustomerID OrderID another student 6000 2022-3-3 3 101 6500 2022-3-2 1 102 7000 2022-3-21 4 103 7500 2022-3-19 2 104 The Bill column must be by your another student name name like:Billl_Raghad Must be the tow table have primary key and create foreign key from order to customer and -(show me all data(0.5 .(Apply :left join all data (0.5- Create view with(your name) to select CustomerID,Bill(0.75). Show me view (0.25).- Create function (name another student) to get maximum bill(0.75). -.(Apply function (0.25